Excel Statistics Essential Training: 2

Focused View

Eddie Davila

3:24:08

69 View

01 - Introduction

01 - Using Excel for statistics.mp4

00:43

02 - What you need to know.mp4

00:58

03 - Exercise files.mp4

01:16

04 - Tool pack.mp4

01:32

02 - 1. Sampling

01 - Sample considerations.mp4

12:41

02 - The central limit theorem.mp4

10:22

03 - T-statistic vs. z-statistic.mp4

14:33

03 - 2. Confidence Intervals

01 - Introduction to confidence intervals.mp4

03:42

02 - Creating confidence intervals in Excel (proportions).mp4

12:46

03 - Creating confidence intervals in Excel (means).mp4

12:54

04 - 3. Hypothesis Tests

01 - How to test a hypothesis.mp4

02:12

02 - Five steps of hypothesis testing.mp4

06:10

03 - One-tailed vs. two-tailed tests.mp4

03:28

04 - Hypothesis test exercise (means).mp4

17:21

05 - Hypothesis test exercise (proportions).mp4

08:00

05 - 4. Comparing Two Populations

01 - Explanation of two population comparisons.mp4

02:35

02 - Comparing two populations (proportions).mp4

09:58

03 - Comparing two populations (means).mp4

16:09

06 - 5. ANOVA Analysis of Variance

01 - ANOVA What is analysis of variance.mp4

09:45

02 - Hypothesis test and the F-statistic.mp4

13:26

07 - 6. Regression

01 - What is regression.mp4

02:56

02 - Regression terminology.mp4

03:39

03 - Linear regressions.mp4

15:37

08 - 7. Simulation

01 - What are simulations.mp4

01:54

02 - Monte Carlo simulation example.mp4

09:30

03 - Business simulation example.mp4

09:08

09 - Conclusion

01 - Continue learning Excel statistics.mp4

00:53

Description

Data isn’t valuable until you figure out what the data actually mean. Statistics transforms data into meaningful information, enabling organizations to make more informed decisions. That’s why statistics—collecting, analyzing, and presenting data—is a valuable skill for anyone in business or academia.

In this course, LinkedIn Learning statistics and business analysis instructor Eddie Davila takes you on a nuanced, step-by-step applied learning path to understanding statistics and statistical methods in Excel. Eddie first teaches the basic principles of statistical sampling, and then utilizes random samples to explore complex applications of statistical theory—all while using Excel statistics tools and functions. He covers topics like regression, hypothesis tests, analysis of variance (ANOVA), and Monte Carlo simulations, showing how Excel can help you tackle and interpret advanced statistical analyses.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Statistics

Excel

Eddie Davila

Instructor's Courses

Theater, business, and materials science engineering. What could I possibly do with that mix of training/education? Little did I know that everything I had done would create the perfect mix for the life I would have today. Supply chain is sort of a perfect mix of business and engineering concepts. Teaching in lecture halls is theater. Online videos are my opportunity to write and be on-screen. Students and co-workers create the perfect atmosphere to drive me creatively. I've taught over 30,000 students in-person, thousands more in online classes, and millions have seen my online videos. I’ve been blessed with an incredibly rewarding life and career. I'm constantly looking for opportunities to be the dumbest person in the room. On a never-ending search for new ways to inspire, educate, and innovate. I hate best practices. Always looking to do things the wrong way.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.