Question 7: In Excel, prepare a regression analysis for the utility costs. (Copy and paste a screenshot of your regression analysis in your word document). Assess the regression analysis result using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Prepare the cost estimation formula of the utility costs for the accounting manager. (10 marks) To help estimate the plan utilities costs, the accounting manager has pulled the following data for 20222023 : Question 7: In Excel, prepare a regression analysis for the utility costs. (Copy and paste a screenshot of your regression analysis in your word document). Assess the regression analysis result using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Prepare the cost estimation formula of the utility costs for the accounting manager. (10 marks) To help estimate the plan utilities costs, the accounting manager has pulled the following data for 20222023