pop #1 pop #2 23.1 24.0 24.2 22.3 23.7 24.0 23.7 23.3 26.1 24.2 24.6 21.3 24.4 24.3 25.2 22.3 24.4 23.5 24.6 24.3 26.0 24.5 26.4 23.2 25.4 24.8 24.0 25.3 25.6 24.6 23.3Run the Mann-Whitney Test: The procedure is essentially identical to that of the t-test, except that you do a rank sum test. Go to Statistics, then Compare two groups, then rank sum test. This brings up another window, which is used to assign columns in your spreadsheet. The box may be too low on your screen, in which case you will need to drag it higher on your screen to be able to see the bottom of the window. Data format is Raw. Then use the cursor to point to the top of column #1; this highlights column #1 as one of your populations. Then click on the Next button at the bottom of the window. Then click on column #2, and then click on the Finish button. The results of the t-test are then displayed on the screen.
Mann-Whitney Rank Sum Test Friday, July 16, 1999, 10:25:06 Data source: Data 1 in Notebook Normality Test: Passed (P = 0.643) Equal Variance Test: Passed (P = 0.651) Group N Missing arizona 16 0 new mexico 15 0 Group Median 25% 75% arizona 24.500 23.850 25.500 new mexico 24.000 23.225 24.450 T = 189.000 n(small)= 15 n(big)= 16 (P = 0.046) The differences in the median values among the two groups are greater than would be expected by chance; there is a statistically significant difference (P = 0.046) |