This assignment has 2 parts. Part 1 has questions about forecasting. You will use the template that is provided in the attachments for this Part.Part 2 requires you to analyze a case. For this, you wi
Unit 6 Dropbox Assignment Answers by (Insert your name here)This template is only for the first part of the Assignment. See specific instructions in the Assignment for part 2.
In the summary tables below, insert only the answers. You will show work after the summary section.
Question 1 MAD | |
MSE |
| |
| |
| |
d) MAD for part b | |
e) Recommended forecast method (justify): |
R-squared for Linear model | |
R-squared for polynomial model | |
Regression formula for linear model | |
Regression formula for polynomial model | |
Recommended forecast method (justify): |
Show all your work for the questions below.
Question 1Show the errors you calculated.
Question 2Show the two forecasts and the errors.
Question 3Show the polynomial and linear trendline charts from Excel charting. Do not use multiple regression analysis for this question.