Answered step by step
Verified Expert Solution
Link Copied!

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 2015 to December 2022.
1. Open the ForecasngData.xlsx file that can be found on Slate.
2. Create a forecast that extends to 12/1/2027, leaving all other opons unchanged (i.e., their
default).
3. Rename the worksheet to Forecast1.
4. In a blank cell (e.g., cell G2), briefly describe the issues with this forecast, why it cannot be used
and the main reason for the flaws in this forecast.
5. Create a second forecast that extends to 12/1/2027. Alter the Forecast Start to resolve the issue
idenfied in step 4. Change the confidence interval to 90% and ensure you include forecast
stascs in the forecast.
6. Rename the worksheet to Forecast2.
7. 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.
8. Save the file (call it ForecasngData_GroupX.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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Information Systems

Authors: James O'Brien

7th Edition

007293588X, 9780072935882

More Books

Students also viewed these General Management questions