Excel Freeform Activity: Linear Regression and the Coefficient of Determination A sales manager collected data on annual sales for new customer accounts and the number of years of experience Online file below you will find these two variables and then answer the following questions. for a sample of 10 salespersons. In the Microsoft Excel a sample of data on years of experience of the salesperson and annual sales. Conduct a regression analysis to explore the relationship between Open spreadsheet a. Compute b and bo (to 1 decimal). Complete the estimated regression equation (to 1 declmal). b. According to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal)? c. Compute the coefficient of determination (to 3 decimals). Note: report 2 between 0 and 1. What percentage of the variation in annual sales (s1000s) can be explained by the years of experience of the salesperson (to 1 decimal)? d. A new salesperson joins the team with 6 years of experience. What is the estimated annual sales ($1000s) for the new salesperson (to the nearest whole nu 1|Salesperson XLMiner Analysis ToolPak Years ot Experience Annual Sales (S1000s) 6 97 102 101 109 119 123 Linear Regression rput y Range input X Range Labels Constant is Zero confidence Levet g5% 10 12 10 10 134 Output Range Residuals 15 Residual Plots Standardiced Residuals ure Fit pets Normal Probability Plots 19 Sheetl