Thread: percent correct
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default percent correct

These entries provide examples for calculating the mean absolute percentage
error:

http://en.wikipedia.org/wiki/Calcula...ecast_Accuracy

http://en.wikipedia.org/wiki/MAPE

--
John Mansfield
http://cellmatrix.net





"travis" wrote:

I'm trying to get the absolute percentage correct for a formula. If there is
200 expected and 215 received I'm looking for the absolute percentage not a
percentage over 100%. The answer would always be under 100%. IWS there a
formula for this.