percent correct
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. |
percent correct
What's an "absolute" percentage? If you are tracking the percentage of the
expected which was received, you divide received by expected, or 215/200, for 107.5%. It makes little sense to take a reciprocal of this, because it's hard to care what percentage of the number of items you received was what you had expected. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "travis" wrote in message ... 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. |
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. |
All times are GMT +1. The time now is 11:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com