The Two Sample Test for Variance Dialog Box

Supporting Information

To open the Two-Sample Test for Variance dialog box:

  1. With the worksheet active, click Statistics: Hypothesis Testing: Two-Sample Test for Variance...

See Also:

Results Log Output

Results Log Output

Select to output results to the Results Log.



Controls recalculation of analysis results

  • None
  • Auto
  • Manual

For more information, see: Recalculating Analysis Results

Input Data Form

Indexed The input data consists of one sample data column and one grouping column.
Group Range

The grouping column. Note that the grouping column will be set as categorical if Text column.

Data Range

The sample data column.


The input data consists of two sample data columns.

1st Data Range

The first sample column.

2nd Data Range

The second sample column.


For help with range controls, see: Specifying Your Input Data

1st Data Range/Group Range First sample dataset (Raw) or grouping variable (Indexed).
2nd Data Range/Data Range Second sample dataset (Raw) or sample dataset (Indexed).

F-test for Variances Ratio

Null Hypothesis The null hypothesis to be tested (i.e. Variance1 = Variance2).
Alternate Hypothesis Options:
Variance 1/Variance 2 <> 1

Test whether the two sample variances are equal.

Variance 1/Variance 2 > 1

Test whether the variance from sample one is larger than the variance from sample two.

Variance 1/Variance 2 < 1

Test whether the variance from sample one is less than the variance from sample two.

Significance Level Specify the significance level.
Confidence Interval(s) Compute confidence intervals for the differences of the means.
Confidence Level(s) in % Specifies space-separated confidence levels. This option is only available when Confidence Interval(s) is chosen.


Histogram Create a histogram.
Box Chart Create a box chart.
Arrange Plots of Same Type in One Graph Note that for the histograms, layers will be arranged vertically. For box chart, layers will be arranged horizontally.


For help with the range controls, see: Output Results

Output Plot Data Specify a worksheet for output of plotted data (Origin generates tabular data when plots are created).
Output Results Specify the worksheet for output of test results.