Free OpenStax Virtual Course

The following materials are presented freely for the OpenStax community. It is a complete statistics course that can be used to supplement virtual stats courses. Follow the order of the chapters. Excel labs are included for free.

Access the OpenStax Statistics book for free at https://openstax.org/books/introductory-statistics-2e/pages/1-introduction.

Chapter 1

• Chapter 1 Lecture Notes and Labs:

  • Part 1: 1.1, 1.2, Excel Lab 1

    • Part 1 Notes

    • Excel Lab 1

    • Section 1.1 Video

    • Section 1.2 Video

    • Excel Lab 1 Video (we have a ton of basics to cover so this video is long - sorry!!)

  • Part 2: 1.3, 1.4, Excel Lab 2

    • Part 2 Notes

    • Excel Lab 2

    • Section 1.3 Video

    • Excel Lab 2 Video

    • Section 1.4 Video

• Additional Resources to Help You Practice Chapter 1:

  • All the Excel Labs in One Workbook and separate videos for each tab:

    • Excel Cells Intro

    • Basic Formatting for Cells

    • Basic Formulas

    • Dragging and Locking Cells

    • Locking Cells

    • Frequency Example 1

    • Frequency Example 2

  • Book Problems

    • Practice Questions #16 - #23 (full frequency table creation) explained

    • Homework Question #81 explained

Chapter 2

• Chapter 2 Lecture Notes and Labs:

  • Part 1: 2.1, 2.2, 2.3, Excel Lab 3

    • Part 1 Notes

    • Excel Lab 3

    • Section 2.1 Video

    • Section 2.2 Video

    • Section 2.3 Video

  • Part 2: 2.4, 2.5, 2.6, 2.7, Excel Lab 4

    • Part 2 Notes

    • Excel Lab 4

    • Section 2.4 Video

    • Section 2.5 Video

    • Section 2.6 Video

    • Section 2.7 Video

• Additional Resources to Help You Practice Chapter 2:

  • All the Excel Labs in One Workbook with videos for each tab:

    • Bar and Line Graphs

    • Time Series Graph

    • Frequency and Histograms (Same 2 tabs in 2 ways)

    • Estimating a Mean from a Frequency Table

    • Median and Quartiles

    • Percentiles

    • Box and Whisker Plots

    • Standard Deviation

  • Book Problems

    • Practice Question #5 explained

    • Homework Question #92 explained

    • Homework Question #104 explained

Chapter 3

• Chapter 3 Lecture Notes and Labs:

  • Part 1: 3.1, 3.2, Excel Lab 5

    • Part 1 Notes

    • Excel Lab 5

    • Section 3.1 Video

    • Section 3.2 Video

  • Part 2: 3.3, 3.4, 3.5, Excel Lab 6

    • Part 2 Notes

    • Excel Lab 6

    • Section 3.3 Video

    • Section 3.4 Video

    • Section 3.5 Video

Chapter 4

• Chapter 4 Lecture Notes and Labs:

  • Part 1: 4.1, 4.2, Excel Lab 7

    • Part 1 Notes

    • Excel Lab 7

    • Section 4.1 Video

    • Section 4.2 Video

  • Part 2: 4.3, Reviewing Techniques, Excel Lab 8

    • Part 2 Notes

    • Excel Lab 8

    • Section 4.3 Video

    • Reviewing Techniques Video

Exam 1 Review

• Exam 1 Review Packet

• Exam 1 Review Excel Spreadsheet

• Video for Chapter 1 Review

• Video for Chapter 2 Review

• Video for Chapter 3 Review

• Video for Chapter 4 Review

Chapter 5

• Chapter 5 Lecture Notes and Labs:

  • Part 1: 5.1, 5.2

    • Part 1 Notes

    • Excel Lab 9 (for section 5.2 only)

    • Section 5.1 Video

    • Section 5.2 Video

  • Part 2: Putting It All Together

    • Part 2 Notes

    • Excel Lab 10

    • Putting It All Together Video

    • Heads up: Chapter 6 videos are a bit longer. Chapter 5 videos were a little shorter, so you might want to get started early on Chapter 6!

Chapter 6

• Chapter 6 Lecture Notes and Labs:

  • Part 1: Introduction, 6.1

    • Part 1 Notes

    • Excel Lab 11

    • Introduction Video

    • Section 6.1 Video

  • Part 2: 6.2, Normal Distribution Approximating the Binomial Distribution

    • Part 2 Notes

    • Excel Lab 12

    • Section 6.2 Video

    • Normal Distribution Approximating the Binomial Distribution Video

    • Putting It All Together Video