Author
Joseph Schmuller
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.
- Identify the type of function that returns more than one value.
- Identify the type of function that returns values for the standard normal distribution.
- Name the different amounts of a factor in the analysis of varianc e.
- Explain how to use the Tool Pak Regression tool for exponential regression.
- Define negative correlation.
- Recall the term used to describe a simulation that includes randomness.
Skill Level Beginner
Duration
Views
- [Voiceover] I'm Joseph Schmuller, and welcome to Statistics with Excel Part Two. In this course, you'll learn how to use Excel's statistical tools and techniques to perform statistical analyses. I'll start by showing you how to use Excel's statistical functions to calculate statistics like mean, variance, standard deviation, and correlation. And I'll show you some exciting statistics-related features that are new in Excel 2016, like 3D maps for dramatic presentations, and one-click forecasting for making predictions from historical data. I'll show you how to use Excel's Analysis ToolPak to perform analysis of variance to compare and contrast multiple groups.
You'll also learn how to perform linear, multiple, and non-linear regression to analyze relationships among variables and make predictions. My objective is that you have a firm understanding of statistical concepts and how to implement them in Excel. This will help you in statistics-related courses in school or in a job that requires a background in analytics. Now, let's get started with Statistics with Excel Part Two.
-
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
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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: Welcome