Copy of Copy of P11-Airline - North-South Airline...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
North-South Airline Forecasting Causal regression analysis Input Data Forecast Error Analysis Period Forecast Error Year 1 51.8 6512 53.020 -1.220 1.220 1.489 2.36% Year 2 54.92 8404 57.937 -3.017 3.017 9.103 5.49% Year 3 69.7 11077 64.884 4.816 4.816 23.197 6.91% Year 4 68.9 11717 66.547 2.353 2.353 5.537 3.42% Year 5 63.72 13275 70.596 -6.876 6.876 47.277 10.79% Year 6 84.73 15215 75.638 9.092 9.092 82.673 10.73% Year 7 78.74 18390 83.889 -5.149 5.149 26.509 6.54% Average 4.646 27.969 6.61% Intercept 36.097 MAD MSE MAPE Slope 0.0026 SE 6.258 Forecast 36.097 Correlation 0.877 r-squared 0.769 Dep Variable (or) (Y) Indep Variable (or) (X) Absolute error Squared error Absolute % error Enter the (Y,X) pairs in cells shaded YELLOW. Enter new value of X at the bottom to forecast Y. Enter the (Y,X) pairs in cells shaded YELLOW. Enter new value of X at the bottom to forecast Y.
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
North-South Airline Forecasting Causal regression analysis Input Data Forecast Error Analysis Period Forecast Error Year 1 43.49 6512 37.785 5.705 5.705 32.550 13.12% Year 2 38.58 8404 42.786 -4.206 4.206 17.690 10.90% Year 3 51.48 11077 49.852 1.628 1.628 2.651 3.16% Year 4 58.72 11717 51.543 7.177 7.177 51.503 12.22% Year 5 45.47 13275 55.662 -10.192 10.192 103.872 22.41% Year 6 50.26 15215 60.790 -10.530 10.530 110.878 20.95% Year 7 79.6 18390 69.183 10.417 10.417 108.524 13.09% Average 7.122 61.096 13.69% Intercept 20.571 MAD MSE MAPE Slope 0.0026 SE 9.248 Forecast 20.571 Correlation 0.783 r-squared 0.612 Dep Variable (or) (Y)
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern