Purchase Solution

Forecast and Accuracy Measures

Not what you're looking for?

Ask Custom Question

Treat each day of week as a different time series. For example, since this flight departs seven days per week, create seven forecasts. Sort the data by day of week and date. Then create scatter plots or line plots of each time series. From the plots, determine what the components of each time series are.

Next, using the MSE, MAD, MAPE, LAD, select the best model for each of the seven days using root mean squared error (RMSE). You will end up with seven different models to make seven different forecasts. Last, use these models to forecast no shows for each of the days next week (the week beginning on Monday, November 22)

[Please refer to the EXCEL sheet for data]

Purchase this Solution

Solution Summary

This solution is comprised of detailed step-by-step calculations and explanation of Forecast Techniques and various Forecast Accuracy Measures like Forecast Error, Absolute Error, MAPD etc. in EXCEL. Comparison of these Forecast Techniques based on these Forecast Accuracy measures has also been shown. Forecast and accuracy measures are examined.

Solution provided by:
Education
  • MSc, Osmania University
  • MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
  • BSc, Banaras Hindu University
Recent Feedback
  • "Very fast turnaround. Excellent communication! Much appreciated!"
  • "excellent"
  • "excellent"
  • "excellent work"
  • "Fantastic..great solution and very well explained!!!!"
Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.