Enter your data for 2-Sample t (Data tab)

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

Both samples are in one column

Complete the following steps if your data 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, Rating contains samples of patient satisfaction ratings of two hospitals. Hospital contains the sample IDs and indicates whether each rating corresponds to hospital A or to hospital B.
C1 C2
Rating Hospital
81 A
77 B
75 A
74 B

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, Hospital A is sample 1 and contains the patient satisfaction ratings from one hospital. Hospital B is sample 2 and contains the ratings from a second hospital.
C1 C2
Hospital A Hospital B
81 77
75 74
77 70
78 71

Summarized data

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 Summarized data.
  2. Enter the summary statistics in Sample size, Sample mean, and Sample standard deviation.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy