please solve in excel woth formulas

Problem 7-(Optional) Saba, Inc. has provided the following information regarding one of their products. Use 90% confidence for this problem. Dafa are shown in the next sheet. 1. Sales in $10,000(Y) 2. Advertising in $1,000 (X1) 3. Price in dollars (X2) 4. Competitor's Price in dollars (X3) 5. Number of Employees (X4) 6. Rating (X5) 7. Year (X6) a. Run a correlation analysis and explain your results. Be sure to discuss the concept of multicollinearity. b. Run a regression analysis relating sales (Y) and all the independent variables. Is the regression model significant? Explain how you arrived at your answer. Give numerical values to support your answer. c. Which variables are significant, and which are not? Explain how you arrived at your answer. d. Drop the variable(s) that at 90% confidence were not significant. Run a new regression analysis. Write your estimated regression equation. e. What is the value of R-square you found in part " d "? Fully and in detail explain the meaning of the R-square that you found. f. Use the model of part " d " and forecast sales for 2021 through 2024 , assuming the company is planning to increase advertising by 3% and price by 7% annually for the next four years. It is estimated that competitor will be decreasing their price by 0.5% annually for the next four years. Show your computations and write your answers below. Please show your Excel computations to each part and clearly label various parts. Write the answers to nart f below. Problem 7-(Optional) Saba, Inc. has provided the following information regarding one of their products. Use 90% confidence for this problem. Dafa are shown in the next sheet. 1. Sales in $10,000(Y) 2. Advertising in $1,000 (X1) 3. Price in dollars (X2) 4. Competitor's Price in dollars (X3) 5. Number of Employees (X4) 6. Rating (X5) 7. Year (X6) a. Run a correlation analysis and explain your results. Be sure to discuss the concept of multicollinearity. b. Run a regression analysis relating sales (Y) and all the independent variables. Is the regression model significant? Explain how you arrived at your answer. Give numerical values to support your answer. c. Which variables are significant, and which are not? Explain how you arrived at your answer. d. Drop the variable(s) that at 90% confidence were not significant. Run a new regression analysis. Write your estimated regression equation. e. What is the value of R-square you found in part " d "? Fully and in detail explain the meaning of the R-square that you found. f. Use the model of part " d " and forecast sales for 2021 through 2024 , assuming the company is planning to increase advertising by 3% and price by 7% annually for the next four years. It is estimated that competitor will be decreasing their price by 0.5% annually for the next four years. Show your computations and write your answers below. Please show your Excel computations to each part and clearly label various parts. Write the answers to nart f below