F Distribution ......................................................................................................... 31
Chi-square Distribution .......................................................................................... 32
Confidence Intervals / Sample Size ............................................................. 33
Confidence interval – mean ................................................................................... 33
Confidence interval – p .......................................................................................... 33
Sample size –mean ............................................................................................... 33
Sample size – p ..................................................................................................... 34
Sample size –mean, p, and mean with specified and ....................................... 34
Hypothesis Tests ........................................................................................... 35
Mean vs. Hypothesized Values .............................................................................. 35
Compare Two Independent Groups ....................................................................... 36
Paired Observations .............................................................................................. 36
Proportion vs. Hypothesized Value ........................................................................ 37
Compare Two Independent Proportions ................................................................ 37
Chi-square Variance Test ...................................................................................... 38
Analysis of Variance ..................................................................................... 39
One-Factor ANOVA ............................................................................................... 39
Randomized Blocks ANOVA .................................................................................. 40
Two Factor ANOVA ............................................................................................... 41
Correlation / Regression ............................................................................... 42
Scatterplot ............................................................................................................. 42
Correlation Matrix .................................................................................................. 43
Regression Analysis .............................................................................................. 44
Predictor values from worksheet cells ................................................................ 44
Type in predictor values ..................................................................................... 45
Select Options: .................................................................................................. 45
Select Residuals options .................................................................................... 46
Time Series / Forecasting ............................................................................. 47
Trendline Curve Fit ................................................................................................ 47
Deseasonalization ................................................................................................. 48
Moving Average ..................................................................................................... 49
Exponential Smoothing .......................................................................................... 49
Simple Exponential Smoothing .............................................................................. 49
Two-factor Exponential Smoothing ........................................................................ 50
Chi-Square / Crosstab ................................................................................... 51
Contingency Table ................................................................................................. 51
Crosstabulation ...................................................................................................... 52