Please help me answer parts a-d on this first question.

Excel template - Saved v Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help W Arial v 10 B ab D1 fx D E F A Salesperson 1 2 3 4 5 6 7 8 9 10 11 12 13 14 B C Years of Experience Annual Sales ($1000s) 1 84 2 100 3 90 4 98 5 100 6 110 7 10 120 8 10 125 9 12 119 10 14 141 32 3 4 58 21 CENGAGE MINDTAP Q Search this course BA4 - Ch. 7 Excel Activity 4 - Regression Equations, Predictions, and Coefficient of Determination with XL Miner Analysis ToolPak X Question 1 0/5 Open spreadsheet Submit a. Compute b 1 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 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)? % d. A new salesperson joins the team with 6 years of experience. What is the estimated annual sales ($1000s) for the new salesperson (to the nearest whole number)? $ Back Next Excel template - Saved v Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help W Arial v 10 B ab D1 fx D E F A Salesperson 1 2 3 4 5 6 7 8 9 10 11 12 13 14 B C Years of Experience Annual Sales ($1000s) 1 84 2 100 3 90 4 98 5 100 6 110 7 10 120 8 10 125 9 12 119 10 14 141 32 3 4 58 21 CENGAGE MINDTAP Q Search this course BA4 - Ch. 7 Excel Activity 4 - Regression Equations, Predictions, and Coefficient of Determination with XL Miner Analysis ToolPak X Question 1 0/5 Open spreadsheet Submit a. Compute b 1 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 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)? % d. A new salesperson joins the team with 6 years of experience. What is the estimated annual sales ($1000s) for the new salesperson (to the nearest whole number)? $ Back Next