Variance calculation

N

N.C. Arens

MS Excel 11.0 continues to have the same problem it has had forever. For
reasons I haven't been able to work out, it occasionally returnes negative
variance or some positive value that is completely wrong. Based on the
formula used to calculate variance as described in the documentation, a
negative value is impossible. What gives?
 
H

Harlan Grove

N.C. Arens said:
MS Excel 11.0 continues to have the same problem it has had forever. For
reasons I haven't been able to work out, it occasionally returnes negative
variance or some positive value that is completely wrong. Based on the
formula used to calculate variance as described in the documentation, a
negative value is impossible. What gives?
Click to expand...

By Excel 11 you mean Excel 2003?

VAR should have been fixed in Excel 2003. What do you get as the result of
DEVSQ applied to your data? If it's also negative, what's your data?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if format problem 8
How do I calculate variance percetage if figures are negative 5
Calculating % based on negative divisor 1
Customizing Enterprise Fields for Computing %Finish Variance 5
Conditional SUM for Budget, Actuals, & Variance YTD columns 0
Total certain records 1
Calculation & Negative Help 2
Time remaining until event 2

Top