Answer Date: 11/11/2019 To test the hypothesis is that social support influences recovery at 5% level of significance. The null and alternative hypothesis is, H :/4 = 12 = Hq: at least one u; is unequal. The F-test statistics is, By using Excel software, find F-test statistics with the help of following steps: Import the data. Choose ANOVA: Single Factor from Data Analysis in Data menu. Choose Input Range and Column in Groups by. Choose Output Range. Click Ok.
df ANOVA Source of Variation Between Groups Within Groups Total SS 128.1333333 50.8 178.9333333 2 12 14 MS F P -value Fcrit 64.06667 15.13386 0.000523642 3.885293835 4.233333 From the Excel output, the F-test statistics is 15.13. The p-value for this test is, From the Excel output, the p value for this test is 0.0005. Decision The conclusion is that p-value in this context is less than 0.05 which is 0.0005, so the null hypothesis is rejected at 5% level of significance. There is sufficient evidence to indicate that social support influences recovery. The result is statistically significant.
To test the hypothesis is that there are differences in advertisements at 5% level of significance. The null and alternative hypothesis is, H :11 = 1l2 = Jlz H,: at least one u; is unequal. The F-test statistics is, By using Excel software, find F-test statistics with the help of following steps: 1) Import the data. Choose ANOVA: Single Factor from Data Analysis in Data menu. Choose Input Range and Column in Groups by. Choose Output Range. Click Ok. df F ANOVA Source of Variation Between Groups Within Groups Total SS 485.7333333 MS 242.8667 6.666667 P-value 7.99594E-06 Fcrit 3.885293834 2 12 14 36.43 565.7333333
From the Excel output, the F-test statistics is 36.43|. The p-value for this test is, From the Excel output, the p value for this test is 0.0000) Decision The conclusion is that p-value in this context is less than 0.05 which is 0.0000, so the null hypothesis is rejected at 5% level of significance. There is sufficient evidence to indicate that there are differences in advertisements. The result is statistically significant. 3) To test the hypothesis is that there are differences between towns at 5% level of significance. The null and alternative hypothesis is, H : [1] = 1l2 = plz = 1l4 He: at least one pl; is unequal.
The F-test statistics is, By using Excel software, find F-test statistics with the help of following steps: 1) Import the data. Choose ANOVA: Single Factor from Data Analysis in Data menu. Choose Input Range and Column in Groups by. Choose Output Range. Click Ok. SS ANOVA Source of Variation Between Groups Within Groups Total Fcrit 3.238871522 2.8 36.4 39.2 MS F P -value 3 0.933333 0.410256 0.747824274 16 2.275 19 From the Excel output, the F-test statistics is 0.41]. The p-value for this test is, From the Excel output, the p value for this test is 0.7478.
Decision The conclusion is that p-value in this context is higher than 0.05 which is 0.7478, so the null hypothesis is not rejected at 5% level of significance. There is insufficient evidence to indicate that there are differences between towns. The result is not statistically significant.