# Essential Statistics for Data Analysis

Learn statistics with fun, real-world projects; probability distributions, hypothesis tests, regression analysis & more!

4.6/5

## Essential Statistics for Data Analysis

### What you’ll learn

Learn powerful statistics tools and techniques for data analysis & business intelligence
Understand how to apply foundational statistics concepts like the central limit theorem and empirical rule
Explore data with descriptive statistics, including probability distributions and measures of variability & central tendency
Model data and make estimates using probability distributions and confidence intervals
Make data-driven decisions and draw conclusions with hypothesis testing
Use linear regression models to explore variable relationships and make predictions

### Requirements

No math or stats background is required – we’ll start with the absolute basics!
We’ll use Microsoft Excel (Office 365) for course projects and demos

### Overview

Section 1: Getting Started

Lecture 1 Course Structure & Outline

Lecture 2 READ ME: Important Notes for New Students

Lecture 4 Setting Expectations

Lecture 5 The Course Project

Section 2: Why Statistics?

Lecture 7 Section Intro

Lecture 8 Why Statistics?

Lecture 9 Populations & Samples

Lecture 10 The Statistics Workflow

Section 3: Understanding Data with Descriptive Statistics

Lecture 11 Section Intro

Lecture 12 Descriptive Statistics Basics

Lecture 13 Types of Variables

Lecture 14 Types of Descriptive Statistics

Lecture 15 Categorical Frequency Distributions

Lecture 16 Numerical Frequency Distributions

Lecture 17 Histograms

Lecture 18 ASSIGNMENT: Frequency Distributions

Lecture 19 SOLUTION: Frequency Distributions

Lecture 20 Mean, Median, and Mode

Lecture 21 Left & Right Skew

Lecture 22 ASSIGNMENT: Measures of Central Tendency

Lecture 23 SOLUTION: Measures of Central Tendency

Lecture 24 Min, Max & Range

Lecture 25 Interquartile Range

Lecture 26 Box & Whisker Plots

Lecture 27 Variance & Standard Deviation

Lecture 28 PRO TIP: Coefficient of Variation

Lecture 29 ASSIGNMENT: Measures of Variability

Lecture 30 SOLUTION: Measures of Variability

Lecture 31 Key Takeaways

Section 4: PROJECT #1: Maven Pizza Parlor

Lecture 32 PROJECT BRIEF: Maven Pizza Parlor

Lecture 33 SOLUTION: Maven Pizza Parlor

Section 5: Modeling Data with Probability Distributions

Lecture 34 Section Intro

Lecture 35 Probability Distribution Basics

Lecture 36 Types of Probability Distributions

Lecture 37 The Normal Distribution

Lecture 38 Z Scores

Lecture 39 The Empirical Rule

Lecture 40 ASSIGNMENT: Normal Distributions

Lecture 41 SOLUTION: Normal Distributions

Lecture 42 Excel’s Normal Distribution Functions

Lecture 43 Calculating Probabilities with the Normal Distribution

Lecture 44 The NORM.DIST Function

Lecture 45 The NORM.S.DIST Function

Lecture 46 ASSIGNMENT: Calculating Probabilities

Lecture 47 SOLUTION: Calculating Probabilities

Lecture 48 PRO TIP: Plotting the Normal Curve

Lecture 49 Estimating X or Z Values with the Normal Distribution

Lecture 50 The NORM.INV Function

Lecture 51 The NORM.S.INV Function

Lecture 52 ASSIGNMENT: Estimating Values

Lecture 53 SOLUTION: Estimating Values

Lecture 54 Key Takeaways

Section 6: PROJECT #2: Maven Medical Center

Lecture 55 PROJECT BRIEF: Maven Medical Center

Lecture 56 SOLUTION: Maven Medical Center

Section 7: The Central Limit Theorem

Lecture 57 Section Intro

Lecture 58 The Central Limit Theorem

Lecture 59 DEMO: Proving the Central Limit Theorem

Lecture 60 Standard Error

Lecture 61 Implications of the Central Limit Theorem

Lecture 62 Applications of the Central Limit Theorem

Lecture 63 Key Takeaways

Section 8: Making Estimates with Confidence Intervals

Lecture 64 Section Intro

Lecture 65 Confidence Intervals Basics

Lecture 66 Confidence Level

Lecture 67 Margin of Error

Lecture 68 DEMO: Calculating Confidence Intervals

Lecture 69 The CONFIDENCE.NORM Function

Lecture 70 ASSIGNMENT: Confidence Intervals

Lecture 71 SOLUTION: Confidence Intervals

Lecture 72 Types of Confidence Intervals

