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.

Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add$-$in manually from the home ribbon. Screenshot of ToolPak

Open spreadsheet

a$.$ Compute $b_1$ and $b_0($to $1$ decimal$).$

$b_1=$

$b_0=$

Complete the estimated regression equation $($to $1$ decimal$).$

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

c$.$ Compute the coefficient of determination $($to $3$ decimals$).$ Note: report $r^2$ between $0$ and $1.$

$r^2=$

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

$4\mathrm{.}55\%$

d$.$ A new salesperson joins the team with $8$ years of experience. What is the estimated annual sales $($ $$1000$ s$)$ for the new salesperson $($to the nearest whole number$)?$