Description
In this course, you will :
- Demonstrates how to use Microsoft Excel's tools—statistical functions, 3D maps and charts, the Ideas tool, and the Analysis Toolpak add-on—to perform more sophisticated statistical analysis.
- Understand how to visualise sampling distributions. Then, using analysis of variance, test for differences (ANOVA).
- Learn how to use linear, multiple, and nonlinear regression to analyse and predict relationships between variables.
- demonstrates how to perform advanced correlations, test frequency hypotheses, and create and run simulations.
- After completing both courses, you should have the necessary foundational knowledge to ace your next exam or interview, as well as perform statistical analyses in the workplace.
Syllabus :
1. Excel Statistics Fundamentals
- Using Excel statistical functions
- Using the Analysis Toolpak
- Using statistical charts
- Using 3D maps
- Using the Ideas tool
2. Visualizing Sampling Distributions
- Simulating the central limit theorem
- Visualizing the standard normal and t
- Visualizing F and chi-square
3. ANOVA: A Closer Look
- Analyzing between groups ANOVA
- Performing simple comparisons
- Performing complex comparisons
- Performing repeated measures ANOVA
- Trend analysis
4. ANOVA: A Complex Look
- Performing two-way ANOVA
- Making comparisons after two-way ANOVA
5. Linear Regression: A Closer Look
- Visualizing scatter plot and regression line
- Analyzing the regression line
6. Multiple Regression
- Performing multiple regression
7. Nonlinear Regression
- Defining natural logs and exponents
- Performing exponential regression analysis
- Performing logarithmic regression analysis
- Performing a power regression analysis
- Performing polynomial regression analysis
- Performing logistic regression
8. Time Series
- Forecasting and predicting
9. Advanced Correlation
- Performing correlation
- Comparing two correlation coefficients
- Performing multiple correlations
- Performing a partial correlation
10. Frequency Hypothesis Testing
- Testing the independence of two variables
- Testing goodness of fit
11. Simulation
- Performing Monte Carlo simulation
- Performing business simulations