hi please see the attached photos and asnwer the questions
- I) .3 elearning.kbs.edu.au C- . ' " " ' . A publishing company is interested in understanding the relationship between the years of experience of its sales staff and their annual sales. The data they collect from a random sample of 12 sales representatives is reported below. Annual sales [51,0005] (y) Years dl'experlence (1r) 477.26 2.91 Finish attempt 458.35 51 Time left 1:49:10 261.12 2 641 3.08 192.61 1.94 443.8 6.12 '- 349.46 7.35 242.76 1 315.12 4.12 279.76 2.1 641.9 9.09 546.11 6.18 Mean annual sales are $404.52 [in 51,0005) and the mean number of years work experience are 4.57. Linear regression analysis is undertaken using Excel and the output is reported in the following table. SUMMARY OUTPUT elearning.kbs.edu.au C (8,264 unre.. m Subject Ho. m 2020, Topic:. m Assessment. G Heterosked. (3) WhatsApp C Get Homew. G zookal hom. *Homework.. G how to take. + Mean annual sales are $404.52 (in $1,000s) and the mean number of years work experience are 4.67. Linear regression analysis is undertaken using Excel and the output is reported in the following table. SUMMARY OUTPUT Regression Statistics Multiple R 0.82909202 R Square 0.68739358 Adjusted R Square 0.65613294 Standard Error 90.2743705 Observations 12 ANOVA df SS MS F Significance F Regression 1 179199.385 179199.385 21.9891062 0.0008554 Residual 10 81494.6198 8149.46198 Total 11 260694.005 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 184.76 53.62 3.45 0.01 65.28 304.24 Years of Exp (x) 47.02 10.03 4.69 0.00 24.68 69.36 elearning.kbs.edu.au C (8,264 unre.. m Subject Ho. m 2020, Topic:.. m Assessment. G Heterosked.. (3) WhatsApp C Get Homew. G zookal hom. *Homework.. G how to take. + Residual 10 81494.6198 8149.46198 Total 11 260694.005 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 184.76 53.62 3.45 0.01 65.28 304.24 Years of Exp (x) 47.02 10.03 4.69 0.00 24.68 69.36 State the linear regression equation for this data and interpret both the intercept and the slope coefficient. (5 marks) A B I 0 elearning.kbs.edu.au C (8,264 un.. m Subject H.. m Topic: Ex. m Assessm. G If a confid. G Heterosk (3) Whats.. C Get Hom. Z Zookal H. *Homewor.. G how to ta. + KAPLAN BUSINESS SCHOOL Sinchit Takkar AUSTRALIA MyKBS Campuses My Services Academic My Subjects Q Home > My Subjects > STAM4000 T2 2020 > Assessment 03: Final Exam Question 8 Not yet answered Marked out of 4.00 P Flag question Quiz navigation Using the Excel output from Question 7, at a 0.01 level of significance conduct a formal test to see if there is a significant linear 2 3 4 5 relationship between sales and experience. Comment on the goodness of fit of the estimated regression model. (4 marks) 6 9 10 A B 11 12 13 14 Finish attempt .. Time left 1:33:28 Previous page Next page 0 elearning.kbs.edu.au C (8,264 un.. m Subject H.. m Topic: Ex. m Assessm. G If a confid. G Heterosk (3) Whats.. C Get Hom. Z Zookal H. *Homewor.. G how to ta. + KAPLAN BUSINESS SCHOOL Sinchit Takkar AUSTRALIA MyKBS Campuses My Services Academic My Subjects Q Home > My Subjects > STAM4000 T2 2020 > Assessment 03: Final Exam Question 9 Not yet answered Marked out of 4.00 Flag question Quiz navigation Using the Excel output from Question 7, predict the value of sales when experience is 8 years, and also for when experience is 2 3 4 5 16 years. Which of these two predictions is likely to be more reliable? Explain why. (4 marks) 6 9 10 A B E 11 12 13 14 Finish attempt .. Time left 1:33:24 KAPLAN Previous page Next page
