Excel Statistics / Data Analytics

Focused View

Quantitative Specialists

1:36:01

22 View

1 - Course Introduction Installing the Analysis ToolPak & Descriptive Statistics

1 - Introduction.mp4

05:27

2 - Installing the Data Analysis Toolpak in Excel.mp4

02:04

3 - Descriptive Statistics in Excel One Variable.mp4

04:48

3 - descriptivestatisticsonevariablexlsx.zip

4 - Descriptive Statistics in Excel Two or More Variables.mp4

10:03

4 - descriptivestatisticsxlsx.zip

2 - Inferential Statistics Tests of Two Means

1 - T Tests.html

5 - Independent Samples t Test.mp4

08:19

5 - iphonexlsx.zip

6 - Dependent Samples t Test.mp4

09:59

6 - dependenttxlsx.zip

3 - Inferential Statistics ANOVA Analysis of Variance

2 - ANOVA and post hoc tests.html

7 - Oneway ANOVA.mp4

10:09

7 - anovaxlsx.zip

8 - PostHoc Tests.mp4

14:51

8 - anovaposthocxlsx.zip

4 - Inferential Statistics Correlation and Regression

3 - Correlation and Regression.html

9 - Correlation Part 1.mp4

02:13

9 - correlationxlsx.zip

10 - Correlation Part 2.mp4

05:15

11 - Correlation with Three or More Variables.mp4

04:28

12 - Multiple Regression Part 1.mp4

06:41

12 - multipleregressionxlsx.zip

13 - Multiple Regression Part 2.mp4

09:36

5 - Conclusion

14 - Conclusion and other Courses by Quantitative Specialists.mp4

02:08

Description

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

Who is this 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

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

What You Need to Know?

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

More details

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 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!
Who this course is 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
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

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Excel Analytics

Quantitative Specialists

Instructor's Courses

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!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.