Video 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 fille 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 2. Computed, and by to 1 decimal). bi by 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 between 0 and 1. 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 in the team with 6 years of experience. What is the estimated annual sales ($1000s) for the new salesperson to the nearest whole number? File Home Insert Formulas Data Review View Help Tell me w $ X Cut LL Copy Arial - 10 w A A Paste BI U Dab OASE Format Painter Clipboard Unde Font Alignment 01 D E Salesperson 2 2 4 Ah 5 B C Years of Experience Annual Sales ($1000s) 2 78 2 95 5 90 4 104 7 108 9 110 9 121 11 120 11 14 137 1 2 3 4 5 6 7 8 9 10 6 7 8 9 10 11 12 13 14 15 16 115 18 19 20 21