» » Lynda - Statistics with Excel Part Two 2016 TUTORiAL
Topic information
  • Views: 140
  • Author: Delcan
  • Date: 17-05-2017, 07:10
17-05-2017, 07:10

Lynda - Statistics with Excel Part Two 2016 TUTORiAL

Category: Tutorials

Lynda -  Statistics with Excel Part Two 2016 TUTORiAL
Lynda - Statistics with Excel Part Two 2016 TUTORiAL | 260 MB

Understanding statistics is more important than ever. Statistical analysis, in particular, is the basis for decision making in many fields, including business and academia. In this course, part two of a series, Professor Joseph Schmuller teaches you how to use statistics concepts and tools to perform analysis in Microsoft Excel.
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.

00 - Introduction
Need to know
Exercise files
01 - Excel Statistics Essentials
Use Excel statistical functions
Use the Analysis Toolpak
Use statistical charts
Use 3D maps
02 - Visualize Sampling Distributions
Simulate the central limit theorem
Visualize the standard normal and t
Visualize F and chi square
03 - ANOVA: A Closer Look
Analyze between groups ANOVA
Perform simple comparisons
Perform complex comparisons
Perform unplanned comparisons
Perform repeated measures ANOVA
04 - ANOVA: A Complex Look
Perform two-way analysis of variance
Perform comparisons after two-way ANOVA
05 - Linear Regression: A Closer Look
Visualize scatter plot and regression line
Analyze the regression line
06 - Multiple Regression
Perform multiple regression
07 - Nonlinear Regression
Define natural logs and exponentials
Perform exponential regression analysis
Perform logarithmic regression analysis
Perform power regression analysis
Perform polynomial regression analysis
08 - Time Series
Forecast and make predictions
09 - Advanced Correlation
Perform correlation
Compare two correlation coefficients
Perform multiple correlation
Perform partial correlation
10 - Frequency Hypothesis Testing
Test independence of two variables
Test goodness of fit
11 - Simulation
Perform Monte Carlo simulation
Perform business simulations
12 - Conclusion
Next steps
Exercise Files



Tags Cloud: Lynda, Statistics, with, Excel, Part

Dear visitor, you are browsing our website as Guest.
We strongly recommend you to register and login to view hidden contents.