Enter your data for 2 Proportions

Stat > Basic Statistics > 2 Proportions

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 data that you want to analyze.
    Tip

    Click in Samples to see the columns that are available for your analysis.

  3. In Sample IDs, enter the column that contains the group that each observation corresponds to.
In this worksheet, Employed indicates whether the undergraduate students got a summer job. Gender indicates whether each student is male or female.
C1 C2
Employed Gender
Yes Male
Yes Male
Yes Female
No Female

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 data that you want to analyze. The data must include two distinct values, such as True and False.
  3. In Sample 2, enter the second column of data that you want to analyze. The data must include two distinct values.
In this worksheet, the column Male indicates whether each male student in the sample got a summer job. The column Female indicates whether each female student in the sample got a summer job.
C1 C2
Male Female
Yes Yes
Yes No
No Yes
Yes No

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. In Number of events, enter the number of successes. For example, if you want to determine the proportion of defective parts, the number of events would equal the number of defective parts.
  3. In Number of trials, enter the total number of observations. For example, if you want to determine the proportion of defective parts, the number of trials would equal the total number of parts that you sampled.