Analysis of Variance (ANOVA) is the tool you use to test hypotheses about multiple samples. Joe uses the Excel Analysis Tool Pak to perform a Between-Groups Analysis of Variance -- the appropriate technique for independent samples. He then shows you how to use Excel's built-in statistical functions to understand the results. You'll then have an in-depth understanding of this important technique.
- [Voiceover] I'm going to discuss the between groups…analysis of variance, also known as between groups ANOVA.…We use this type of ANOVA to find out if the meanings…of two or more independent samples of scores…are different from one another,…and this is a feature of research in many fields.…Here's an important example.…Are four kinds of protective sports helmets…different in how well they protect you…against the concussion?…To answer this question, researchers subjected…four different lacrosse helmets to impact testing.…They dropped each helmet 10 times from a height…of 152 centimeters so that each helmet…received impact on the front.…
They measured GSI, an index of how well the helmet…withstood the impact.…Without going into all the details about how to measure GSI…I'll just tell you that a higher number…means less protection.…So this is a test of null hypothesis that the means…for all the helmets are equal…versus the alternative hypothesis that they're not.…A, B, C, and D are the four helmets.…Here's a spreadsheet with relevant data.…
Author
Released
8/11/2016He explains how to organize and present data and how to draw conclusions using Excel's functions, charts, and 3D maps and the Solver and Analysis ToolPak add-ons. Learn to calculate mean, variance, standard deviation, and correlation; visualize sampling distributions; and test differences with analysis of variance (ANOVA). Then find out how to use linear, multiple, and nonlinear regression testing to analyze relationships between variables and make predictions. Joseph also shows how to perform advanced correlations, variable frequency testing, and simulations.
By the end of this course, you should have the foundational knowledge you need to take other statistics-related courses and perform basic analysis in the workplace.
- Using Excel's statistical functions and 3D charts
- Visualizing sampling distributions
- Performing comparisons with ANOVA
- Performing two-way analysis with ANOVA
- Analyzing linear regression
- Performing multiple regression and nonlinear regression analysis
- Forecasting
- Making advanced correlations
- Testing variable frequencies
- Running simulations
Skill Level Beginner
Duration
Views
Related Courses
-
Excel Statistics Essential Training: 1
with Joseph Schmuller3h 45m Appropriate for all -
Statistics Foundations: 1
with Eddie Davila2h 6m Beginner -
Data Visualization: Storytelling
with Bill Shander1h 37m Intermediate -
Solving Optimization and Scheduling Problems in Excel
with Curt Frye2h 18m Intermediate
-
Introduction
-
Welcome1m 1s
-
Need to know1m 28s
-
Exercise files53s
-
-
1. Excel Statistics Essentials
-
Use the Analysis Toolpak2m 43s
-
Use statistical charts4m 37s
-
Use 3D maps4m 32s
-
2. Visualize Sampling Distributions
-
Visualize F and chi square3m 10s
-
3. ANOVA: A Closer Look
-
Analyze between groups ANOVA2m 20s
-
Perform simple comparisons4m 10s
-
Perform complex comparisons4m 10s
-
-
4. ANOVA: A Complex Look
-
5. Linear Regression: A Closer Look
-
6. Multiple Regression
-
Perform multiple regression4m 12s
-
-
7. Nonlinear Regression
-
8. Time Series
-
9. Advanced Correlation
-
Perform correlation4m 1s
-
Perform multiple correlation3m 41s
-
Perform partial correlation3m 43s
-
-
10. Frequency Hypothesis Testing
-
Test goodness of fit3m 22s
-
11. Simulation
-
Perform business simulations4m 50s
-
Conclusion
-
Next steps28s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Analyze between groups ANOVA