Jake, the owner of the Jake Automotive, wanted to examine the relationship between the number of...

 

Transcribed Image Text:

Jake, the owner of the Jake Automotive, wanted to examine the relationship between the number of cars that his sales associates sold and their happiness level of work-life balance holding average work hours constant. As in the datasheet, Jake has collected data from 49 sales associates. Columns B, C, and D represent the average number of cars sold per month, average work hours per week, and happiness level with the work-life balance of the sales associates, respectively. Question 1-1. Conduct a simple linear regression analysis with the number of cars sold per month as the independent variable (X) and happiness level with work-life balance as the dependent variable (Y). What is the estimated linear regression equation? (4 points) Question 1-2. Explain the relationship between the number of cars sold per month and happiness level with work-life balance based on the simple linear regression equation that you have estimated in Question 1-1. Also, report the p-value for the coefficient of interest. (6 points) Question 1-3. Now, conduct a multiple linear regression with the number of cars sold per month and average work hours per week as the independent variables (xs) and happiness level with work-life balance as the dependent variable (Y). What is the estimated linear regression equation? (4 points) Question 1-4. Explain the relationship between the number of cars sold per month and happiness level with work-life balance based on the multiple linear regression equation that you have estimated in Question 1-3. Also, report the p-value for the coefficient of interest. (6 points) ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Average # of cars sold per month 4.1 2.6 2.1 2.9 11.2 1.7 6.6 6.4 5.0 4.7 11.1 7.6 4.8 6.0 2.6 5.7 1.6 6.2 10.6 4.2 4.6 8.1 2.8 8.1 2.8 6.1 6.2 5.8 4.5 6.6 9.8 10.7 3.8 6.1 5.6 4.4 3.2 6.8 5.9 1.6 8.9 7.2 4.8 4.6 3.8 6.9 6.6 2.1 5.5 Average work hours per week 36 43 25 27 88 72 42 61 58 82 45 43 67 41 41 39 25 43 65 27 69 78 42 75 41 53 80 32 31 44 42 83 67 74 66 62 45 36 52 78 72 70 32 51 29 68 66 21 48 Happiness level with work-life balance. 4 3 4 5 1 3 3 3 3 3 3 3 2 3 5 4 4 3 3 5 3 2 4 1 4 3 2 4 4 3 4 1 2 3 3 3 2 4 3 2 2 2 4 3 4 3 3 2 3 *Happiness level with work-life balance 1 = Extremely unhappy with work-life balance 2= Unhappy with work-life balance 3= Neither happy nor unhappy with work-life balance 4 = Happy with work-life balance 5=Extremely happy with work-life balance Jake, the owner of the Jake Automotive, wanted to examine the relationship between the number of cars that his sales associates sold and their happiness level of work-life balance holding average work hours constant. As in the datasheet, Jake has collected data from 49 sales associates. Columns B, C, and D represent the average number of cars sold per month, average work hours per week, and happiness level with the work-life balance of the sales associates, respectively. Question 1-1. Conduct a simple linear regression analysis with the number of cars sold per month as the independent variable (X) and happiness level with work-life balance as the dependent variable (Y). What is the estimated linear regression equation? (4 points) Question 1-2. Explain the relationship between the number of cars sold per month and happiness level with work-life balance based on the simple linear regression equation that you have estimated in Question 1-1. Also, report the p-value for the coefficient of interest. (6 points) Question 1-3. Now, conduct a multiple linear regression with the number of cars sold per month and average work hours per week as the independent variables (xs) and happiness level with work-life balance as the dependent variable (Y). What is the estimated linear regression equation? (4 points) Question 1-4. Explain the relationship between the number of cars sold per month and happiness level with work-life balance based on the multiple linear regression equation that you have estimated in Question 1-3. Also, report the p-value for the coefficient of interest. (6 points) ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Average # of cars sold per month 4.1 2.6 2.1 2.9 11.2 1.7 6.6 6.4 5.0 4.7 11.1 7.6 4.8 6.0 2.6 5.7 1.6 6.2 10.6 4.2 4.6 8.1 2.8 8.1 2.8 6.1 6.2 5.8 4.5 6.6 9.8 10.7 3.8 6.1 5.6 4.4 3.2 6.8 5.9 1.6 8.9 7.2 4.8 4.6 3.8 6.9 6.6 2.1 5.5 Average work hours per week 36 43 25 27 88 72 42 61 58 82 45 43 67 41 41 39 25 43 65 27 69 78 42 75 41 53 80 32 31 44 42 83 67 74 66 62 45 36 52 78 72 70 32 51 29 68 66 21 48 Happiness level with work-life balance. 4 3 4 5 1 3 3 3 3 3 3 3 2 3 5 4 4 3 3 5 3 2 4 1 4 3 2 4 4 3 4 1 2 3 3 3 2 4 3 2 2 2 4 3 4 3 3 2 3 *Happiness level with work-life balance 1 = Extremely unhappy with work-life balance 2= Unhappy with work-life balance 3= Neither happy nor unhappy with work-life balance 4 = Happy with work-life balance 5=Extremely happy with work-life balance