I need help with this problem. Please work in excel and provide as detailed a so

Question

I need help with this problem. Please work in excel and provide as detailed a solution as possible with the excel formulas please and thank you.

The Problem 5 worksheet in the Data file provides a sample of the old process values (for this particular quality characteristic). What is a 99% confidence interval for the variance of this characteristic?

10.64036 11.36062 9.094978 9.827601 10.69243 11.0357 9.653397 9.46653 8.580584 8.903137 9.172142 10.92813 9.101869 11.94227 10.56998 9.869923 8.854083 9.986562 10.13444 10.81102 10.02226 9.047728 9.608071 8.610901 9.866898 9.950185 10.64956 10.18276 8.253054 9.222754

Explanation / Answer

Use the excel function VAR.S(A1:A30) = 0.804857 to calculate th variance of the data (where A1: A30 is where the data is stored)

Now calculate Chi-Square critical values at 1% significance level will be using Excel function

CHISQ.INV(0.01/2,29) = 13.12115

CHISQ.INV(0.99+(0.01/2),29) = 52.33562

99% Interval

(29*0.804857/52.33562), (29*0.804857/13.12115)

= (0.44598, 1.77887)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---