How to compute the variance of two percentages?
I would like to compute for the Success Measure Variance of the two percentages. The target success measure is fixed and the actual one is manually inputted.
I tried to subtract them but it will lead to 0 if the actual becomes 95 (meeting the target) but shouldnt it be 100% if it met already?
Help Article Resources
Check out the Formula Handbook template!