Welcome to Applications of Business Statistics.

This course is designed as an introduction to basic statistical concepts and techniques used to investigate trends in business using Microsoft Excel. This supplemental content is being updated to include Python for Excel tutorials.

Course Journey

image.png

Calculators

Z, T, F and Chi-Square Calculator.xlsx

Resources

mini cases

brain teasers

datasets

additional reading/articles

Video Recordings

short articles

from intervals to one sample test

Learn Python for Excel Labs

Lab A: Python Dataframes in Excel

Lab B: Summary Statistics w/ Intervals

Lab C: Independent Sample Tests (t-test)

Lab D: Dependent Sample Tests (paired t-test)

Lab E: ANOVA

Lab F: Correlation & Regression