About the Course

If you harbor a curiosity for the enigmas of probability and statistics, and wish to master the art of extrapolating data from a sample to a population, join us in exploring the dynamic realm of "Probability and Statistics using Spreadsheets." This course is your key to unraveling the foundational principles of probability and statistics, employing the capabilities of spreadsheets.

In the contemporary business landscape, the demand for professionals adept at managing, analyzing, and visually interpreting probability and statistics is escalating. This course stands as an indispensable initial stride for individuals aspiring to forge a career in business analysis.

Throughout the course's duration, you will cultivate essential skills in extrapolating information from samples to populations, understanding central tendency, and measuring dispersion. Delve into the intricacies of correlation and linear regression. Master the art of leveraging formulas, functions, and chart creation within spreadsheets to derive insightful outcomes. The curriculum seamlessly integrates practical exercises and real-world case studies, ensuring the application of acquired knowledge to authentic scenarios.

Upon course completion, you will possess the proficiency and comprehension to scrutinize probabilistic and statistical models, extract meaningful insights, and elevate your analytical capabilities to new heights. Embark on this enlightening journey today and be equipped with the skills demanded in today's dynamic business landscape.

Who should take this course?

This course caters to individuals eager to embark on a career in business analysis, including pre-MBA students. It also serves as a valuable resource for professionals seeking to augment their expertise in this field.

Course Duration:

The course is self-paced and it takes between 5-10 hours to complete including watching the videos, and working on the knowledge checks, exercises and case studies.  

Course Support:

There is a community page where you can ask questions, share your ideas and knowledge, and connect with other students and the staff.

Prerequisites: 

  • Access to a spreadsheet tool like Excel or Google Sheets.
  • Basic familiarity with spreadsheet functions (e.g., xlookup, pivot tables and if statements) and chart creation. Dominate the content in Excel for Beginners or Google Sheets for Beginners.
  • A thirst for knowledge.


*Courses can be conducted live online or in person upon request. For more information send an email ([email protected])!


Course curriculum

    1. Welcome

    2. Course Structure

    3. ScholarU Community

    4. About You Survey

    5. Course Content

    6. Copying Course Content

    7. Cheat Sheet

    1. Population and Sample

    2. Check: Population and Sample

    3. Variable Types

    4. Check: Variable Types 1

    5. Check: Variable Types 2

    6. Check: Variable Types 3

    7. Check: Variable Types 4

    8. Histograms

    9. Histogram using Spreadsheets

    10. Histogram - Google Sheets

    11. Relative and Cumulative Distribution

    12. Relative and Cumulative Distribution using Spreadsheets (Excel only)

    13. Manual Histogram, Relative and Cumulative Distribution using Spreadsheets

    14. Central Tendency: Mean, Median and Mode

    15. Check: Mean

    16. Check: Median

    17. Check: Mode

    18. Central Tendency: Mean, Median and Mode using Spreadsheets

    19. Measures of Dispersion: Range, Mean Absolute Deviation, Variance and Standard Deviation

    20. Variance: Why divide by n-1?

    21. Check: Range

    22. Check: Mean Absolute Deviation

    23. Check: Variance

    24. Check: Standard Deviation

    25. Measures of Dispersion: Range, Mean Absolute Deviation, Variance and Standard Deviation using Spreadsheets

    26. Skewness

    27. Skewness using Spreadsheets

    28. Skewness Spreadsheet Formula

    29. Summary Statistics

    30. Exercise: Basic Statistics

    31. Exercise: Basic Statistics - Introduction

    32. Exercise: Basic Statistics - Solution

    1. Probability Introduction

      FREE PREVIEW
    2. Check: Probability Introduction

      FREE PREVIEW
    3. Random Variables

      FREE PREVIEW
    4. Sample Space

      FREE PREVIEW
    5. Check: Sample Space

      FREE PREVIEW
    6. Basic Probabilities

    7. Check: Basic Probabilities

    8. Modeling Basic Probabilities using Spreadsheets

    9. Disjoint Events

    10. Check: Disjoint Events 1

    11. Check: Disjoint Events 2

    12. Joint Events

    13. Modeling Joint Events using Spreadsheets

    14. Check: Joint Events

    15. Independence and Probability Trees

    16. Modeling Independence using Spreadsheets

    17. Complement

    18. Check: Complement

    19. Conditional Probability

    20. Modeling Conditional Probability using Spreadsheets

    21. Exercise: Introduction to Probability

    22. Exercise: Introduction to Probability - Introduction

    23. Exercise: Introduction to Probability - Solution

    1. Probability and Cumulative Mass Functions

    2. Check: Cumulative Mass Function

    3. Discrete and Continuous Probability Functions

    4. Uniform Distribution

    5. Check: Uniform Distribution

    6. Uniform Distribution using Spreadsheets

    7. Normal Distribution

    8. Check: Normal Distribution

    9. z-score

    10. Check: z-score

    11. Normal Distribution using Spreadsheets

    12. Sampling from a Probability Distribution

    13. Fitting a Distribution

    14. Sampling and Fitting a Distribution using Spreadsheets

    15. Exercise: Distribution

    16. Exercise: Distribution - Introduction

    17. Exercise: Distribution - Solution

    1. Introduction to Correlation

    2. Correlation Equation

    3. Correlation Examples

    4. Anscombe's Quartet

    5. Check: Correlation

    6. Correlation Demo using Spreadsheets

    7. Exercise: Correlation

    8. Exercise: Correlation - Introduction

    9. Exercise: Correlation - Solution

    1. Line Equation

    2. Check: Linear Regression

    3. Simple Linear Regression

    4. Fitting to the Data

    5. Multiple Linear Regression

    6. Other Considerations

    7. Simple Linear Regression using Spreadsheets

    8. Fitting to the Data using Spreadsheets

    9. Exercise: Linear Regression

    10. Exercise: Linear Regression - Introduction

    11. Exercise: Linear Regression - Solution

About this course

  • $149.00
  • 5-10 hrs

Discover your potential, starting today