Close this search box.

One Sample Variance Test Help

This test is performed on the variance of one sample. The test gives you a confidence interval for the standard deviation and the variance. It has the option to test the hypothesis that the standard deviation and variance is equal to, less than, or greater than a specified standard deviation and variance. You also have the option for a two-sided, lower one-sided or an upper one-sided test.

The data can be in a range in a worksheet or the user can enter an average, standard deviation, and sample size for the test. The example on this page demonstrates how to do this test using data in a range in the worksheet.

One Sample Variance Test Output

The output from the example data (using a hypothesize standard deviation = 0.23) is shown below. An explanation of terms is given below the output.

The output tells you the conclusion from the test. The null hypothesis (H0) and the alternate hypothesis (H1) are printed below the title.

The program also creates a chart showing the confidence interval, the variance and hypothesized variance (if included).

There is also a chart of the data to look for possible outliers. If the program detects possible outliers, they will be in red and a message will be printed on the worksheet.

Scroll to Top