Excel Statistics / Data Analytics

Get Marketable Data Analytic Skills Using the Microsoft Excel Data Analysis ToolPak

Created byQuantitative Specialists

Last updated 2/2017

English

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

Course content

5 sections • 14 lectures • 1h 36m total length

Introduction5:27
In this video, the course is introduced, including the topics covered and the goals and objectives of the course.

Great news!: As we will be using the Data Analysis ToolPak a great deal in this course, I am very pleased to report that it is now once again available for Mac users (beginning with Excel/Office 2017)! While it is not available on many earlier versions of Office for Macs (but has always been, and continues to be, available for Windows PC users), Mac users who have Excel 2017 will now be able to access this very useful ToolPak and can now take full advantage of all of the statistical procedures covered in this course!
Installing the Data Analysis Toolpak in Excel2:04
This video illustrates how to install the Data Analysis ToolPak in Microsoft Excel. This video illustrates how to make it available in Excel. Note: Good news - beginning with Excel 2017, the ToolPak is once again available on Macs!

For all of the statistics videos in the course (all videos onward), the Excel file containing the data, the results (output), and all notes used in the videos (including written results) are included as downloadable content within each video.
Descriptive Statistics in Excel - One Variable4:48
This video examines how to conduct and interpret a number of statistics in Excel, including the mean, median, mode, standard deviation, and range, among others.

The Descriptive Statistics.xlsx Excel file used in this video is attached (renamed Descriptive Statistics - One Variable to avoid confusion with the next lecture). There are 2 sheet tabs in the Excel File: Data (the numbers), Results and Notes (the Excel output and notes from the video included). The sheet tabs are located at the bottom left-hand corner of the Excel spreadsheet.
Descriptive Statistics in Excel - Two or More Variables10:03
This video examines how to conduct a number of statistics in Excel on two variables, including the mean, median, mode, standard deviation, variance, range, and many others.
The Descriptive Statistics.xlsx Excel file used in this video is attached. There are 2 sheet tabs in the Excel File: Data (the numbers), Results (the Excel output and notes from the video included). The sheet tabs are located at the bottom left-hand corner of the Excel spreadsheet.

Independent Samples t Test8:19
In this video, the independent samples t test is covered, which is used for testing whether two separate or unrelated groups (also called 'independent') differ significantly on some variable.
The iPhone.xlsx Excel file used in this video is attached. There are 3 sheet tabs in the Excel File: Data (the numbers), Results (the t test table), and Notes (all of the written notes used in the video). The sheet tabs are located at the bottom left-hand corner of the Excel spreadsheet.
Dependent Samples t Test9:59
In this video, the dependent samples t test is covered, which is used for testing differences between two identical (same people measured twice) or related groups. The most common application of this test is the pretest - posttest design, where people do some task twice (such as taking the SAT at pre-treatment and again at post-treatment).
The Dependent t.xlsx Excel file used in this video is attached. There are 2 sheet tabs in the Excel File: Data (the numbers), Results (the Excel output and notes from the video included). The sheet tabs are located at the bottom left-hand corner of the Excel spreadsheet.
T Tests

One-way ANOVA10:09
In this video, the one-way ANOVA is covered, a popular test which is used for testing for significance between two or more groups. While often used when there are three or more groups, it is completely fine to use when there are only two groups as well.

The ANOVA.xlsx Excel file used in this video is attached. There are 3 sheet tabs in the Excel File: Data (the numbers), Results (the ANOVA table), and Notes (all of the written notes used in the video). The sheet tabs are located at the bottom left-hand corner of the Excel spreadsheet.
Post-Hoc Tests14:51
In this video, post-hoc tests are conducted. Post-hoc (after the fact) tests are conducting following a significant one-way ANOVA in order to determine which groups are significant different from each other (and which, if any, are not significantly different).

The ANOVA post hoc.xlsx Excel file used in this video is attached. There are 5 sheet tabs in the Excel File: Data (the numbers), Results 1 - 3 (the post hoc results, each in a different sheet tab), and Notes (all of the written notes used in the video). The sheet tabs are located at the bottom left-hand corner of the Excel spreadsheet.
ANOVA and post hoc tests

Correlation (Part 1)2:13
In this video, the correlation coefficient – one of the most popular statistical procedures - is covered.
The Correlation.xlsx Excel file used in this video is attached. There are 2 sheet tabs in the Excel File: Data (the numbers), Results (the Excel output and notes from the video included). The sheet tabs are located at the bottom left-hand corner of the Excel spreadsheet.
Correlation (Part 2)5:15
This video covers part 2 of conducting and interpreting the correlation coefficient in Excel.
Please see part 1 for the data file and output for correlation.
Correlation with Three or More Variables4:28
This video builds on the previous videos on correlation by illustrating how to analyze and interpret correlations of more than two variables at once in Excel
Multiple Regression (Part 1)6:41
This video covers part 1 of multiple regression, a very commonly used procedure in many different fields.
The multiple regression.xlsx Excel file used in this video is attached. There are 2 sheet tabs in the Excel File: Data (the numbers), Results (the Excel output and notes from the video included). The sheet tabs are located at the bottom left-hand corner of the Excel spreadsheet.
The excel file covers both parts 1 and 2 of multiple regression in this course (one file for both videos).
Multiple Regression (Part 2)9:36
In this video, part 2 of multiple regression is covered.
Correlation and Regression

Conclusion and other Courses by Quantitative Specialists2:08
In this video, a conclusion to the course is provided. Thanks to everyone for enrolling in the course - I sincerely hope you enjoyed it!
If you haven't already, please take a few moments to post a review - I would greatly appreciate it. Thanks!

Our Introduction to Statistics course can be found here:

https://www.udemy.com/introduction-to-statistics/

Also, we have a number of other courses in statistical analysis, including Factorial ANOVA, Survey Data and Likert Scales, MANOVA, Inferential Statistics, and Descriptive Statistics. These courses illustrate statistical concepts using the SPSS software program. They can all be found on Udemy by using the search term: Quantitative Specialists

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

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

Excel Statistics / Data Analytics

What you'll learn

Explore related topics

Course content

Course Introduction, Installing the Analysis ToolPak, & Descriptive Statistics4 lectures • 22min

Inferential Statistics - Tests of Two Means2 lectures • 18min

Inferential Statistics - ANOVA (Analysis of Variance)2 lectures • 25min

Inferential Statistics - Correlation and Regression5 lectures • 28min

Conclusion1 lecture • 2min

Requirements

Description

Who this course is for: