Excel 2013: Analysis Techniques and Random Numbers
Offered By: Pluralsight
Course Description
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.
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
Related Courses
Business Analytics for Decision MakingUniversity of Colorado Boulder via Coursera Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX Практики управленческой аналитики в MS Excel
Saint Petersburg State University via Coursera Everyday Excel, Part 2
University of Colorado Boulder via Coursera Business Intelligence Workflow with Excel
Pluralsight