Lecture 73 T Distribution

Lecture 74 Excel’s T Distribution Functions

Lecture 75 Confidence Intervals with the T Distribution

Lecture 76 ASSIGNMENT: Confidence Intervals (T Distribution)

Lecture 77 SOLUTION: Confidence Intervals (T Distribution)

Lecture 78 Confidence Intervals for Proportions

Lecture 79 ASSIGNMENT: Confidence Intervals (Proportions)

Lecture 80 SOLUTION: Confidence Intervals (Proportions)

Lecture 81 Confidence Intervals for Two Populations

Lecture 82 Dependent Samples

Lecture 83 ASSIGNMENT: Confidence Intervals (Dependent Samples)

Lecture 84 SOLUTION: Confidence Intervals (Dependent Samples)

Lecture 85 Independent Samples

Lecture 86 ASSIGNMENT: Confidence Intervals (Independent Samples)

Lecture 87 SOLUTION: Confidence Intervals (Independent Samples)

Lecture 88 PRO TIP: Difference Between Proportions

Lecture 89 Key Takeaways

Section 9: PROJECT #3: Maven Pharma

Lecture 90 PROJECT BRIEF: Maven Pharma

Lecture 91 SOLUTION: Maven Pharma

Section 10: Drawing Conclusions with Hypothesis Tests

Lecture 92 Section Intro

Lecture 93 Hypothesis Testing Basics

Lecture 94 Null & Alternative Hypothesis

Lecture 95 Significance Level

Lecture 96 Test Statistic (T-score)

Lecture 97 P-Value

Lecture 98 Drawing Conclusions from Hypothesis Tests

Lecture 99 ASSIGNMENT: Hypothesis Tests

Lecture 100 SOLUTION: Hypothesis Tests

Lecture 101 Relationship between Confidence Intervals & Hypothesis Tests

Lecture 102 Type I & Type II Errors

Lecture 103 One Tail & Two Tail Hypothesis Tests

Lecture 104 DEMO: One Tail Hypothesis Test

Lecture 105 Hypothesis Tests for Proportions

Lecture 106 ASSIGNMENT: Hypothesis Tests (Proportions)

Lecture 107 SOLUTION: Hypothesis Tests (Proportions)

Lecture 108 Hypothesis Tests for Dependent Samples

Lecture 109 ASSIGNMENT: Hypothesis Tests (Dependent Samples)

Lecture 110 SOLUTION: Hypothesis Tests (Dependent Samples)

Lecture 111 Hypothesis Tests for Independent Samples

Lecture 112 ASSIGNMENT: Hypothesis Tests (Independent Samples)

Lecture 113 SOLUTION: Hypothesis Tests (Independent Samples)

Lecture 114 Key Takeaways

Section 11: PROJECT #4: Maven Safety Council

Lecture 115 PROJECT BRIEF: Maven Safety Council

Lecture 116 SOLUTION: Maven Safety Council

Section 12: Making Predictions with Regression Analysis

Lecture 117 Section Intro

Lecture 118 Linear Relationships

Lecture 119 Correlation (R)

Lecture 120 ASSIGNMENT: Linear Relationships

Lecture 121 SOLUTION: Linear Relationships

Lecture 122 Linear Regression & Least Squared Error

Lecture 123 Excel’s Linear Regression Functions

Lecture 124 ASSIGNMENT: Simple Linear Regression

Lecture 125 SOLUTION: Simple Linear Regression

Lecture 126 Determination (R-Squared)

Lecture 127 Standard Error

Lecture 128 Homoskedasticity & Heteroskedasticity

Lecture 129 Hypothesis Testing with Regression

Lecture 130 ASSIGNMENT: Model Evaluation

Lecture 131 SOLUTION: Model Evaluation

Lecture 132 Excel’s Regression Tool (Analysis ToolPak)

Lecture 133 PRO TIP: Multiple Linear Regression

Lecture 134 Key Takeaways

Section 13: PROJECT #5: Maven Airlines

Lecture 135 PROJECT BRIEF: Maven Airlines

Lecture 136 SOLUTION: Maven Airlines

Section 14: BONUS LESSON

Lecture 137 BONUS LESSON

Aspiring data professionals who want an intuitive, beginner-friendly introduction to the world of statistics,Business intelligence professionals who want to make confident, data-driven decisions,Anyone using data to make assumptions, estimates or predictions on the job,Students looking to learn powerful, practical skills with unique, hands-on projects and demos

#### Course Information:

Udemy | English | 7h 51m | 2.84 GB
Created by: Maven Analytics

You Can See More Courses in the Business >> Greetings from CourseDown.com

Scroll to Top