Excel Statistics Essential Training: 1

Focused View

Eddie Davila

3:36:46

272 View

01 - Introduction

01 - Course introduction.mp4

00:33

02 - What you need to know.mp4

00:50

03 - Exercise files.mp4

01:12

02 - 1. Starting with Excel

01 - Excel basics.mp4

10:43

02 - Random number generator.mp4

11:28

03 - 2. Dataset Basics

01 - Sum, Count, Max, Min, and Range.mp4

11:15

02 - Means, medians, and modes.mp4

10:07

04 - 3. Looking at Data

01 - Frequency table.mp4

09:01

02 - Histogram.mp4

07:05

05 - 4. Dataset Variability

01 - Standard deviation.mp4

11:54

02 - Normal curve and normal distribution.mp4

03:07

03 - Skewness and kurtosis.mp4

11:55

04 - Empirical rule.mp4

10:59

06 - 5. Excel Descriptive Tools

01 - Descriptive tool.mp4

06:32

02 - Descriptive tool exercise.mp4

07:23

07 - 6. Basic Probability Concepts

01 - Probability explained.mp4

09:09

02 - Percentiles.mp4

11:16

03 - Permutations.mp4

06:56

04 - Combinations.mp4

06:24

05 - Addition rule of probability.mp4

07:58

06 - Multiplication rule of probability.mp4

04:43

07 - Conditional probability and probability trees.mp4

07:56

08 - 7. Discrete Probabilities

01 - Discrete probability explained.mp4

03:50

02 - Discrete Mean.mp4

04:10

03 - Discrete Standard deviation.mp4

08:48

04 - Discrete Binomial distribution.mp4

09:03

09 - 8. Continuous Probabilities

01 - Continuous Z-score tables.mp4

06:36

02 - Continuous Creating a normal curve in Excel.mp4

07:35

03 - Continuous Calculating normal distribution probabilities.mp4

07:33

10 - Conclusion

01 - Next steps and additional resources.mp4

00:45

Description

Data isn’t valuable until you put it to good use. Statistics transforms data into meaningful information, enabling organizations to make better decisions and predictions. That’s why statistics—collecting, analyzing, and presenting data—is a valuable skill for anyone in business or academia. In this course, statistics and business analysis instructor Eddie Davila takes you on a nuanced, step-by-step journey to mastering statistics through Excel. Eddie first teaches the basic principles of statistics with a series of examples, then advances your understanding by extending those same examples into more complex applications of statistical theory—all while using Excel and Excel's statistics tools and functions.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Statistics

Excel

Excel Analytics

Excel Modeling

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.