This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
This is a hands-on, project-based course designed to help you learn and apply essential statistics concepts for data analysis & business intelligence. Our goal is to simplify and demystify the world of statistics using familiar tools like Microsoft Excel, and empower everyday people to understand and apply these tools and techniques – even if you have absolutely no background in math or stats!
We’ll start by discussing the role of statistics in business intelligence, the difference between sample and population data, and the importance of using statistical techniques to make smart predictions and data-driven decisions.
Next we’ll explore our data using descriptive statistics and probability distributions, introduce the normal distribution and empirical rule, and learn how to apply the central limit theorem to make inferences about populations of any type.
From there we’ll practice making estimates with confidence intervals, and using hypothesis tests to evaluate assumptions about unknown population parameters. We’ll introduce the basic hypothesis testing framework, then dive into concepts like null and alternative hypotheses, t-scores, p-values, type I vs. type II errors, and more.
Last but not least, we’ll introduce the fundamentals of regression analysis, explore the difference between correlation and causation, and practice using basic linear regression models to make predictions using Excel’s Analysis Toolpak.
Throughout the course, you’ll play the role of a Recruitment Analyst for Maven Business School. Your goal is to use the statistical techniques you’ve learned to explore student data, predict the performance of future classes, and propose changes to help improve graduate outcomes.
You’ll also practice applying your skills to 5 real-world BONUS PROJECTS, and use statistics to explore data from restaurants, medical centers, pharmaceutical companys, safety teams, airlines, and more.
COURSE OUTLINE:
-
Why Statistics?
-
Discuss the role of statistics in the context of business intelligence and decision-making, and introduce the statistics workflow
-
-
Understanding Data with Descriptive Statistics
-
Understand data using descriptive statistics, including frequency distributions and measures of central tendency & variability
-
PROJECT #1: Maven Pizza Parlor
-
-
Modeling Data with Probability Distributions
-
Model data with probability distributions, and use the normal distribution to calculate probabilities and make value estimates
-
PROJECT #2: Maven Medical Center
-
-
The Central Limit Theorem
-
Introduce the Central Limit Theorem, which leverages the normal distribution to make inferences on populations with any distribution
-
-
Making Estimates with Confidence Intervals
-
Make estimates with confidence intervals, which use sample statistics to define a range where an unknown population parameter likely lies
-
PROJECT #3: Maven Pharma
-
-
Drawing Conclusions with Hypothesis Tests
-
Draw conclusions with hypothesis tests, which let you evaluate assumptions about population parameters using sample statistics
-
PROJECT #4: Maven Safety Council
-
-
Making Predictions with Regression Analysis
-
Make predictions with regression analysis, and estimate the values of a dependent variable via its relationship with independent variables
-
PROJECT #5: Maven Airlines
-
Join today and get immediate, lifetime access to the following:
-
7.5 hours of high-quality video
-
Statistics for Data Analysis PDF ebook (150+ pages)
-
Downloadable Excel project files & solutions
-
Expert support and Q&A forum
-
30-day Udemy satisfaction guarantee
If you’re an analyst, data scientist, business intelligence professional, or anyone looking to use statistics to make smart, data-driven decisions, this course is for you!
Happy learning!
-Enrique Ruiz (Lead Statistics & Excel Instructor, Maven Analytics)
Why Statistics?
Understanding Data with Descriptive Statistics
PROJECT #1: Maven Pizza Parlor
-
12Section Intro
-
13Descriptive Statistics Basics
-
14Types of Variables
-
15Types of Descriptive Statistics
-
16Categorical Frequency Distributions
-
17Numerical Frequency Distributions
-
18Histograms
-
19ASSIGNMENT: Frequency Distributions
-
20KNOWLEDGE CHECK: Frequency Distributions
-
21SOLUTION: Frequency Distributions
-
22Mean, Median, and Mode
-
23Left & Right Skew
-
24ASSIGNMENT: Measures of Central Tendency
-
25KNOWLEDGE CHECK: Measures of Central Tendency
-
26SOLUTION: Measures of Central Tendency
-
27Min, Max & Range
-
28Interquartile Range
-
29Box & Whisker Plots
-
30Variance & Standard Deviation
-
31PRO TIP: Coefficient of Variation
-
32ASSIGNMENT: Measures of Variability
-
33KNOWLEDGE CHECK: Measures of Variability
-
34SOLUTION: Measures of Variability
-
35Key Takeaways
-
36QUIZ: Descriptive Statistics
Modeling Data with Probability Distributions
PROJECT #2: Maven Medical Center
-
39Section Intro
-
40Probability Distribution Basics
-
41Types of Probability Distributions
-
42The Normal Distribution
-
43Z Scores
-
44The Empirical Rule
-
45ASSIGNMENT: Normal Distributions
-
46KNOWLEDGE CHECK: Normal Distributions
-
47SOLUTION: Normal Distributions
-
48Excel's Normal Distribution Functions
-
49Calculating Probabilities with the Normal Distribution
-
50The NORM.DIST Function
-
51The NORM.S.DIST Function
-
52ASSIGNMENT: Calculating Probabilities
-
53KNOWLEDGE CHECK: Calculating Probabilities
-
54SOLUTION: Calculating Probabilities
-
55PRO TIP: Plotting the Normal Curve
-
56Estimating X or Z Values with the Normal Distribution
-
57The NORM.INV Function
-
58The NORM.S.INV Function
-
59ASSIGNMENT: Estimating Values
-
60KNOWLEDGE CHECK: Estimating Values
-
61SOLUTION: Estimating Values
-
62Key Takeaways
-
63QUIZ: Probability Distributions