2

What sort of mean can I use in calculating the average of the deviations of actuals from a forecast, which are in percent. The data look(s) like this:

-0.26
-0.21
-0.9
1.56
1.88

For example, the last unit above beat the forecast by 1.88%. My intuition was geometric (based on this question), but I am not sure how to to deal with the negative values.

Edit: I think I've figured it out once I had some more coffee. I think you want to transform the data to (1+percentage). For example, enter +4% as 1.04. Similarly, a percentage of -2% would be .98. Would that be correct?

Ferdi
  • 4,882
  • 7
  • 42
  • 62
dimitriy
  • 31,081
  • 5
  • 63
  • 138
  • Your [pre-coffee intution](http://www.jstor.org/stable/2276859?seq=1) seems to be working well. –  May 08 '12 at 13:30
  • Thanks! I'll take advice from you and Arthur F. Burns any day. – dimitriy May 08 '12 at 13:49
  • 1
    Why not use an arithmetic mean? Do you think the mean is inappropriate due to your mix of negative and positive numbers? – Joel W. May 08 '12 at 15:55
  • 1
    I was taught to use arithmetic means for levels, geometric for ratios, and harmonic for rates. My data seems more like ratios or maybe rates (since they are each unit's deviation from from forecast in % during a given period of time). All are pretty close in this case, so it is a bit of an academic matter on which Pythagorean mean to use. – dimitriy May 08 '12 at 18:10

0 Answers0