# Handouts

On this page you will find the virtual handouts for our course.

## Formulas and Tables

Formulas and Tables- This is a printable pdf that includes formulas and statistical tables you will need for this course.

## MS Excel How To's

Notes and Video Tutorials

### Notes

Each of the following contains simple instructions. You may wish to print and keep them near your computer while you complete your MS Excel assignments.

Some Summary Statistics

If you need help installing this Add-in, check out this YouTube video at https://youtu.be/_yNxLFagKgw

If you are using Office 365 (you may get it free through your college) on a Mac:

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 https://youtu.be/-ZfAiaFucEY

Scatter Plots

Binomial

Two-sample t-test

Examples of Two-Sample t-Tests

Regression

More regression examples

### Videos

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 [YouTube]

Using Excel to Compute the Correlation Coefficient [YouTube]

Using Excel to Perform Regression Analysis [YouTube]

## To Prep for Exams

### Study Sheets

This section contains printable sets of brief notes summarized from lectures.

Some Definitions

Terminology Review

Rules of Probability

Using the Z Distribution for Confidence Interval Estimation

General Formula for Confidence Interval Estimators

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

Steps in Regression

### Review Sessions

A Review session for Exam #2 (Probability through Sampling Distributions) [PPT (no narration) ||PDF ]

A Review Session for Inference Problems [ppt Lecture || PDF || YouTube Video]

A Review Session - Two-sample t-tests with MS Excel [ppt Lecture || PDF || YouTube Video]

A Review Session - Solving Regression Problems with MS Excel [ppt Lecture || PDF || YouTube Video]

Zoom Recorded Review Session for Exam #4 (2-sample tests; correlation and regression) [YouTube]

### Introductory MaterialDescriptive Statistics

Practice Problems for the Quiz (aka Exam #1)

also see the Mixed Materials section

### Correlation & Regression

Practice Problem for Correlation and Regression (Sept 21, 2023)  PPT | PDF

### Mixed Material

Practice Problems for Midterm (Exam #1 + Exam #2)

Practice Problems for Exam  (covering two-sample inference, correlation, regression)

Practice Problems for the Comprehensive Final Exam

### How-to Study Guide

In general, the best way to study for any exam in this course is to do lots and lots of problems.

Still TBD:  How To Study for the Inference Exam: A YouTube Video (created with Screencast-O-Matic). Note his video is old - the course website has been recently updated.

### FAQ for the Final Exam

FAQ for the Comprehensive Final Exam, for Prof. Linda Friedman's students at Baruch College.