Excel Statistics / Data Analytics

Excel Statistics / Data Analytics, available at $54.99, has an average rating of 4.6, with 14 lectures, 3 quizzes, based on 169 reviews, and has 724 subscribers.

You will learn about 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 This course is ideal for individuals who are 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 or Those looking to increase their knowledge of Data Analytics or Everyone looking to augment their job skills in this important and fast growing area or Those looking to gain a strong command of data analytics It is particularly useful for 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 or Those looking to increase their knowledge of Data Analytics or Everyone looking to augment their job skills in this important and fast growing area or Those looking to gain a strong command of data analytics.

Enroll now: Excel Statistics / Data Analytics

Summary

Title: Excel Statistics / Data Analytics

Price: $54.99

Average Rating: 4.6

Number of Lectures: 14

Number of Quizzes: 3

Number of Published Lectures: 14

Number of Published Quizzes: 3

Number of Curriculum Items: 17

Number of Published Curriculum Objects: 17

Original Price: $64.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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!

Course Curriculum

Chapter 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

Chapter 2: Inferential Statistics – Tests of Two Means

Lecture 1: Independent Samples t Test

Lecture 2: Dependent Samples t Test

Chapter 3: Inferential Statistics – ANOVA (Analysis of Variance)

Lecture 1: One-way ANOVA

Lecture 2: Post-Hoc Tests

Chapter 4: Inferential Statistics – Correlation and Regression

Lecture 1: Correlation (Part 1)

Lecture 2: Correlation (Part 2)

Lecture 3: Correlation with Three or More Variables

Lecture 4: Multiple Regression (Part 1)

Lecture 5: Multiple Regression (Part 2)

Chapter 5: Conclusion

Lecture 1: Conclusion and other Courses by Quantitative Specialists

Instructors

Quantitative Specialists
Specializing in Statistics, Research Design, and Measurement

Rating Distribution

1 stars: 3 votes
2 stars: 3 votes
3 stars: 20 votes
4 stars: 65 votes
5 stars: 78 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu