Harvard University Regression Equation Statistics Questions
Need the following questions answered – based on the attachmentQuestion 1In this case, the dependent variable is Term 1 (MONTH OR SALES), and theindependent variable is Term 2 (MONTH OR SALES)Question 21. This model is a _____ model.A. Simple exponential trendlineB. Multiple regressionC. Simple linear trendlineQuestion 31. Use a proper regression equation to fit the data. Round theparameters of the regression equation to 4 decimal places. According toyour result of the regression, sales increases by ______% per month?Format: 100.0Question 41. Based on the regression equation, forecast the sales volume for thefirst month of year six, that is, month 61. Format: 1,000Question 51. On average, the predictions are missing by ______%. Put differently,what is the value of MAPE? Format: 100.00Question 61. The prediction errors will be in the neighborhood of Blank 1 ;Format: 1,000Blank 2 % of the variation of sales is explained by the model; Format:100.00Question 71. Use the Data Analysis add-in to obtain a linear regression, and keeptrack of the following measures of the goodness of fit:The Stand Error of the regression is Blank 1 ; format: 1,000The R Square is Blank 2 %; format: 100.00Question 81. Based on the measures of goodness of fit you obtained in question 5and 6, which regression is a better fit?A. The Exponential RegressionB. The Linear RegressionC. Indeterminate
We offer the best custom essay writing services at an affordable rate. We have done this assignment before, we can also do it for you.