# Calculating the ANOVA in SPSS or EXCEL.

## Calculating the ANOVA in SPSS or EXCEL.

Calculating the ANOVA in SPSS or EXCEL.

Instructions- Calculate this ANOVA by hand.  Check your work by also calculating the ANOVA in SPSS or EXCEL.  Be sure to do any multiple comparison tests and interpret the results.

### ORDER NOW FOR CUSTOMIZED, PLAGIARISM-FREE PAPERS

 Control GroupA1 PsychoanalysisA2 CBTA3 X1 7 7 3 X2 10 5 3 X3 6 6 2 X4 8 5 3 X5 10 5 4 X6 10 6 2 X barA1 SX (A1) SX2

SST = SX– T2/an                             (also called [X] – [T])

SST =                                                  (a = number of groups, n = number in each group)

SST =

SSA = SA2–   T2                                 (also called  [A] – [T])

n        an

SS=

SS=

SSS/A = SX– SA2                                        (also called [Y] – [A] )

N

SSS/A =

Now divide by its df to change it to variance.  Variance is called Mean Square.

Complete ANOVA summary table on next page.

ANOVA Summary Table

Source                                   SS                   df                     MS                  F

A-group

S/A (error)

Total

Find F-critical.

Are the groups significantly different?

Write the results statistically.

What do you do next?  Why?

Which groups are different?