# Ch. 11 Formulas.xlsx - Chi Squared Distribution Statistical...

• 8

This preview shows page 1 - 3 out of 8 pages.

Chi Squared Distribution: Statistical Inference Concerning VarianData4.80.017.4Sample Size, n32Intermediate CalculationsDegrees of Freedom3147.7916666666667P-ValuesLeft (lower) Tail p-Value0.972447854690499Right (Upper) Tail p-Value0.027552145309501Two-Tailed p-Value0.05510429061900255.002703880023914.457767385669Lower Value-0.134538840420308Upper Value-0.511835596921771Lower ValueErr:502Upper ValueErr:502"differs" equals two tail when looking for right P value"variance" is chapter 11"means" chapter 10Population Hypothesized Variance (σ02)Level of Significance, αSample Variance, s2Test Statistic, χ2dfP-Value Approach: if p < α, rejeConfidence Interval for population variance, σ2Two-tail Critical value, α/2, dfTwo-tail Critical value, 1-α/2, dfConfidence Interval for standard deviation, σReject if the population parameter, σ02, doesn't fall within this reg
nceHypothesis Test for the population varian=population stdev^2=sample stdev^2 or =var.s=B7-1=((B7-1)*B6)/B4=CHISQ.DIST(B11,B10, TRUE)47.79167 )=CHISQ.DIST.RT(B11,B10)47.79167 )=2*MIN(B14:B15)47.79167 )=CHISQ.INV.RT(B5/2,B10)=CHISQ.INV(B5/2,B10)=((B7-1)*B6)/B19=((B7-1)*B6)/B20=SQRT(B21)=SQRT(B22)χ2df