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.

D A Salesperson B Years of Experience Annual Sales ($1000s) 1 2 84 2 3 98 3 4 87 4 5 101 5 5 99 6 7 115 7 9 114 8 10 123 9 12 122 10 13 139 a. Compute by and bo (to 1 decimal). b1 = bo 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. 2= 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)? $ D A Salesperson B Years of Experience Annual Sales ($1000s) 1 2 84 2 3 98 3 4 87 4 5 101 5 5 99 6 7 115 7 9 114 8 10 123 9 12 122 10 13 139 a. Compute by and bo (to 1 decimal). b1 = bo 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. 2= 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)? $