17. FILE (Use Excel) Ac ces s th e mi les per g a l lon (mpg...

Question:

17. FILE (Use Excel) Ac ces s th e mi les per g a l lon (mpg ) data on th e te x t w e b s i t e labe led MPG.

a. State th e null and th e alternative h yp o the s e s in order to tes t whe the r or not th e variance o f mp g differs from 62 m p g 2.

b. Calculate th e relevant t e s t statistic.

c. Use Excel's fu n c t ion (either CHISQ.DIST.RT or CHISQ.DIST)

to calculate th e p -value.

d. Make a c onc lus ion at α = 0.01.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: