PLEASE HELP! I have to turn this in soon and thought i had it right but i was way off on everything.

There are 25 "cases," or scores, per group in the ANOVA example.

First -I sorted by CLG.DGRE to organize the data so that college degree is sorted by group.

I ensured each person's respective score on PARTYID was also moved with the sort.

Second - I organized the data by group to be displayed in the format needed for Excel to perform the ANOVA.

This is below.

Third - Since we are covering Tukey's HSD post-hoc which requires group sizes to be equal,

I have ensured there are an equal number of scores per group.

Fourth - Follow the instructions for Excel ANOVA procedures on p. 287 "Using"Statistics in the Social and Health Sciences" with SPSS and Excel.

Author "Martin Lee Abbott

# of Grp 0 = Grp1=HS Grp2 Assoc. Grp3 Bach. Grp4 Grad.

Scores Less than HS Jr Coll.

1 3 2 1 3 1

2 0 5 6 5 2

3 3 5 4 2 0

4 2 2 1 3 1

5 0 0 7 6 1

6 0 0 1 5 2

7 0 6 2 1 0

8 1 2 0 3 4

9 0 0 1 1 1

10 1 3 2 6 1

11 1 9 3 2 0

12 3 0 4 0 1

13 0 0 3 2 0

14 3 3 1 4 1

15 0 3 0 4 1

16 0 4 1 2 3

17 2 2 1 2 2

18 3 3 2 2 3

19 3 4 2 1 1

20 3 0 4 2 1

22 3 6 5 1 3

23 3 0 4 7 5

24 1 2 3 1 0

25 1 0 1 7 1

(This is also an excel spreadsheet format)

Answers to, "Do you have any college degrees?"

0 = Less than high school

1 = High school

2 = Associate/Junior college

3 = Bachelor's

4= Graduate

I have provided a space/structure for the post-hoc analysis below.Scroll downwards.

List ANOVA: Single Factor table below (Count, sum, average, variance)

List the ANOVA output (SS, df, MS, F, P-value, & Fcrit.)

Post-hoc:Tukey's HSD Test

Grp 0 - Grp 1 Grp 0 - Grp 2 Grp 0 - Grp 3 Grp 0 - Grp 4 Grp 1 - Grp 2 Grp 1 - Grp 3 Grp 1 - Grp 4 Grp 2 - Grp 3 Grp 2 - Grp 4 Grp 3 - Grp 4

M₀ - M₁ M₀ - M₂ M₀ - M₃ M₀ - M₄ M₁ - M₂ M₁ - M₃ M₁ - M₄ M₂ - M₃ M₂ - M₄ M₃ - M₄

Using this row, place answers under each grouping to the right: "The Bottom Row"( This is an excel table so under the M row there is a blank row that for the answer)

What do you conclude about the relationship between one's educational level and their political views?Was there a significant F?

What do you conclude about the relationship between one's educational level and their political views when considering group comparisons?