In: Statistics and Probability
Reading journal articles can be challenging for students, as they are often technical in nature. A high school that prides itself on preparing students for college wants to purchase journals that are written at a level accessible to students. The school librarian recruits four students with varying academic ability to read articles from four different journals and rate their readability from 1 (very difficult to read and understand) to 7 (very easy to read and understand). Some hypothetical data are shown in the table.
Table: Journal and Readability
Journal 1 | Journal 2 | Journal 3 | Journal 4 |
2 | 3 | 4 | 5 |
1 | 3 | 3 | 5 |
2 | 4 | 4 | 6 |
2 | 4 | 3 | 6 |
a) Perform an F test at alpha level .05, using excel. Submit your
workbook showing the results.
b) What is the conclusion in terms of the null hypothesis, reject
or fail to reject? Explain why.
Answer a.
Null Hypothesis, Ho: There is no significant difference in the mean ratings for four different journals i.e.
Alternative Hypothesis, Ha: There exists at least one journal for which mean rating is significantly different from others i.e. for at least one
Excel Output:
Answer b. Since p-value = 7.29E-06 < 0.05 so we Reject Ho at 5% level of significance and conclude that There exists at least one journal for which mean rating is significantly different from others i.e. for at least one
Excel Steps:
1. Go to Data - Data Analysis - ANOVA: Single Factor
2. Enter the input range of data.
3. Select Grouped by Columns
3. Click on labels in first row.
4. Enter Output Range to current sheet.
5. Click OK