About John Zalewski Expertise I can help you solve problems involving fractions, decimals, ratios, and algebra. I can teach you how to do math faster, and even in your head. I can teach math definitions, and help you study, if necessary. Please do not ask any graphing, trigonometry, or calculus questions. Try to work through homework questions before asking for assistance.
Experience I routinely process numbers of all kinds in my head, without need of a calculator.
Education/Credentials I was an A math student while in high school.
What is the corrent way of calculating variance percentage ei: Forecast 1240 Actual 1357 Variance is =(1240/1357)-1 or =(1240/1357)/1240?
ei: Forecast 3428 Actual 2808 Variance is =(3428/2808)-1 or =(3428/2808)/3428?
I need it the formula to be consistent!
Thank you so much!
Answer Hello, Olivia.
Variance Percentage = ((Actual-Forecast)/Forecast) x 100.
For your example, you'd have (1357-1240)/1240) x 100.
(117/1240) x 100
= 9.43%
In other words, the actual forecast varied by an increase of about 9.43%.
