Question

Refers to the tables above, then answer the following questions:

1) For the individual tests (pairwise comparisons), based on the p-values and an adjusted significance level of 0.0167, should the null hypothesis be rejected or not? (Please include 3 answers, one for each comparison.)

2) What is the conclusion for all tests? That is, which groups are different from each other (if any)?

Home Insert Draw Page Layout Formulas Data Review View Tell me what you want to do 钆朋▽▽Clear AU Sort Filter Advanced cỐ Data Va dation consolidate v Connections Flash Fil Properties Stocks Geography Wh Get External Data Refresh Allen . Textto尿Remove Duplicates Edit Links Columns ex Ana 1 ID group hrt rate Group 1 Group 2 Group 3 Copy and paste the table output below overall Test Anova: Single Factor 69.17 68.86 70.17 64.17 58.69 79.66 69,23 1 75.98 86.45 1 97.54 1 85.00 69.1799.6984.74 68.869135 87.23 70.17 83.40 84.88 64.17 100.88 80.37 58.69 102.1591.75 79.66 89.82 87.45 69.23 80.28 87.78 75.98 98.20 73.28 86.45 101.06 84.52 97.54 76.77.80 85.00 97.05 70.88 69.54 88.02 90.02Source of VariatioSS 70.08 81.60 99.05 72.26 86.98 75.48 65.45 92.49 62.65 SUMMARY Sum AverageVarlance Grou Column 1 Column 2 Column 3 Count 1102.25 73.48333333 99.404952 1369.88 91.32533333 69.560984 1237.88 82.52533333 85.391755 76.91 ANOVA P-value Fcrit 169.54 70.08 72.26 65.45 Between Groups 2387.67364 Within Groups 3561.00768 2 1193.83682 14.080606 2.0902E-05 3.219942293 42 84.78589714 13 1 14 Total 5948.68132 2 99.69 91.35 83.40 2 100.88 2 102.15 2 89.82 80.38 18 20 lations for tha nainuica com Sheet1 + Ready View 숲 RE Y-clear-目莔Flash Fil ata Review Tell me what you want to do Shar Data Validation vEv what-is Group ungroup v Subtotal cO Data Validation aphy lav sort Filter Advanced T 尿 Text to Columns Remove Duplicates Consolidate Analysis Please do your calculations for the pairwise comparison p-values in the highlighted boxes below. The test statistics and degrees of freedom have been provided Mean (pet) Mean (friend) Mean (neither)f N (friend)N (neither) MSEDF 73.48 91.33 82.53 15 15 15 84.785897 42 Pet v. Neither (1 v.3) Test statistic: 2.691643 Friend v. Neither (2 v. 3) Test statistic: 2.61728788 Pet v. Friend (1 v. 2) Test statistic p-value: 5.308930532 3.88424E-06 p-value: 0.0101652 p-value: 0.0122689

Answer 1

1.

Pet vs Friend: p-value = 3.884*10^-6 < 0.0167 i.e H₀ is rejected

Pet vs Neither: p-value = 0.0101652 < 0.0167 i.e H₀ is rejected

Friend vs Neither: p-value = 0.0122689 < 0.0167 i.e H₀ is rejected.

2.

As the observed F value is 14.08 is larger than the critical value of 3.22, the result may be interpreted as statistically significant difference among the means of the groups at the α error level 0.0167. The result suggests to rejection of the null hypothesis that all the group means are the same, and coincidently supports that at least one group mean differs from other group means.

Please upvote if you have liked my answer, would be of great help. Thank you.