Enter your data for Mann-Whitney Test (Data tab)

On the Data tab of the Mann-Whitney Test 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 the 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, Months contains the number of months that a brand of paint persists on the highway. Brand contains the sample IDs and indicates which brand of paint the sample is from.
C1 C2
Months Brand
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, Brand A is the first sample and contains the number of months that the brand of paint persists on the highway. Brand B is the second sample contains the number of months that the second brand of paint persists.
C1 C2
Brand A Brand B
81 77
75 74
77 70
78 71
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy