dolution

A sales manager collected data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. In the Microsoft Excel Online file below you will find a sample of data on years of experience of the salesperson and annual sales Conducta regression analysis to explore the relationship between these two variables and then answer the following questions ? Open spreadsheet a. Compute band boto 1 decimal). D- Complete the estimated regression equation (to 1 decimal). b. According to this model, what is the change in annual sales ($10000) for every year of experience to a deemal c. Compute the coefficient of determination (to 3 decimals). Note: report between 0 and 1. What percentage of the variation in annual sales ($1000s) can be explained by the years of experience of the salesperson (tot decimal)? d. A new salesperson joins the team with 8 years of experience. What is the estimated annual sales ($1000s) for the new salesperson to the nearest whole number) D1 < fx D E E A 1 Salesperson 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 B ? Years of Experience Annual Sales ($1000s) 1 1 78 2 3 98 3 4 92 4 5 103 5 5 105 6 7 113 7 11 122 8 9 121 9 10 114 10 12 131 24