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:
For each test, we will cover:
Enroll in this course and obtain important marketable data analytic skills today!
In this video, the course is introduced, including the topics covered and the goals and objectives of the course.
Important note: for those who want to run the analyses in Excel using the Data Analysis ToolPak, it is necessary that you have access to a PC (not a Mac). So if you are exclusively a Mac user, while you will learn how to understand and accurately interpret the results of some of the most popular statistical procedures using Excel, as well as how to express the results in a precise, accurate, and widely accepted format, you will not be able to run them on your own computer. Feel free to watch the next video, installing the Data Analysis ToolPak in Excel, if you would like to assess whether or not you have access Microsoft Excel the Data Analysis ToolPak on your computer.
This video illustrates how to install the Data Analysis ToolPak in Microsoft Excel. While available on PCs (not Macs), the ToolPak needs to be activated in Excel in order to be utilized. This video illustrates how to make it available in Excel.
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.
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.
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.
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).
This quiz covers concepts related to the independent and dependent samples t tests.
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.
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).
In this video, the correlation coefficient – one of the most popular statistical procedures - is covered.
This video covers part 2 of conducting and interpreting the correlation coefficient in Excel.
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
This video covers part 1 of multiple regression, a very commonly used procedure in many different fields.
In this video, part 2 of multiple regression is covered.
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:
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
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!