Explore BrainMass

Explore BrainMass

    Forecast Accuracy Measures

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    See attached Excel data file.

    For each forecast, set up columns and calculate:
    Squared error
    Absolute error
    Absolute % error
    The numerator of Thiel"s U statistic
    The denominator of Thiel"s U statistic
    Calculate ME, MSE, RMSE, MAPE, and U.


    1/ The absolute percentage error for the data point 9/24/2008 returns #DIZ/0! Value. The appropriate action is...
    a/ exclude 9/24/2008 entirely from data set
    b/ Treat the reported error as a missing value when calculating the error statistics
    c/ Replace the error by zero
    d/ Replace the actual value of calls offered by a very small number e.g 1
    e/ do nothing

    2/ The following statement about the error statistics for the two variables is true.
    a/ the calculated mean squared error for both models are too large to be interpreted
    b/ Model 1 systematically over predicts number of calls
    c/ Thiel's U statistic indicate that naïve forecasting will produce better forecast than either model 1 or 2
    d/ Model 2 is far superior to Model 1 in terms of mean error
    e/ Neither model has any substantial bias.

    3/ The root mean squared error for models 1 and 2 respectively are
    a/ 1018 and 1075
    b/ 31 and 2
    c/ .048 and .52
    d/ 1036949 and 1156669
    e/ .097 and .102

    4/ The mean absolute percentage error for models 1 and 2 respectively are
    a/ 1018 and 1075
    b/ 0.097 and .102
    c/ .48 and .52
    d/ 1036949 and 1156669
    e/ 31 and 2

    5/ The error statistic indicate
    a/ Naïve forecasting will produce better results than either model 1 or model 2
    b/ Model 2 is better than model 1 based on RMSE and MAPE
    c/ model 2 is better than model 1 because it has the lowest mean error
    d/ model 1 is better than model 2 based on RMSE, MAPE, and Thiel's U statistic
    e/ Both model 1 and model 2 provide reasonable forecast of calls offered based on MAPE.

    © BrainMass Inc. brainmass.com March 4, 2021, 10:45 pm ad1c9bdddf


    Solution Summary

    This solution is comprised of detailed step-by-step calculations and explanation of various Forecast Accuracy Measures like Forecast Error, Absolute Error, Thiel's U Statistic, ME, MSE, RMSE, MAPE etc. in EXCEL. Comparison of these Forecast Techniques based on these Forecast Accuracy measures has also been shown.