Answer to Question #185697 in Statistics and Probability for kevin

Question

The data shows the number of students attending a private school in the city and the number of students attended schools in the suburb. At a=.01, is there enough evidence to support the claim that the average number of students attending a private school in the city is greater than the number of students attending the suburb schools?

private school

25 75 38 41 27 32  

suburbs

57 25 38 14 10 29

Answer 1

To test the difference the null and alternative hypotheses are defined as follows:

H₀: μ₁ = μ₂

H₁: μ₁ > μ₂

Use the following instruction set to obtain the ANOVA table using EXCEL software:

1. Type or import data intto adjecent colomns.

2. Click Data→Data Analysis →Anova:Single Factor.

3. Specify the input range of the data.

4. Click Ok.

The EXCEL out put for the given data is as shown below:

The F value calculated 1.11 < critical value F(crit) of 10.04. The probability to obtain this result by chance (P-value) was calculated as 0.315 or 31.5 %. So, we are able to conclude that there was not significant difference in average number of students attending a private school in the city and the number of students attending the suburb schools.