Excel Statistics / Data Analytics
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 245.61 MB | Duration: 1h 36m
Get Marketable Data Analytic Skills Using the Microsoft Excel Data Analysis ToolPak
What you'll learn

Run a variety of statistical analyses in Excel (using the Analysis Toolpak), know when to use a given statistical procedure covered in this course, and know how to make a proper conclusion from a statistical test, including professionally written results
Requirements
Learn how to conduct and interpret statistical analysis in Microsoft Excel
A PC computer (not a Mac) is required to use the Data Analysis Toolpak in Excel (Microsoft no longer supports the toolpak for Macs; it cannot be installed unless using a PC)
Learn how to interpret the results of statistical analyses, including proper conclusions from the tests
Learn how to express statistical results in a professionally written format
Learn from a PhD award-winning instructor and textbook author with over 20 years experience teaching statistics!
Check out all of our highly-rated courses in Udemy for other examples of our content
Description
Get marketable data analytic skills in this course using Microsoft Excel. This course will substantially increase your knowledge of data analytics using the extremely popular Microsoft Excel software program, with a focus in the area of significance testing, an important tool for A/B testing and product assessment.
Many tests covered, including different t tests, ANOVA, post hoc tests, correlation, and regression.
This course is great for professionals, as it provides step by step instruction of tests with clear and accurate explanations. Get ahead of the competition and make these tests important parts of your data analytic toolkit!
Students will also have the tools needed to succeed in their statistics and experimental design courses.
In this course, a number statistical procedures will be covered in Microsoft Excel using the Data Analysis TookPak.
The following statistical procedures will be covered in this course
Central Tendency (Mean, Median, Mode)Variability (Standard Deviation, Variance, Range)t tests (Independent t and Dependent t)Analysis of Variance (ANOVA)Post Hoc TestsCorrelationMultiple Regression
For each test, we will cover
How to perform the analysis step-by-step in Microsoft ExcelWhat the results mean in clear, yet accurate languageHow to effectively, accurately, and professionally communicate the results to others, clearly demonstrating your understanding of the material.
Enroll in this course and obtain important marketable data analytic skills today!
Overview
Section 1: Course Introduction, Installing the Analysis ToolPak, & Descriptive Statistics
Lecture 1 Introduction
Lecture 2 Installing the Data Analysis Toolpak in Excel
Lecture 3 Descriptive Statistics in Excel - One Variable
Lecture 4 Descriptive Statistics in Excel - Two or More Variables
Section 2: Inferential Statistics - Tests of Two Means
Lecture 5 Independent Samples t Test
Lecture 6 Dependent Samples t Test
Section 3: Inferential Statistics - ANOVA (Analysis of Variance)
Lecture 7 One-way ANOVA
Lecture 8 Post-Hoc Tests
Section 4: Inferential Statistics - Correlation and Regression
Lecture 9 Correlation (Part 1)
Lecture 10 Correlation (Part 2)
Lecture 11 Correlation with Three or More Variables
Lecture 12 Multiple Regression (Part 1)
Lecture 13 Multiple Regression (Part 2)
Section 5: Conclusion
Lecture 14 Conclusion and other Courses by Quantitative Specialists
Students seeking to learn more about conducting statistical analyses, and how to properly interpret those analyses (valid conclusions to make), including how to write the results professionally and succinctly,Those looking to increase their knowledge of Data Analytics,Everyone looking to augment their job skills in this important and fast growing area,Those looking to gain a strong command of data analytics
Screenshots