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
-
-
Welcome
-
Course Structure
-
ScholarU Community
-
About You Survey
-
Course Content
-
Copying Course Content
-
Cheat Sheet
-
-
-
Population and Sample
-
Check: Population and Sample
-
Variable Types
-
Check: Variable Types 1
-
Check: Variable Types 2
-
Check: Variable Types 3
-
Check: Variable Types 4
-
Histograms
-
Histogram using Spreadsheets
-
Histogram - Google Sheets
-
Relative and Cumulative Distribution
-
Relative and Cumulative Distribution using Spreadsheets (Excel only)
-
Manual Histogram, Relative and Cumulative Distribution using Spreadsheets
-
Central Tendency: Mean, Median and Mode
-
Check: Mean
-
Check: Median
-
Check: Mode
-
Central Tendency: Mean, Median and Mode using Spreadsheets
-
Measures of Dispersion: Range, Mean Absolute Deviation, Variance and Standard Deviation
-
Variance: Why divide by n-1?
-
Check: Range
-
Check: Mean Absolute Deviation
-
Check: Variance
-
Check: Standard Deviation
-
Measures of Dispersion: Range, Mean Absolute Deviation, Variance and Standard Deviation using Spreadsheets
-
Skewness
-
Skewness using Spreadsheets
-
Skewness Spreadsheet Formula
-
Summary Statistics
-
Exercise: Basic Statistics
-
Exercise: Basic Statistics - Introduction
-
Exercise: Basic Statistics - Solution
-
-
-
Probability Introduction
FREE PREVIEW -
Check: Probability Introduction
FREE PREVIEW -
Random Variables
FREE PREVIEW -
Sample Space
FREE PREVIEW -
Check: Sample Space
FREE PREVIEW -
Basic Probabilities
-
Check: Basic Probabilities
-
Modeling Basic Probabilities using Spreadsheets
-
Disjoint Events
-
Check: Disjoint Events 1
-
Check: Disjoint Events 2
-
Joint Events
-
Modeling Joint Events using Spreadsheets
-
Check: Joint Events
-
Independence and Probability Trees
-
Modeling Independence using Spreadsheets
-
Complement
-
Check: Complement
-
Conditional Probability
-
Modeling Conditional Probability using Spreadsheets
-
Exercise: Introduction to Probability
-
Exercise: Introduction to Probability - Introduction
-
Exercise: Introduction to Probability - Solution
-
-
-
Probability and Cumulative Mass Functions
-
Check: Cumulative Mass Function
-
Discrete and Continuous Probability Functions
-
Uniform Distribution
-
Check: Uniform Distribution
-
Uniform Distribution using Spreadsheets
-
Normal Distribution
-
Check: Normal Distribution
-
z-score
-
Check: z-score
-
Normal Distribution using Spreadsheets
-
Sampling from a Probability Distribution
-
Fitting a Distribution
-
Sampling and Fitting a Distribution using Spreadsheets
-
Exercise: Distribution
-
Exercise: Distribution - Introduction
-
Exercise: Distribution - Solution
-
-
-
Introduction to Correlation
-
Correlation Equation
-
Correlation Examples
-
Anscombe's Quartet
-
Check: Correlation
-
Correlation Demo using Spreadsheets
-
Exercise: Correlation
-
Exercise: Correlation - Introduction
-
Exercise: Correlation - Solution
-
-
-
Line Equation
-
Check: Linear Regression
-
Simple Linear Regression
-
Fitting to the Data
-
Multiple Linear Regression
-
Other Considerations
-
Simple Linear Regression using Spreadsheets
-
Fitting to the Data using Spreadsheets
-
Exercise: Linear Regression
-
Exercise: Linear Regression - Introduction
-
Exercise: Linear Regression - Solution
-

About this course
- $149.00
- 5-10 hrs