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. Conduct a regression analysis to explore the relationship between these two variables and then answer the following questions.

\fA 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. Conduct a regression analysis to explore the relationship between these two variables and then answer the following questions. Open spreadsheet a. Compute b1 and bo (to 1 decimal). b1 = 81 X bo = 3.84 X Complete the estimated regression equation (to 1 decimal). y = 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. 12 = What percentage of the variation in annual sales ($1000s) can be explained by the years of experience of the salesperson (to 1 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)? $