Course
Skills Expanded
Excel 2013: Analysis Techniques and Random Numbers
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
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
- Introduction 6m
- T-tests 7m
- One Sample T-test 5m
- Example: One Sample T-test in Excel 5m
- Two Sample T-test 5m
- Example: Two Sample T-test 4m
- Paired T-test 5m
- Two Sample T-test in Excel 1m
- Example: Two Sample T-test in Excel 5m
- Example: Paired T-test in Excel 4m
- Two Sample T-Test 2m
- Example: Two Sample T-test Data Analysis in Excel 3m
- Example: Paired T-test Data Analysis in Excel Analysis 2m
- Summary 1m
Variance Tests Chi-square Test and F-test
77mins
- Variance Tests 5m
- Description of a Chi-square Test 5m
- Hypothesis Testing for a Chi-square Test 8m
- Chi-square Example 3m
- Calculating a Chi-square Test Statistic and Drawing Conclusions 3m
- Two-tailed Chi-square Test Demonstration in Excel 7m
- One-tailed Chi-square Test Demonstration in Excel 3m
- F-test Description and Hypothesis Testing 6m
- Hypothesis Testing for a Two-tailed F-test 9m
- Hypothesis Testing for a One-tailed F-test 3m
- F-test Using Excel Functions for a Two-tailed Test 5m
- F-test Using Excel Functions for a One-tailed Test 3m
- Excel F-test Analysis Features 3m
- F-Test Function Demonstration in Excel 4m
- F-test Analysis Feature 3m
- Using F-test Analysis Feature Demonstration in Excel 7m
- Summary 1m
ANOVA: Analysis of Variance
56mins
- Description of ANOVA 3m
- Hypothesis Testing with ANOVA 8m
- Single Factor ANOVA Example 6m
- Single Factor ANOVA on Excel 5m
- ANOVA: Two-factor without Replication Example 6m
- Two-factor ANOVA Without Replication in Excel 6m
- ANOVA: Two-factor with Replication Example 9m
- ANOVA: Two-factor with Replication in Excel 5m
- Creating Graphs and Numerical Summaries for Two-factor ANOVAs 7m
- Summary of ANOVA Lesson 1m
Regression
42mins
- Structure and Calculation of a Regression Analysis 9m
- Regression Assumptions 5m
- Fuel Consumption Example Calculations 8m
- Drawing Conclusions and Checking Assumptions 7m
- Set-up and Calculation of Regression Example in Excel 4m
- Drawing Conclusions, Assumption Checking, and Regression Equation 9m
- Summary of Regression Lesson 1m