Expanded Library

Excel 2013: Analysis Techniques and Random Numbers

by Brian Eiler

Analysis Techniques using What-If, Solver, graphing, functions and statistical features in Excel.

What you'll learn

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.

Table of contents

Add-ins for Excel 2013
8mins

About the author

Brian's technical background includes almost 20 years of implementing, teaching, and writing about products from VMware, Microsoft, Citrix, IBM, HP, EMC, Dell, and Cisco. In addition to his other certifications, he holds VMware's advanced instructor credential (VCI-Level 2) and two of their most advanced design and implementation credentials: VCAP-DCD and VCAP-DCA. Brian has recently begun taking his classroom and field experience to the masses by authoring a number of publications, training cou... more

Ready to upskill? Get started