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?

Califoni 11 Wrap Test BI U # of Scores G M 3 W N W IA N N NI F O J H N O H N N N m List the ANOVA output ($S, df, MS, F, P-value, & Forit.) NOOOHAWN An 2 1 3 5 o 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 Mo - M1 Mo - M2 Mo - Ma Mo - MA M1 - M 2 M1 - Ma M1 - Ma M2 - M3 M2 - MA M3 - M4 37 Using this row, place answers under each grouping to the right: 38 39 What do you conclude about the relationship between one's educational level and their political views? Was there a significant F? 40 Answer: 41 42 What do you conclude about the relationship between one's educational level and their political views when considering group comparisons? 43 Answer: 44 45 46 Sheet1 + Ready Count: 7 Type here to search WE NTST-K-PF14U4X9Review File Home Insert Page Layout When's Acrobat Tell me what you want to Cut Calibr - 11 - A A E Wrap Text General BE Copy Paste B IU el E Merge & Center Format Painter Clipboard Font Alignment Number # of Scores 8 of Scores 0 = Less th 1 - High so 2 - Associ 3 = Bachel Nmir 4= Graduat 12 15 HNOHHNOTHHOT 14 I have provided a space HUGHPHNOHNM TM HOH List ANOVA: Single Fact m un N m D m Hm H D N O N T T N N N H O N M momNoooHomomoonmmmmmm List the ANOVA outpu - Na and Sheet1 + Ready Type here to search NTST-K-PF14U4X9