Is the p value significant?Is calculated F value greater than Critical F value?

Open the small Excel database that was provided to you in week 4. To run the test statistics you have to re-arrange your data.

With this database, you will:

Run a one-way ANOVA to compare three or more groups of people (specified by a categorical variable) on one continuous variable.
Write the null and alternate hypotheses.
What is the calculated mean for each group?
What is the calculated F value?
What is the p and critical F value?
Is the p value significant?Is calculated F value greater than Critical F value? Conclusion?
Run a chi-squared test to determine whether one group of people has higher rates of a given outcome relative to the other groups of people in the data set.
Write the null and alternate hypotheses.
What is the calculated chi-square value?
What is the p and critical value?
Is the p value significant? Is calculated chi-square value greater than Critical F value? Conclusion?