Explore BrainMass
Share

ANOVA Worksheet and Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

I am trying to do the ANOVA graph and input the numbers in Excel. Once I click on the tool pack and select ANOVA Single Factor, I do not know what to put for input range, etc., and how I create this. I am unfamiliar with Excel. Can you please explain how to do an ANOVA on Excel so I can do my own work? Thank you.

© BrainMass Inc. brainmass.com October 25, 2018, 7:56 am ad1c9bdddf
https://brainmass.com/statistics/analysis-of-variance/anova-worksheet-excel-520234

Attachments

Solution Summary

The expert examines an ANOVA worksheet analysis using Excel.

$2.19
See Also This Related BrainMass Solution

Statistics: Anova problem of gender and dietary groups

4. Solve the following Anova problem. R's represent gender and C's represent dietary groups. Alpha = .05.

C1 C2 C3

3 7 8

R1 4 6 12

5 2 5

7 3 1
R2
9 4 0

6 2 1

View Full Posting Details