Variance Calculations With Microsoft Excel

Excel provides useful statistical functions for finding the variance. Generally, these variance functions retrieve a set of values ​​stored in the list of the range, and then to calculate the expected.

of the variance, just to remind readers, is a common measure of describing the spread of observations distribuciju.Varijance was statistically associated with another measure of standard devijacije.Varijance equal to the square of the standard deviation.

of the variance of the sample with the VAR function

If you do a set of data samples and do not want to include logical values ​​or text from paper to the calculation, use the VAR. For example, if you are using a new manufacturing process that is supposed to increase productivity and have a range for the number of parts produced each day, you can find the variance uzorka.VAR function uses the following syntax:

= VAR (data set range)

of the variance of the sample with the VARA function

If the data set is an example, but want to include logical values ​​or text in a calculation, use the VARA. Excel counts cells containing the logical value TRUE as 1 and cells that contain text or FALSE 0.VARA function uses the following syntax:

= VARA (data set range)

variance of a population sample with VARP Function

If the data set working population, and you do not want to include logical values ​​or text from paper to the calculation, use the VARP.VARP function uses the following syntax:

= VARP (data set range)

population variances with VARPA Function

If a data set of the population, but want to include logical values ​​or text in a calculation, using VARPA funkciju.VARPA function uses the following syntax:

= VARPA (data set range)

The final note on the range of the data argument

One other note: You can include multiple ranges of a worksheet as the data set range argument when using the variance function. For example, if you were to calculate the variance of the sample using the VAR function and have their data stored in several different lists varies, your VAR function might look like this:

= VAR (B1: B: 10, B101: B110, B200)