Brief Introduction
Get Marketable Data Analytic Skills Using the Microsoft Excel Data Analysis ToolPakDescription
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 Tests
- Correlation
- Multiple Regression
For each test, we will cover:
- How to perform the analysis step-by-step in Microsoft Excel
- What the results mean in clear, yet accurate language
- How 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!
Requirements
- 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
Quantitative Specialists
4.5 Raiting
Business Statistics with Excel
- 3.5
-
![]()
![]()
![]()
![]()
![]()
Learn business statistics from basic to expert level through a practical course with Excel. All of this while exploring the wisdom of best academics and practitioners in the field....
Microsoft Excel - Data Analysis with Excel Pivot Tables
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Master Excel pivots & learn data analysis w/ advanced Excel cases from a top Excel & business intelligence instructor "This is a great Excel course....
Excel 2016 Pivot Tables Deep Dive
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Become indispensable at work! Become a power user and earn a huge raise by working Pivot magic in Excel. ***** CLEAR AND CRISP VIDEO RESOLUTION *****...
Bayesian Statistics: From Concept to Data Analysis
- 4.6
-
![]()
![]()
![]()
![]()
![]()
This course introduces the Bayesian approach to statistics, starting with the concept of probability and moving to the analysis of data....
