**How To Calculate Sample Variance**. Use the sample variance and standard deviation calculator. Set up the null and alternate hypothesis and the Alpha.

Sample variance formula in Excel. The result is the variance. For example you can calculate variance between sales in this year and last year between a forecast and observed temperature between a budgeted cost and the real one.

### X 1 x N the sample data set.

Subtract the mean from each of the numbers x square the difference and find their sum. Define dataset data. Set up the null and alternate hypothesis and the Alpha. The result is the variance.