Statistics Tests Using Software
Please link to, use to educate, as a textbook/supplement and share.
Return to
Statistics Lab Manual  Updated 7/20/18  

Topics Covered

Step 1  Complete Quick Statistics Using Microsoft (TM) Excel
 using the password aprilblackie to open


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
t-test of two independent sample means from populations with equal variances
paired difference t-test for independence
two sample F test for the equality of two variances
one and two factor ANOVA
chi-square test for independence
Sheets 12 and 13 Correlation and Regression
scatter diagram
simple and multiple regression
correlating three variables
testing for the significance of the coefficient of correlation

Designed for Use With Our

 Our Free Programmed Textbook

For free Quick Notes student use link to the related Quick site.  Thanks!  Walter Antoniotti

Quick Notes Statistics   pdf

2 page outlines of college Statistics I and II. Two lab sets and
Quick Questions with complete solutions provided

The entire book is written as a business case where users
 see how college student Linda Evans used statistics to manage Linda's Video Showcase. 
Readers can then do statistics for Linda's friend Darin Smith who follows his retailing
company Darin's Music Emporium with manufacturing company Future Horizons Corporation. 

Excel Statistics Lab Manual is written in Excel so you have the problems with directions  
and data sets right in a live Excel sheet. Within a few minutes you use Excel to do problems.
Just follow the directions and quickly see the result. Problems are those encountered
by Darin Jones in free book
Quick Notes Statistics.      

1. 1-Page Class Notes
Quick Reviews
3. Video Lectures

Exams with Answers
2. Problems

3. Tests

4. Research Project

Statistics Software Video Lectures Excel     Minitab     SPSS     I-84

Practice Set Instructions with Answers for    SPSS       MiniTab      StataQuest

Free Courses Materials Excel   Minitab   SPSS   TI-84   Excel Statistics loads into spreadsheets

Behavioral Science Statistics    Research Paper Guidance   

AP, SAT Test Prep test and strategy help