Do You Know These Statistics Concepts? Full Excel Crash Course скачать в хорошем качестве

Do You Know These Statistics Concepts? Full Excel Crash Course

Download the Course Materials here: https://data-heroes-2.ck.page/statist... My best offer for the complete course on Udemy: https://www.udemy.com/course/statisti... In this comprehensive 4-hour crash course, you will learn how to master statistics on Excel from a novice to a pro level. Whether you are a student, professional, or just looking to enhance your data analysis skills, this course is perfect for you. Throughout the course, you will learn how to use Excel to perform various statistical analyses, including mean, median, mode, standard deviation, correlation, regression, and much more. You will get a deep dive into Confidence Interval, learning concepts like confidence level and margin of error), and Hypothesis Testing while mastering one and two-tail tests, the p-value, and other types of statistics tests. You will also discover how to create visually appealing charts and graphs to present your data effectively. By the end of this course, you will have the knowledge and skills to confidently tackle any statistical analysis task in Excel. So, what are you waiting for? Start now and take your Excel skills to the next level! 📈📚 Get a Free eBook on Conjoint Analysis with Python: https://data-heroes-2.ck.page/conjoin... 📘 Follow me on Instagram:   / the.datahero   Timecodes 00:00 - Intro 00:01:27 - Game Plan For Descriptive Statistics 00:02:45 - Key Statistical Concepts 00:09:40 - Measures of Central Tendency: Mean, Median, Mode 00:50:50 - Standard Deviation and Variance 00:59:15 - Coefficient of Variation 01:04:05 - Normal Distribution 01:14:20 - Covariance and Correlation 01:27:55 - CASE STUDY: Sports Analytics 01:31:52 - Game Plan For Confidence Intervals 01:34:36 - Standard Error, Z-score and Confidence Levels 01:57:23 - Confidence Intervals for Large / Small Samples 02:29:45 - Game Plan for Hypothesis Testing 02:35:14 - Hypothesis Testing: p-value, Type I and II Errors 02:52:48 - 2-Tailed Tests: Known and Unknown Variance 03:17:02 - 2-Tailed Tests: Paired T-Test 03:29:15 - 2-Tailed Tests: 2-Sample T-Test 03:44:04 - 1-Tailed Tests 04:07:32 - Outro