Excel 2013: Analysis Techniques and Random Numbers

Analysis Techniques using What-If, Solver, graphing, functions and statistical features in Excel.
Course info
Rating
(17)
Level
Intermediate
Updated
Feb 3, 2016
Duration
7h 26m
Table of contents
Add-ins for Excel 2013
What-if Analysis, Goal Seek, Scenarios, and Solver
Random Number Generator
Descriptive Statistics
Graphing Data
Z-tests
T-tests
Variance Tests Chi-square Test and F-test
ANOVA: Analysis of Variance
Regression
Description
Course info
Rating
(17)
Level
Intermediate
Updated
Feb 3, 2016
Duration
7h 26m
Description

This lesson covers multiple analysis techniques. The What-If and Solver features are first described and them illustrated using examples. Multiple statistical analysis methods are described using Excel functions and data analysis features, including interpretation of Excel output. Formulas are given and differences between Excel and statistical text are explained.

About the author
About the author

Brian is an energetic trainer and consultant with nearly 20 years of technical experience in datacenter management and design. As a virtualization instructor, Brian spends much of his time discussing the impact and intricacies of Software Defined Data Centers (SDDC), Software Defined Networking (SDN), and Software Defined Storage (SDS).

More from the author
More courses by Brian Eiler