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
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX