After a significant ANOVA, the data might suggest intersample comparisons that you didn't plan in advance. Statisticians have created a variety of techniques for carrying out these kinds of comparisons, which often depend on special formulas and tables. By contrast, Joe shows you a way of performing unplanned comparisons that you can easily implement in Excel. Significant unplanned comparisons are important because they typically point the way toward further research.
- View Offline
- [Voiceover] Now I'm gonna put the final touch…on what to do after you do an anova.…An anova, remember, just lets you know…whether or not you have a significant difference…somewhere in a set of sample means.…But you have to know exactly where that difference is.…Sometimes, you stumble on a difference…that you didn't plan for.…I'll show you what to do when that happens.…Now when you plan a study with multiple samples…like, say, four samples called A, B, C, and D,…you typically plan some comparisons in advance.…But life would be boring if the only comparisons…you could make are the ones you planned.…
You can perform an unplanned comparison,…but you pay a price for not planning.…You have to set a higher hurdle for significance…for this type of test.…A higher hurdle means loss of power,…the ability to reject a null hypothesis…because you didn't know enough in advance,…yet another example of knowledge is power.…These kinds of comparisons are also called post-hoc tests.…Many statisticians have have worked in this area,…
He 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
- Making advanced correlations
- Testing variable frequencies
- Running simulations