Google Answers Logo
View Question
 
Q: Statistics\ forecasting ( Answered 5 out of 5 stars,   0 Comments )
Question  
Subject: Statistics\ forecasting
Category: Reference, Education and News
Asked by: san007-ga
List Price: $20.00
Posted: 24 Apr 2003 02:10 PDT
Expires: 24 May 2003 02:10 PDT
Question ID: 194692
Hi all, 
 
Just wondering if someone can answer my question about Mean error,
Mean square error, and Mean absolute percentage error.
 
What i need is the circumstances when you think each might be the most
appropriate measure for selecting the best trend curve.
 
I need it by the end of today (24th April) 
 
Thanks

Request for Question Clarification by jeremymiles-ga on 24 Apr 2003 03:08 PDT
What is your outcome that you are trying to predict?  Can you give a
little more context?

Can you tell us precisely what you mean by mean absolute percentage
error.

One problem with mean error is that it doesn't necessarily give a
unique solution.

Are there occasions when you have see each of these used, that you
have doubts about, or are you exploring this to help your own
understanding of the issue?

jeremymiles-ga

Request for Question Clarification by jeremymiles-ga on 24 Apr 2003 03:18 PDT
Hello again, one more thing - when today ends depends on whereabouts
in the world you are.  How long do you have?

Clarification of Question by san007-ga on 24 Apr 2003 03:28 PDT
hi jeremymiles-ga,

 I hope this helps but my knowledge of this area is sketchy. What im
looking for is simply a brief description of the circumstances when
each might be appropriate for selecting a best trend curve.

So im looking for simply the circumstances, hopefully examples of each
and a brief description of each.

Does that help??

If not are try to explain further

Clarification of Question by san007-ga on 24 Apr 2003 03:41 PDT
oh and my day ends in about 12 hours

Request for Question Clarification by jeremymiles-ga on 24 Apr 2003 03:44 PDT
I am afraid that I don't know enough to find good examples, and I
don't have time to search for them.  I hope that another researcher
will be able to help you out.

Clarification of Question by san007-ga on 24 Apr 2003 04:32 PDT
cool

Clarification of Question by san007-ga on 24 Apr 2003 06:29 PDT
sorry dont need examples just description of teh circumstances
Answer  
Subject: Re: Statistics\ forecasting
Answered By: mathtalk-ga on 24 Apr 2003 08:41 PDT
Rated:5 out of 5 stars
 
Hi, san007-ga:

The context suggested by statistics/forecasting and error criteria for
trend curves covers a lot of different applications.  I'm assuming
that you are looking for the general principles for using one
criterion over another.

The trend curve may be fitted to a data set in any of a variety of
ways.  There may, for example, be a formula with one or more
parameters, chosen to minimize error as measured in one of the ways
named.

Alternatively the "trend curve" might be a moving average or
"filtering" process applied to the data.  Again the error criteria
might be applied to argue that one process or another is best for a
particular purpose.

There are then really two sorts of circumstances to keep our eyes on. 
The first have to do with characteristics of the data (or perhaps, the
characteristics of our limitations in analyzing the data).

The second set of circumstances concerns the purposes to which the
trend curve will be put.

The mean square error is probably the most often used criterion,
though this may be because of the simplicity with which data can be
fitted to curves (often using a linear least squares package).  The
history of this approach goes back to Gauss, who found in conducting
landmark surveys in Germany that repeated measurements of the same
quantity produced errors that could be modelled with a normal
distribution.  In this case Gauss showed an "optimal" way of fitting
the data would be to use the mean square error criterion.

However in the financial world one often has to work with data
containing noise and observations that cannot be repeated.  The mean
(absolute) error criterion is more "robust" than the mean square error
in these circumstances.  A single observation containing a large error
can have a significant impact on the mean square error fit, while the
mean (absolute) error fit criterion is more or less "immune" to those
effects.

So if the data were known to contain a few very "noisy" observations
(data points with undetermined but possibly large errors), then a mean
(absolute) error criterion is to be preferred to a mean square error.

Another consideration that is based on the data concerns the relative
error (mean absolute percentage error) versus the absolute error (mean
absolute error or mean square error).  If the data contains small
values, close or perhaps even equal to zero, the relative error
criterion would be tricky or impossible to apply.  A relative error
criterion works with data that is bounded away from zero.  If the data
is not like this, then an absolute error criterion should be used.

On the other hand one should also consider the purpose to which "trend
curves" will be put.  Especially one needs to ask the "consequences"
of errors in forecasting.  Is it better is use a relative error
criterion or an absolute error criterion?  If the data set contains
values of widely different magnitudes, then it may be important to
have relatively good fitting to both high and low values.  An example
might be in estimating a water budget for a regional district, where
monthly rainfalls vary by an order of magnitude during the annual
cycle.  In financial forecasting, however, an absolute error criterion
might be more important, as a dollar loss or profit on revenues during
low sales activity can be equal to a dollar loss or profit during high
sales activity.

Also, there may be "catastrophic" consquences for errors in estimation
that are larger than a certain tolerance.  As noted before, the mean
square error criterion gives a larger influence to single observation
that are significantly "outside" the range of others, than the mean
(absolute) error criterion would.  If the impact of those larger
deviations threatens disproportionate consequences, it might be good
to use a mean square error criterion, if only for the sake of
incorporating some of that volatility (increased variance) into the
model, for planning purposes.

regards, mathtalk-ga
san007-ga rated this answer:5 out of 5 stars
Excellent work and very thorough, it helped me understand and further
my knowledge in this area. Thank you very much

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy