Essential Statistics for Data Analysis

Focused View

Maven Analytics,Enrique Ruiz

7:47:43

387 View

1. Getting Started

1. Course Structure & Outline.mp4

01:59

2. READ ME Important Notes for New Students.html

3.1 Statistics for Data Analysis.pdf

3.2 Statistics for Data Analysis.zip

3. DOWNLOAD Course Resources.html

4. Setting Expectations.mp4

01:57

5. The Course Project.mp4

02:48

6. Helpful Resources.mp4

02:30

2. Why Statistics

1. Section Intro.mp4

01:04

2. Why Statistics.mp4

01:42

3. Populations & Samples.mp4

02:43

4. The Statistics Workflow.mp4

02:29

5. QUIZ Why Statistics.html

3. Understanding Data with Descriptive Statistics

1. Section Intro.mp4

01:14

2. Descriptive Statistics Basics.mp4

01:26

3. Types of Variables.mp4

02:07

4. Types of Descriptive Statistics.mp4

02:41

5. Categorical Frequency Distributions.mp4

08:13

6. Numerical Frequency Distributions.mp4

06:47

7. Histograms.mp4

06:17

8. ASSIGNMENT Frequency Distributions.mp4

01:52

9. KNOWLEDGE CHECK Frequency Distributions.html

10. SOLUTION Frequency Distributions.mp4

03:43

11. Mean, Median, and Mode.mp4

13:36

12. Left & Right Skew.mp4

03:11

13. ASSIGNMENT Measures of Central Tendency.mp4

00:58

14. KNOWLEDGE CHECK Measures of Central Tendency.html

15. SOLUTION Measures of Central Tendency.mp4

03:09

16. Min, Max & Range.mp4

02:20

17. Interquartile Range.mp4

06:25

18. Box & Whisker Plots.mp4

04:53

19. Variance & Standard Deviation.mp4

07:05

20. PRO TIP Coefficient of Variation.mp4

03:28

21. ASSIGNMENT Measures of Variability.mp4

01:12

22. KNOWLEDGE CHECK Measures of Variability.html

23. SOLUTION Measures of Variability.mp4

08:16

24. Key Takeaways.mp4

01:15

25. QUIZ Descriptive Statistics.html

4. PROJECT #1 Maven Pizza Parlor

1. PROJECT BRIEF Maven Pizza Parlor.mp4

01:56

2. SOLUTION Maven Pizza Parlor.mp4

08:12

5. Modeling Data with Probability Distributions

1. Section Intro.mp4

01:14

2. Probability Distribution Basics.mp4

02:58

3. Types of Probability Distributions.mp4

02:05

4. The Normal Distribution.mp4

05:16

5. Z Scores.mp4

04:31

6. The Empirical Rule.mp4

04:08

7. ASSIGNMENT Normal Distributions.mp4

01:14

8. KNOWLEDGE CHECK Normal Distributions.html

9. SOLUTION Normal Distributions.mp4

04:20

10. Excels Normal Distribution Functions.mp4

01:17

11. Calculating Probabilities with the Normal Distribution.mp4

02:24

12. The NORM.DIST Function.mp4

05:14

13. The NORM.S.DIST Function.mp4

03:42

14. ASSIGNMENT Calculating Probabilities.mp4

00:50

15. KNOWLEDGE CHECK Calculating Probabilities.html

16. SOLUTION Calculating Probabilities.mp4

02:20

17. PRO TIP Plotting the Normal Curve.mp4

06:57

18. Estimating X or Z Values with the Normal Distribution.mp4

00:52

19. The NORM.INV Function.mp4

02:33

20. The NORM.S.INV Function.mp4

02:11

21. ASSIGNMENT Estimating Values.mp4

00:52

22. KNOWLEDGE CHECK Estimating Values.html

23. SOLUTION Estimating Values.mp4

01:26

24. Key Takeaways.mp4

01:35

25. QUIZ Probability Distributions.html

6. PROJECT #2 Maven Medical Center

1. PROJECT BRIEF Maven Medical Center.mp4

01:18

2. SOLUTION Maven Medical Center.mp4

10:02

7. The Central Limit Theorem

1. Section Intro.mp4

00:52

2. The Central Limit Theorem.mp4

03:14

3. DEMO Proving the Central Limit Theorem.mp4

03:18

4. Standard Error.mp4

02:40

5. Implications of the Central Limit Theorem.mp4

02:22

6. Applications of the Central Limit Theorem.mp4

01:20

7. Key Takeaways.mp4

01:13

8. QUIZ The Central Limit Theorem.html

8. Making Estimates with Confidence Intervals

1. Section Intro.mp4

01:12

2. Confidence Intervals Basics.mp4

03:36

3. Confidence Level.mp4

01:53

4. Margin of Error.mp4

04:47

5. DEMO Calculating Confidence Intervals.mp4

03:06

6. The CONFIDENCE.NORM Function.mp4

01:52

7. ASSIGNMENT Confidence Intervals.mp4

01:11

8. KNOWLEDGE CHECK Confidence Intervals.html

9. SOLUTION Confidence Intervals.mp4

02:57

10. Types of Confidence Intervals.mp4

01:34

11. T Distribution.mp4

01:57

12. Excels T Distribution Functions.mp4

01:45

13. Confidence Intervals with the T Distribution.mp4

05:20

14. ASSIGNMENT Confidence Intervals (T Distribution).mp4

00:45

15. KNOWLEDGE CHECK Confidence Intervals (T Distribution).html

16. SOLUTION Confidence Intervals (T Distribution).mp4

03:29

