Statistics Tests Using Software 

Topics Covered 
Step 1 Complete Quick
Statistics Using Microsoft (TM) Excel 
Descriptive Statistics
Answers 
array, frequency distribution, measures of central tendency, dispersion, 
range, skewness, and a Pivot Table (TM) analyzing three variables 
Probability
Answers 
binomial and Poisson probability distributions 
binomial and Poisson cumulative probability distributions 
probability and range of the continuous normal probability distribution 
point and interval estimates of the population mean 

Hypothesis Testing Answers 
large sample hypothesis testing of one and two sample means 
ttest of two independent sample means from populations with equal variances 
paired difference ttest for independence 
two sample F test for the equality of two variances 
one and two factor ANOVA 
chisquare test for independence 
Sheets 12 and 13 Correlation and Regression 
scatter diagram 
correlation 
simple and multiple regression 
correlating three variables 
testing for the significance of the coefficient of correlation 