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
correlation
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.      

Supplements
 1. 1-Page Class Notes
2. 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 load into spreadsheets

Excel   Minitab   SPSS   TI-84   Excel Statistics

 

Behavioral Science Statistics    Research Paper Guidance   

AP, SAT Test Prep test and strategy help