Share
Explore BrainMass

Analysis of variance (ANOVA) and F test

Please, perform an F test for columns A (gender), B (age), and E (overall satisfaction) (in the attached spreadsheet)

Please use all the data rows for each of these three columns. (from the Excel table attached)

For this and any hypothesis test, I want you to number the five steps as in the book.

Here are the 5 steps:

1. State the Hypothesis and identify the claim

2. Find the critical value

3. Compute the test value.

4. Make the decision

5. Summarize the results

Please provide the following summary table.
Null and Alternative Hypotheses H0:
H1:
Significance Level
Degrees of freedom
Critical Value α=
df=
tcrit=
Test Value t=
Decision

Then run an ANOVA and clearly state each step and the formula used for each step.

Then use the Table below: (enhance if you must to fit the data)

Source Degrees of Freedom Sum of Squares Mean Square F value
Between
Within
Total

Attachments

Solution Summary

This solution shows how to use hand calculations to to do an analysis of variance.

$2.19