Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Excel 2013: Analysis Techniques and Random Numbers

via Pluralsight

Overview

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

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.

Syllabus

  • Add-ins for Excel 2013 8mins
  • What-if Analysis, Goal Seek, Scenarios, and Solver 52mins
  • Random Number Generator 37mins
  • Descriptive Statistics 32mins
  • Graphing Data 40mins
  • Z-tests 43mins
  • T-tests 55mins
  • Variance Tests Chi-square Test and F-test 77mins
  • ANOVA: Analysis of Variance 56mins
  • Regression 42mins

Taught by

Brian Eiler

Reviews

4.3 rating at Pluralsight based on 20 ratings

Start your review of Excel 2013: Analysis Techniques and Random Numbers

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.