Excel 2013: Analysis Techniques and Random Numbers

By Brian Eiler
Analysis Techniques using What-If, Solver, graphing, functions and statistical features in Excel.
Course info
Rating
(19)
Level
Intermediate
Updated
Feb 3, 2016
Duration
7h 25m
Table of contents
Add-ins for Excel 2013
Managing Excel Add-ins 8m
What-if Analysis, Goal Seek, Scenarios, and Solver
Goal Seek Simple Formula 5m Goal Seek Simple Formula in Excel 3m Goal Seek Payment Example 3m Goal Seek Payment Example in Excel 4m Scenarios 5m Scenarios Example in Excel 11m Solver Set-up Working with an Example 10m Solver Example in Excel with and Without Applying Constraints 10m Summary 1m
Random Number Generator
Introduction and Definitions 7m The RAND Function 7m The RANDBETWEEN Function 4m Input Arguments for the Random Number Generation Tool 6m Random Number Generation Tool Demonstration 4m Distributional Choices 6m Summary 2m
Descriptive Statistics
Descriptive Statistics 9m Descriptive Statistics Functions and Their Excel Arguments 5m Using Descriptive Statistics Functions in Excel 9m Descriptive Statistics and the Data Analysis Feature 3m Calculating Descriptive Statistics Using Data Analysis Feature 6m Summary 1m
Graphing Data
Graphing Data / Scatter Plots 7m Creating a Scatter Plot in Excel 5m Histograms 4m Creating a Histogram in Excel 5m BoxPlots 7m Create a BoxPlot in Excel 12m Summary 1m
Z-tests
Z-tests 4m STEP ONE Hypotheses Statements 3m STEP TWO Critical Value 3m STEP THREE Determine Test Statistic 3m STEP FOUR Calculate Test Statistic and Obtain P-value 6m STEP FIVE Draw Conclusions 1m Z-test Example 4m Z-test 6m Two Sample Z-test 7m Demo: Two Sample Z-test 6m Summary 1m
T-tests
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
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
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
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
Description
Course info
Rating
(19)
Level
Intermediate
Updated
Feb 3, 2016
Duration
7h 25m
Description

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.

About the author
Brian Eiler
About the author

Brian is an energetic trainer and consultant with nearly 20 years of technical experience in datacenter management and design. As a virtualization instructor, Brian spends much of his time discussing the impact and intricacies of Software Defined Data Centers (SDDC), Software Defined Networking (SDN), and Software Defined Storage (SDS).

More from the author
Identity and Access Management on AWS: Policies and Permissions
Intermediate
2h 21m
Feb 26, 2019
Identity and Access Management on AWS: Designing and Implementing an AWS Organization
Intermediate
2h 24m
Feb 26, 2019
Identity and Access Management on AWS: Roles and Groups
Intermediate
2h 29m
Feb 25, 2019
More courses by Brian Eiler

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT