In: Statistics and Probability
Anova problem
Does a fathers marital satisfaction increase, decrease, or stay the same over time?
ID |
M1 SAT |
M2 SAT |
M3 SAT |
M4 SAT |
1 |
1.952 |
1.849 |
1.457 |
1.902 |
2 |
2.947 |
2.706 |
2.804 |
2.744 |
3 |
1.951 |
1.545 |
1.098 |
0.156 |
4 |
2.842 |
2.947 |
2.282 |
2.152 |
5 |
2.292 |
1.44 |
0.732 |
1.306 |
6 |
2.344 |
2.435 |
2.179 |
2.088 |
USING .05 alpha
Anova in excel
1. Arrange the data in excel as shown below.
2. Select one factor anova from the data analysis tab.
3. Input the value as shown.
4. The output will be generated as follows.
Hypothesis.
Ho: The mean fathers marital satisfaction has been same over
time
H1: The mean fathers marital satisfaction has not been same over
time
From the ANOVA output we look at the pvalue which is 0.32(highlighted in yellow). Since the pvalue is greater than 0.05, we fail to reject the null hypothesis and conclude that the mean fathers marital satisfaction has been same over time .