Learn marketable data analytic skills using Microsoft Excel's Data Analysis ToolPak. Master various statistical tests and enhance your analytics toolkit today!
This course is all about giving you the data analytics skills you need to shine in your job! Using Excel's Data Analysis ToolPak, you'll dive into important statistical tests and learn how to present your findings like a pro.
Get Marketable Data Analytic Skills Using the Microsoft Excel Data Analysis ToolPak
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!
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
4 Lectures
2 Lectures
5 Lectures
Quantitative Specialists (QS) was founded by an award-winning university instructor who has taught statistics courses for over 15 years. At QS, we are passionate about all things statistical, especially in helping others understand this often-feared subject matter. Our focus is in helping you to succeed in all your statistics work!
Exactly what I was looking for.
Now I can do some work on Excel
So far its explained quite well
Its easy to understand, Great thanks ...
A good course on how to use some of the basic statistical features found in excel. The examples are kept simple so you are able to follow along easily. The explanations are clear and you come away with a good understanding of the concepts presented. A good overall course!
Yes. It was good.
So far, it is good.
The course gives you a quick jump on learning Data Analysis.
This short course was great. It shows how to use Excel for the most common descriptive and inferential stats. There are no forumulas, and it's all done from the menus rather having to recall functions to type in, as other courses do. If you just want to be able to use Excel for these functions without worrying about the mathematical underpinning or being an Excel wizard, this is great.
Your email address will not be published. Required fields are marked *
Kim J.
This was a very useful introduction to some of the statistical tests in Excel. The instructor explained everything really clearly and it was helpful to be able to follow along with the downloads.