Asales 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

compute b1 and b0 (to 1 decimal).

b1 =

b0 =

complete the estimated regression equation (to 1 decimal).

= + x

according to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal)?

compute the coefficient of determination (to 3 decimals). note: report r2 between 0 and 1.

r2 =

what percentage of the variation in annual sales ($1000s) can be explained by the years of experience of the salesperson (to 1 decimal)?