Enter your data for 2 Variances (Data tab)

On the Data tab of the 2 Variances dialog box, select the option that best describes your data.

Both samples are in one column

Complete the following steps if your observations are in one column and group identifiers are in a second column.

  1. From the drop-down list, select Both samples are in one column.
  2. In Samples, enter the column of numeric data that you want to analyze.
  3. In Sample IDs, enter the column that contains the group that each observation corresponds to.
In this worksheet, Corrects contains the number of steering corrections each driver made. Road Type indicates the type of road the driver drove on.
C1 C2
Corrects Road Type
11 Dirt
6 Paved
8 Dirt
3 Paved

Each sample is in its own column

Complete the following steps if the data for each group are in different columns.

  1. From the drop-down list, select Each sample is in its own column.
  2. In Sample 1, enter the first column of numeric data that you want to analyze.
  3. In Sample 2, enter the second column of numeric data that you want to analyze.
In this worksheet, Dirt Road contains the number of steering corrections made on the first road type. Paved Road contains the steering corrections on the second road type.
C1 C2
Dirt Road Paved Road
11 6
8 3
10 12
15 5

Sample standard deviations

Complete the following steps if you have summary statistics for the two samples, rather than actual sample data in the worksheet:

  1. From the drop-down list, select Sample standard deviations.
  2. Enter the summary statistics in Sample size and Sample standard deviation.

Sample variances

Complete the following steps if you have summary statistics for the two samples, rather than actual sample data in the worksheet:

  1. From the drop-down list, select Sample variances.
  2. Enter the summary statistics in Sample size and Sample variance.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy