Statistics Tests Using Software
Please link to, use to educate,
 as a textbook/supplement and share

Return to
Statistics Lab Manual  Updated 7/2/21 

Topics Covered

Step 1  Use the Excel password aprilblackie to open
  Quick Statistics Using Microsoft (TM) Excel.
Following the directions to learn statistics using Excel.

 Step 2 Complete these 4 Tests

Descriptive Statistics with Answers array, frequency distribution, measures of central tendency, dispersion, range, Skewness, and a Pivot Table (TM) analyzing three variables

Probability with 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 with 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


Research Project


Statistics Software Video Lectures

Excel     Minitab     SPSS     I-84

Practice Set Instructions with Answers for

  SPSS  MiniTab  StataQuest

Free Courses Materials load into spreadsheets

Excel   Minitab   SPSS   TI-84   Excel Statistics


Behavioral Science Statistics    Research Paper Guidance   

AP, SAT Test Prep test and strategy help