Question

To test the effectiveness of the use of technology in a statistics course, four different sections were taught with different combinations of calculators and computer software, with final course averages listed below for randomly selected students from each section. Test the claim that the samples come from populations that are not all the same.

	Calculators only 74 85 91 62 73 87 66 80
					Calculators and Computers 78 89 82 64 77 91 73 85
			Computers only 82 87 60 71 77 63 84 70
							No Calculators and no Computers 66 78 83 55 72 57 81 65

Answer 1

A single factor ANOVA is used in excel to test the null hypothesis that all the means are equal. The hypothesis is defined as,

Null Hypothesis:

Alternative hypothesis; All the means are not equal.

The test is perfomed in excel by using following steps,

Step 1: Write the data values in excel. The screenshot is shown below,

Step 2: DATA > Data Analysis > ANOVA: Single Factor > OK.  The screenshot is shown below,

Step 3: Select Input Range: All the data values column. The screenshot is shown below,

The result is obtained.  The screenshot is shown below,

From the result summary,

The P-value is greater than 0.05 at 5% significance level hence the null hypothesis can not be rejected. Now, we can state that there is no statistically significant difference among means at 5% significance level.