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 experlence 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. b0= 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 r2 between 0 and 1 . r2= What percentage of the variation in annual sales ( $1000 s) 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 annuat sales (\$1000s) for the new salesperson (to the nearest whole number)? \begin{tabular}{|l|lrr|} \hline 1 & \multicolumn{4}{c}{ B } & \multicolumn{1}{c}{} \\ \hline 2 & Yalesperson & Years of Experience & Annual Sales ($1000) \end{tabular}