Lynda Excel Statistics Essential Training Part 2

Learn how to use statistics concepts and tools (including functions, 3D maps, and ANOVA) to perform data analysis in Microsoft Excel.

Included Exercise Files
Language : English
Released : August 11, 2016
Size : 220,56 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.

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.

Topics include:

Using Excel's statistical functions and 3D charts
Visualising sampling distributions
Performing comparisions with ANOVA
Performing two-way analysis with ANOVA
Analysing linear regression
Performing multiple regression and non-linear regression analysis
Forecasting
Making advanced correlations
Testing variable frequencies
Running simulations

https://www.filefactory.com/file/6q8hqs5wz38h/