Question

A random sample of n₁ = 16 communities in western Kansas gave the following information for people under 25 years of age.

x₁: Rate of hay fever per 1000 population for people under 25

98	90	120	128	92	123	112	93
125	95	125	117	97	122	127	88

A random sample of n₂ = 14 regions in western Kansas gave the following information for people over 50 years old.

x₂: Rate of hay fever per 1000 population for people over 50

97	110	103	96	114	88	110
79	115	100	89	114	85	96

1. Calculate S1, round to two decimal places

2. What is the value of the sample test statistic? Compute the corresponding z or t value as appropriate. (Test the difference μ₁ − μ₂. Do not use rounded values. Round your answer to three decimal places.)

3. Find a 90% confidence interval for μ₁ − μ₂. (Round your answers to two decimal places.)

Upper Limit =

Lower Limit =

Answer 1

Hey I have used excel for this but don't worry methodology is manual one only.

I haven't use any special function for t test. all calculation are done using formula for t test for difference of means.

These are formula used in excel

Please upvote if I am able to help you with this.

Thanks