Home‎ > ‎

### Handouts

#### Formulas and Tables

Formulas and Tables- A 2-page formula sheet is part of this packet

Some Statistical Tables - Many of these are included in the Formulas and Tables packet.
Z-Table - Example of the "0 to z" Standard Normal Distribution Table
Cumulative Z Table - from Levine et al. "Statistics for Managers" 5th ed.
Cumulative Z Table- from the MathLab of the Department of Mathematics, Sinclair Community College, Dayton, OH

#### MS Excel How To's

If you don't have the Analysis ToolPak Add-In (say, on your Mac), you can still get all the "Descriptives" using Excel . Check out this handy YouTube video at http://www.youtube.com/watch?v=-ZfAiaFucEY

#### Video Tutorials for Using MS Excel:

Using Excel to Compute the Sum and the Mean of a Set of Data [YouTube]
Using Excel to Compute some other Descriptive Statistics [YouTube]
Using the 'Descriptive Statistics' Tool in Excel  [YouTube]
Using Excel to Construct a Scatter Plot [
Using Excel to Compute the Correlation Coefficient [
Using Excel to Perform Regression Analysis [

#### To Prep for Exams

Formulas and Tables - this is what you will use for reference during exams

Study Sheets
Steps in Regression
Inference Overview - What to look for when you do the problems
Hypothesis Testing Sample Problem This worked-out problem illustrates the parts of a hypothesis test that MUST be present when you are asked to test a hypothesis.
A Deeper Understanding of Hypothesis Testing - Substantiating vs Refuting Claims

Practice Problems
Practice Problems for Midterm
Practice Problems for Topic: Sampling Distributions
Practice Problems for Topic: Inference  [Two Practice Sets]
Practice Problems for Topic: Correlation & Regression also available at
Practice Problem Set for Topic: Correlation & Regression
Practice Problems for the Comprehensive Final Exam

Final Exam FAQ - for Baruch College Students
Some additional problems for Baruch College Students (recitation classes)