1. Calculate the sample proportion of people who have a Degree.Use it to test the claim that fewer than 16% of the population have a Degree.State your null and alternative hypotheses clearly.Calculate the test statistic and use Excel to give a rejection region or p-value.State which you choose and what it is, and draw a conclusion.

H₀ : p = 0.16

H_a : p < 0.16

P = 0.16

P-value = 0.00034355

The p-value is smaller than 5% so we reject H₀ in favour of H_a

Estimated Proportions with 95% Confidence Interval

LowerEstimateUpper

Degree0.1090.1600.211

None0.1360.1900.244

School0.2510.3150.379

Vocational0.2700.3350.400

Chi-square test for equal proportions

X^2 = 18.52, df = 3, p-value = 0.00034355