On this page you will find the virtual handouts for our course.
MS Excel How To's
Notes and Video Tutorials
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.
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:
In Excel, Click on the Data tab on top
On the right side you should see a section called “Analysis tools,” Click on it
A new window appears for “Add-ins” and “Analysis ToolPak” should be listed there.
Check the box for “Analysis ToolPak” and click “OK”
The function should now appear under “Analysis tools” as “Data Analysis”
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
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
This section contains printable sets of brief notes summarized from lectures.
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
Zoom Recorded Review Session for Exam #4 (2-sample tests; correlation and regression) [YouTube]
Practice Problems for the Quiz (Exam #1)
Practice Problems for Midterm (Exam #1 + Exam #2)
Practice Problems for Topic: Inference [Two Practice Sets]
Practice Problems for Topic: Two-Sample tests (assorted) - from November 28, 2023 class
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.
FAQ for the Final Exam
FAQ for the Comprehensive Final Exam, for Prof. Linda Friedman's students at Baruch College.