please refer to attachment

cam Question Paper - copy (1) - Word Search ices Mailings Review View Help AaBbCcI AaBbCcDd Aab AaBbCCI AaBbC A 1 Normal Subtitle Title Body Text 1 No Spac Paragraph Styles Question 5 (20 marks) One of your colleagues suggests that less-experienced store managers tend to have a higher average loss per item stolen. To test this relationship, you collect data on a sample of losses. For each loss, you record the loss value ($) and the number of years of experience that the store manager had. In a regression analysis, the dependent variable is the loss value ($) and the independent variable is the years of experience of the store manager. The output is below. SUMMARY OUTPUT Regression Statistics Multiple R 0.5111327 R Square 0.2612567 Adjusted R Square 0.2427881 Standard Error 18.9012999 Observations 42 ANOVA df SS MS F Significance F Regression 1 5053.78978 5053.78978 14.14601 0.00054 Residual 40 14290.36552 357.25914 Total 41 19344.15530 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 103.02327 7.07322 14.56527 0.00000 88.72777 117.31878 Years Experience -6.16926 1.64027 -3.76112 0.00054 -9.48437 -2.85414 Required: Describe the relationship between the experience of the store manager (in years) and the average value of the items stolen. Include relevant statistics in your