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

Level

Intermediate

Updated

Feb 3, 2016

Duration

7h 26m

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

Level

Intermediate

Updated

Feb 3, 2016

Duration

7h 26m

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

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

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

Feb 25, 2019

More courses by Brian Eiler

Ready to skill up
your entire team?

10

Licenses

Continue to checkout Continue to checkout

Cancel

With your Pluralsight plan, you can:

With your 14-day pilot, you can:

Access thousands of videos to develop critical skills
Give up to 10 users access to thousands of video courses
Practice and apply skills with interactive courses and projects
See skills, usage, and trend data for your teams
Prepare for certifications with industry-leading practice exams
Measure proficiency across skills and roles
Align learning to your goals with paths and channels