17. Confidence Intervals for Proportions.mp4

07:21

18. ASSIGNMENT Confidence Intervals (Proportions).mp4

00:51

19. KNOWLEDGE CHECK Confidence Intervals (Proportions).html

20. SOLUTION Confidence Intervals (Proportions).mp4

02:55

21. Confidence Intervals for Two Populations.mp4

02:31

22. Dependent Samples.mp4

05:19

23. ASSIGNMENT Confidence Intervals (Dependent Samples).mp4

00:50

24. KNOWLEDGE CHECK Confidence Intervals (Dependent Samples).html

25. SOLUTION Confidence Intervals (Dependent Samples).mp4

02:38

26. Independent Samples.mp4

08:48

27. ASSIGNMENT Confidence Intervals (Independent Samples).mp4

00:41

28. KNOWLEDGE CHECK Confidence Intervals (Independent Samples).html

29. SOLUTION Confidence Intervals (Independent Samples).mp4

05:56

30. PRO TIP Difference Between Proportions.mp4

06:54

31. Key Takeaways.mp4

01:29

32. QUIZ Confidence Intervals.html

9. PROJECT #3 Maven Pharma

1. PROJECT BRIEF Maven Pharma.mp4

01:20

2. SOLUTION Maven Pharma.mp4

05:56

10. Drawing Conclusions with Hypothesis Tests

1. Section Intro.mp4

01:15

2. Hypothesis Testing Basics.mp4

02:58

3. Null & Alternative Hypothesis.mp4

05:06

4. Significance Level.mp4

03:08

5. Test Statistic (T-score).mp4

03:50

6. P-Value.mp4

05:08

7. Drawing Conclusions from Hypothesis Tests.mp4

04:46

8. ASSIGNMENT Hypothesis Tests.mp4

01:18

9. KNOWLEDGE CHECK Hypothesis Tests.html

10. SOLUTION Hypothesis Tests.mp4

03:49

11. Relationship between Confidence Intervals & Hypothesis Tests.mp4

02:34

12. Type I & Type II Errors.mp4

03:47

13. One Tail & Two Tail Hypothesis Tests.mp4

02:56

14. DEMO One Tail Hypothesis Test.mp4

04:40

15. Hypothesis Tests for Proportions.mp4

00:47

16. ASSIGNMENT Hypothesis Tests (Proportions).mp4

01:21

17. KNOWLEDGE CHECK Hypothesis Tests (Proportions).html

18. SOLUTION Hypothesis Tests (Proportions).mp4

05:26

19. Hypothesis Tests for Dependent Samples.mp4

01:26

20. ASSIGNMENT Hypothesis Tests (Dependent Samples).mp4

01:21

21. KNOWLEDGE CHECK Hypothesis Tests (Dependent Samples).html

22. SOLUTION Hypothesis Tests (Dependent Samples).mp4

05:40

23. Hypothesis Tests for Independent Samples.mp4

01:19

24. ASSIGNMENT Hypothesis Tests (Independent Samples).mp4

01:09

25. KNOWLEDGE CHECK Hypothesis Tests (Independent Samples).html

26. SOLUTION Hypothesis Tests (Independent Samples).mp4

04:39

27. Key Takeaways.mp4

02:31

28. QUIZ Hypothesis Tests.html

11. PROJECT #4 Maven Safety Council

1. PROJECT BRIEF Maven Safety Council.mp4

01:08

2. SOLUTION Maven Safety Council.mp4

13:10

12. Making Predictions with Regression Analysis

1. Section Intro.mp4

01:07

2. Linear Relationships.mp4

04:41

3. Correlation (R).mp4

05:16

4. ASSIGNMENT Linear Relationships.mp4

00:48

5. KNOWLEDGE CHECK Linear Relationships.html

6. SOLUTION Linear Relationships.mp4

02:18

7. Linear Regression & Least Squared Error.mp4

09:45

8. Excels Linear Regression Functions.mp4

04:15

9. ASSIGNMENT Simple Linear Regression.mp4

00:48

10. KNOWLEDGE CHECK Simple Linear Regression.html

11. SOLUTION Simple Linear Regression.mp4

03:56

12. Determination (R-Squared).mp4

08:42

13. Standard Error.mp4

03:43

14. Homoskedasticity & Heteroskedasticity.mp4

02:24

15. Hypothesis Testing with Regression.mp4

06:49

16. ASSIGNMENT Model Evaluation.mp4

00:38

17. KNOWLEDGE CHECK Model Evaluation.html

18. SOLUTION Model Evaluation.mp4

07:20

19. Excels Regression Tool (Analysis ToolPak).mp4

05:14

20. PRO TIP Multiple Linear Regression.mp4

08:14

21. Key Takeaways.mp4

02:22

22. QUIZ Regression Analysis.html

13. PROJECT #5 Maven Airlines

1. PROJECT BRIEF Maven Airlines.mp4

01:28

2. SOLUTION Maven Airlines.mp4

12:04

14. BONUS LESSON

1. BONUS LESSON.html

Description

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

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

Who is this for?

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

More details

Description
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)
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Maven Analytics helps individuals and teams build expert-level analytics & business intelligence skills. We've helped more than 1,000,000 students around the world build job-ready skills, master sought-after tools like Excel, SQL, Power BI, Tableau & Python, and build the foundation for a successful career in data. At Maven Analytics, we empower everyday people to change the world with data.

Enrique Ruiz

Instructor's Courses

Enrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis, and visualization. He has been producing advanced Excel and test prep courses at Maven Analytics since 2016, along with adaptations tailored to Spanish-speaking learners.A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.