Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For this assignment, you will be creating two forecasts based on Canadian airline passenger data from January 2 0 1 5 to December 2 0
For this assignment, you will be creating two forecasts based on Canadian airline passenger data from
January to December
Open the ForecasngDataxlsx file that can be found on Slate.
Create a forecast that extends to leaving all other opons unchanged ie their
default
Rename the worksheet to Forecast
In a blank cell eg cell G briefly describe the issues with this forecast, why it cannot be used
and the main reason for the flaws in this forecast.
Create a second forecast that extends to Alter the Forecast Start to resolve the issue
idenfied in step Change the confidence interval to and ensure you include forecast
stascs in the forecast.
Rename the worksheet to Forecast
Clean up the Chart, adding an appropriate Title, Trendline choose the one that best suits the
data change the Upper Confidence Bound line to the colour green and the Lower Confidence
Bound line to the colour red. Format the Trendline that you added so that is more visible.
Save the file call it ForecasngDataGroupX.xlsx replacing X with your group number and
submit to the Assignment dropbox.
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