Question
Please in excel , this it , this is the complete question. ??? part a ) Develop a linear trend forecast part b ) Add
Please in excel , this it , this is the complete question.
???part a) Develop a linear trend forecast
part b) Add a quadratic component to the model in part (a) and develop a new forecast
part c) Now assume a seasonal pattern and add the seasonality of the months to the linear trend model in part (a) and develop a new forecast
part d) Provide the MSE from the 3 models here
MSE Model aMSE Model bMSE Model c
part e) Based on your answers to part d, for whichever forecast model you deem to be the best, draw a time series graph of both the original time series and the "best" forecast
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started