Help with question 8 please

Important Notice: All team members must work on all parts and compare results for accuracy. Only one team member will upload an Excel file of analysis. Sales manager of a company wishes to evaluate the performance of the company's gales representatives. Each sales rep. is solely responsible for one sales territory, and the manager decides that it is reasonable to measure performance, Y, of a gales rep. by using the yearly sales of the company product in the representative's gales territory. The manager feels that sales performance substantially depends on eight independent variables: Time: Number of months the rep. has been employed by the company Mlstegten: Sales of the company's company and competing products in the sales territory, a measure of gales potential. AdsFxD: Advertising expenditure in the territory MldtShace: weighted average of the company's market ghare in the territory for the previous four years Change: Change in the company's market ghare in the territory over the previous four years Accts: Number of accounts handled by representative Juktoad Average workload per account based on sizes of order and other workload related Sales: The dependent variable indicating number of units sold 1- Make scatter plot of all variables against Sales (Y-axis). Find the best fitted linear equation and R2 for all 7 gcatter plots and explain any gignificant relationship you may observe. 2- Make a correlation coefficient matrix of all 8 variables. Rank variables based on their level of correlation (absolute value) with Sales. Discuss findings based on the correlation matrix. 3- Find simple linear regression models of 3 of the highest correlated variables with price ( 3 models). Observe Multiple R, R-squared, Significant F, P-values and interpret. 4- Construct a full 7 variable regression model and formulate model equation to predict sales. Observe Multiple R, R-squared, Significant F, P-values and interpret. Rank the P-values of all 7 independent variables based on the degree of contribution to the model (highest to lowest contribution) 5- Select the top 5 gignificant variables (lowest p-values) in part 4 and use them in parts 6,7,8, and 9 as indicated. 6- Find the best multiple linear regression (based on R2 ) using two independent variables. Observe Multiple R, R-squared, Significant F, P-values and interpret. Observe the residuals and standard residuals of the model. Use the following guidelines to assign performance rating on scale of 1-7. Tf the standard rocininalo is: 7- Find the best multiple linear regression using three independent variables. Observe Multiple R, R-squared, Significant F, P-values and interpret. Observe the residuals and standard regiduals of the model. Assign ratings based on table above. 8- Find the best multiple linear regression using four independent variables. Observe Multiple R, R-squared, Significant F, P-values and interpret. Observe the residuals and standard residuals of the model. Assign ratings based on table above. 9- Find the best multiple linear regression using five independent variables. Observe Multiple R, R-squared, Significant F, P-values and interpret. Observe the residuals and standard regiduals of the model. Assign ratings based on table above. 10- Use model in part 9 to rank sales rep. performance from highest to lowest. Indicate top 3 and bottom 3 performers. 11- Use model in part 0 in find salas forrarsot for ranrasentative with following data: 12- Provide brief conclusion of your amalxsis.GROLP. Grading Criteria Completeness/CorrectnessQualityofInterpretations/AnalysisGeneralQualityofReport/graphs/writing70%20%10% Due: October 4, 2023