Excel Statistics / Data Analytics

Course details

Get marketable data analyticskills in this course using Microsoft Excel.This coursewill 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 testsimportantpartsof 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 coveredin 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:

1. How to perform the analysis step-by-stepin Microsoft Excel
2. What the results meanin clear, yetaccurate language
3. How to effectively,accurately, and professionallycommunicatethe results to others, clearly demonstratingyour understanding of the material.

Enroll in this course and obtain importantmarketable data analytic skills today!