I believe you are interested in calculating the variance from a set of data related to salaries. Variance = square of the standard deviation, where: s= square root[sum (xi- mean)2/(n-1)] where mean of the set is the sum of all data divided by the number in the sample. X of i is a single data point (single salary). If instead of a sample of data, you have the entire population of size N, substitute N for n-1 in the above equation. You may find more information on the interpretation of variance, by searching wikipedia under variance and standard deviation. I note that an advantage of using the standard deviation rather than variance, is because the standard deviation will be in the same units as the mean.
actual budget/budget = variance%
your salary and someone else's salary
In a study using 9 samples, and in which the population variance is unknown, the distribution that should be used to calculate confidence intervals is
This years' sales plus last years' sales divided by 2
(Actual Effort -Planned Effort)/Planned Effort * 100
how to calculate budget variance percentage?
variance - covariance - how to calculate and its uses
actual budget/budget = variance%
your salary and someone else's salary
Variance = 100*(Actual - Budget)/Budget
Square the standard deviation and you will have the variance.
How do we calculate variance
Standard deviation = square root of variance.
There only needs to be one data point to calculate variance.
The standard deviation is the square root of the variance. So, if variance = 03 = 3 the std dev = sqrt(3) = 1.732
look in a maths dictionary
You need to use the variance and covariance functions in Excel 1. Calculate the covariance of the stock returns with respect to an index 2. Calculate the variance of the index 3. Divide the first number by the second. See the related link for a spreadsheet