Share
Explore BrainMass

Nonparametric methods: analysis of ranked data

Problem 16- 3

3. Determine the absolute differences for the values computed in column 4. Recall
that in an absolute difference we ignore the sign of the difference. The absolute
differences are shown in column 5.

TABLE 16-3 Flavor Rating for Current and Spicy Flavors
(1) (2) (3) (4) (5) (6) (7)
Spicy Current Difference Absolute Signed Rank
Participant Score Score in Score Difference Rank R+ R-
Arquette 14 12 2 2 1 1
Jones 8 16 -8 8 6 6
Fish 6 2 4 4 3 3
Wagner 18 4 14 14 13 13
Badenhop 20 12 8 8 6 6
Hall 16 16 * * * *
Fowler 14 5 9 9 9 9
Virost 6 16 -10 10 11 11
Garcia 19 10 9 9 9 9
Sunder 18 10 8 8 6 6
Miller 16 13 3 3 2 2
Peterson 18 2 16 16 14 14
Boggart 4 13 -9 9 9 9
Hein 7 14 -7 7 4 4
Whitten 16 4 12 2 12 12

Total 75 30

Attachments

Solution Preview

Your excel file looks like you have been calculating differences by hand (it can sometimes happen if cells are copied by value rather than by formula).

I have changed your columns (4) and (5) to using formulas - it saves much time in work with tables.

After you write a formula in one cell, you ...

$2.19