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.


  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)      


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


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






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

n        an







SSS/A = SX– SA2                                        (also called [Y] – [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


S/A (error)




Find F-critical.




Are the groups significantly different?




Write the results statistically.




What do you do next?  Why?





Which groups are different?


You must proofread your paper. But do not strictly rely on your computer’s spell-checker and grammar-checker; failure to do so indicates a lack of effort on your part and you can expect your grade to suffer accordingly. Papers with numerous misspelled words and grammatical mistakes will be penalized. Read over your paper – in silence and then aloud – before handing it in and make corrections as necessary. Often it is advantageous to have a friend proofread your paper for obvious errors. Handwritten corrections are preferable to uncorrected mistakes.

Use a standard 10 to 12 point (10 to 12 characters per inch) typeface. Smaller or compressed type and papers with small margins or single-spacing are hard to read. It is better to let your essay run over the recommended number of pages than to try to compress it into fewer pages.

Likewise, large type, large margins, large indentations, triple-spacing, increased leading (space between lines), increased kerning (space between letters), and any other such attempts at “padding” to increase the length of a paper are unacceptable, wasteful of trees, and will not fool your professor.

The paper must be neatly formatted, double-spaced with a one-inch margin on the top, bottom, and sides of each page. When submitting hard copy, be sure to use white paper and print out using dark ink. If it is hard to read your essay, it will also be hard to follow your argument.

Get a 10 % discount on an order above $ 50
Use the following coupon code :