AGENDA
Goodness of fit with Excel
Review
Quiz

IN EXCEL
Frequency
Data_array, bins_array
Range operation
CTRL-SHIFT-ENTER
Norminv
Probability, mean, std
Chiinv
Probability, df

HYPOTHESES
Null
 sigma squared = sigma squared 0
Alternate
 sigma squared < sigma squared 0 (1 sided)
 sigma squared > sigma squared 0 (1 sided)
 sigma squared  not equal to sigma squared 0 (2 sided)

HYPOTHESES CONCERNING ONE VARIANCE TEST STATISTIC

HYPOTHESES CONCERNING TWO VARIANCES
Null
 sigma squared 1= sigma squared 2
Alternate 1
 sigma squared 1< sigma squared 2 (1 sided)
F=variance 2 / variance 1
Alternate 2
 sigma squared 1> sigma squared 2 (1 sided)
F=variance 1 / variance 2
Alternate 3
 sigma squared 1 not equal to sigma squared 2 (2 sided)
F =variance larger / variance smaller

HYPOTHESES CONCERNING TWO VARIANCES TEST STATISTIC

CHI-SQUARED TEST STATISTIC