Food Prep Appliances Analysts at a company that produces small appliances

Food Prep AppliancesAnalysts at a company that produces small appliances are looking at sales of 24 food preparation products in a medium-sized city in the Midwest U.S. They have noticed that sales have not met forecasts values for several months and want to look at the issue in more detail. What have you learned from your regression model using the data in file? What conclusions would you share with the company analysts?Do this all in Excel and have answers in Excel with explanationsModel specificationo Identify the dependent variable and the independent variables to be included in the modelo Explain the expected sign (+, -, ?) for each of the independent variablesoProvide a correlation matrix with all independent variables and indicate extent to whichmulticollinearity may be a problem and what you might do to alleviate it.Model EstimationoReport the coefficients and absolute value of t-statistics for the coefficients of eachindependent variableModel EvaluationoTest for the statistical significance of each independent variable and when significant, thelevel of significance.oInterpret the coefficient for each independent variable, remembering that an insignificantcoefficient is interpreted as zero or having no effect on the dependent variable. Does thecoefficient make sense?oEvaluate the performance of the total model and the statistical significance of the model’s(all variables together) explanatory power.Highlight key conclusions of the regression.