QBA Homework 6.xlsx - Week Squared Absolutue Forecast Percentage Value of Value Forecast Forecast Error Absolute Error Error Error 1 18 2 13 18-5 5

QBA Homework 6.xlsx - Week Squared Absolutue Forecast...

This preview shows page 1 - 25 out of 85 pages.

WeekValueForecastForecast ErrorAbsolute11821318-5525-38.46%38.46%3161333918.75%18.75%41116-5525-45.45%45.45%51711663635.29%35.29%61417-339-21.43%21.43%22104-51.30%159.39%Mean Absolute Error:4.4Mean Squared Error: 20.8Mean Absolute Percentage Error: 31.88%Forecast week 7:14Squared Forecast ErrorPercentage ErrorAbsolutue Value of % Error
Background image
Background image
Background image
Background image
Background image
WeekValueForecastErrorAbsoluteSquared11821331641115.66667-4.666667 4.666667 21.7777851713.333333.666667 3.666667 13.4444461414.66667-0.666667 0.666667 0.444444714-1.6666679 35.66667
Background image
MSE:11.88889WeekValueForecastErrorAbs errorSquareda value:0.21181- a:0.821318.00-552531617.00-11141116.80-5.85.833.6451715.641.361.361.849661415.91-1.9121.912 3.655744715.53-12.35215.072 65.14534MSE:13.02907
Background image
Background image
Background image
WeekSales (1000s of gallons)4 wkerrorAbs errorSquared Error11722131942351820-22461620.25-4.254.2518.06257201911181819.25-1.251.251.5625922184416102019111111520-5525122218.753.253.2510.5625154.25-3.2521.7577.1875WeekSales (1000s of gallons)5 wk ErrorAbs errorSquared Error11722131942351861619.6-3.63.612.9672019.40.60.60.3681819.2-1.21.21.4492219339102018.81.21.21.44111519.2-4.24.217.64122219339134.2-1.216.851.84
Background image
MSE: 9.6484375MSE:7.4057143
Background image
Background image
Background image
WeekMonthy Proportion of On Tme Payments3 week movingErrorAbs error1802823844838211583830068483.3333333333 0.666667 0.66666778583.3333333333 1.666667 1.666667884840098284.3333333333 -2.333333 2.333333108383.6666666667 -0.666667 0.66666711848311128383001383.33333333331.333333 7.333333WeekMonthy Proportion of On Tme PaymentsExponentialErrorAbs error18028280.000002238480.400003.63.648381.120001.881.8858381.496001.5041.50468481.796802.20322.203278582.237442.762562.7625688482.78995 1.210048 1.21004898283.03196 -1.031962 1.031962108382.82557 0.174431 0.174431118482.86046 1.139545 1.139545128383.08836 -0.088364 0.08836483.07069 15.35346 17.59411a0.21-a0.8
Background image
Squared errorMSE:1.234568100.44444444442.777777777805.44444444440.44444444441011.1111111111Squared errorMSE:3.555291412.963.53442.2620164.854090247.63173775361.46421616231.06494474390.03042607611.29856184070.007808256439.108201073
Background image
12345678977787980818283848586Monthy Proportion of On Tme Paym
Background image
101112ments
Background image
MonthValue of Contract3-MoErrorAbs ErrorSq ErrorMSE:1998.7651240235032304260273.33333333 -13.33333 13.33333 177.777852802800006320256.66666667 63.33333 63.33333 4011.1117220286.66666667 -66.66667 66.66667 4444.4448310273.33333333 36.66667 36.66667 1344.4449240283.33333333 -43.33333 43.33333 1877.77810310256.66666667 53.33333 53.33333 2844.44411240286.66666667 -46.66667 46.66667 2177.77812230263.33333333 -33.33333 33.33333 1111.11113260-50 356.6667 17988.89MonthValue of ContractExponentialErrorAbs ErrorSq ErrorMSE:2528.84312402350240110110121003230262-323210244260255.64.44.419.365280256.4823.5223.52 553.19046320261.18458.81658.816 3459.3227220272.9472-52.947252.9472 2803.4068310262.35776 47.64224 47.64224 2269.7839240271.886208 -31.88621 31.886211016.7310310265.5089664 44.49103 44.49103 1979.45211240274.40717312 -34.40717 34.40717 1183.85412230267.5257385 -37.52574 37.52574 1408.18113260.0205908100.103 477.6356 27817.28a0.21-a0.8
Background image
Background image
Background image
Image of page 25

You've reached the end of your free preview.

Want to read all 85 pages?

  • Spring '14
  • Danepeterson
  • Mean absolute percentage error, Mean squared error, 3 week, Mean absolute error, Statistical deviation and dispersion, 3.25 5 wk

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture