Please use excel functions

4) A sales manager collected the following data on annual sales and years of experience. Years of Annual Sales Salesperson Experience ($1000s) 80 97 02 102 103 111 119 123 117 a) Develop a scatter diagram for these data with years of experience as the independent variable. b) Develop an estimated regression equation that can be used to predict annual sales given the years of experience. Write down the estimated regression equation for average sales. c) Use the estimated regression equation to predict annual sales for a salesperson with 9 years of experience (Pay attention to Units while answering the question). d) What are the values for: SST, SSR, and SSE. e) Compute the coefficient of determination r2. Comment on the goodness of fit. f) What is the value of the sample correlation coefficient? g) Conduct p-Value as well as Critical-Value based Hypothesis Tests to determine the significance of regression. Use a = 0.05. Is the regression statistically significant