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
- 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 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
- 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
- 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
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
