2016
Pluralsight
Brian Eiler
7:25
English
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.
Add-ins for Excel 2013
8m 28s
Managing Excel Add-ins 8m 28s
What-if Analysis, Goal Seek, Scenarios, and Solver
52m 1s
Goal Seek Simple Formula 4m 51s
Goal Seek Simple Formula in Excel 3m 4s
Goal Seek Payment Example 3m 18s
Goal Seek Payment Example in Excel 4m 18s
Scenarios 4m 53s
Scenarios Example in Excel 11m 25s
Solver Set-up Working with an Example 9m 41s
Solver Example in Excel with and Without Applying Constraints 9m 41s
Summary 0m 46s
Random Number Generator
37m 9s
Introduction and Definitions 7m 8s
The RAND Function 7m 4s
The RANDBETWEEN Function 3m 48s
Input Arguments for the Random Number Generation Tool 6m 20s
Random Number Generation Tool Demonstration 4m 20s
Distributional Choices 6m 17s
Summary 2m 8s
Descriptive Statistics
32m 32s
Descriptive Statistics 8m 51s
Descriptive Statistics Functions and Their Excel Arguments 4m 51s
Using Descriptive Statistics Functions in Excel 9m 18s
Descriptive Statistics and the Data Analysis Feature 2m 30s
Calculating Descriptive Statistics Using Data Analysis Feature 5m 53s
Summary 1m 7s
Graphing Data
40m 3s
Graphing Data / Scatter Plots 6m 35s
Creating a Scatter Plot in Excel 5m 6s
Histograms 3m 46s
Creating a Histogram in Excel 5m 22s
BoxPlots 6m 34s
Create a BoxPlot in Excel 11m 58s
Summary 0m 38s
Z-tests
43m 27s
Z-tests 3m 46s
STEP ONE Hypotheses Statements 2m 33s
STEP TWO Critical Value 3m 14s
STEP THREE Determine Test Statistic 2m 33s
STEP FOUR Calculate Test Statistic and Obtain P-value 5m 44s
STEP FIVE Draw Conclusions 1m 29s
Z-test Example 3m 57s
Z-test 5m 31s
Two Sample Z-test 7m 17s
Demo: Two Sample Z-test 6m 3s
Summary 1m 16s
T-tests
55m 33s
Introduction 6m 10s
T-tests 6m 55s
One Sample T-test 4m 43s
Example: One Sample T-test in Excel 5m 7s
Two Sample T-test 5m 26s
Example: Two Sample T-test 4m 8s
Paired T-test 4m 32s
Two Sample T-test in Excel 1m 24s
Example: Two Sample T-test in Excel 5m 24s
Example: Paired T-test in Excel 3m 38s
Two Sample T-Test 1m 46s
Example: Two Sample T-test Data Analysis in Excel 3m 6s
Example: Paired T-test Data Analysis in Excel Analysis 2m 25s
Summary 0m 43s
Variance Tests Chi-square Test and F-test
1h 17m
Variance Tests 4m 43s
Description of a Chi-square Test 5m 26s
Hypothesis Testing for a Chi-square Test 7m 50s
Chi-square Example 3m 24s
Calculating a Chi-square Test Statistic and Drawing Conclusions 2m 49s
Two-tailed Chi-square Test Demonstration in Excel 7m 13s
One-tailed Chi-square Test Demonstration in Excel 2m 48s
F-test Description and Hypothesis Testing 5m 42s
Hypothesis Testing for a Two-tailed F-test 9m 10s
Hypothesis Testing for a One-tailed F-test 2m 43s
F-test Using Excel Functions for a Two-tailed Test 4m 54s
F-test Using Excel Functions for a One-tailed Test 2m 42s
Excel F-test Analysis Features 2m 49s
F-Test Function Demonstration in Excel 3m 38s
F-test Analysis Feature 2m 47s
Using F-test Analysis Feature Demonstration in Excel 7m 15s
Summary 1m 8s
ANOVA: Analysis of Variance
56m 37s
Description of ANOVA 3m 25s
Hypothesis Testing with ANOVA 7m 49s
Single Factor ANOVA Example 6m 0s
Single Factor ANOVA on Excel 5m 14s
ANOVA: Two-factor without Replication Example 5m 50s
Two-factor ANOVA Without Replication in Excel 5m 45s
ANOVA: Two-factor with Replication Example 9m 14s
ANOVA: Two-factor with Replication in Excel 5m 10s
Creating Graphs and Numerical Summaries for Two-factor ANOVAs 7m 27s
Summary of ANOVA Lesson 0m 41s
Regression
42m 42s
Structure and Calculation of a Regression Analysis 9m 24s
Regression Assumptions 4m 40s
Fuel Consumption Example Calculations 8m 16s
Drawing Conclusions and Checking Assumptions 6m 37s
Set-up and Calculation of Regression Example in Excel 4m 0s
Drawing Conclusions, Assumption Checking, and Regression Equation 9m 0s
Summary of Regression Lesson 0m 43s
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).
pluralsight.com/courses/excel-2013-analysis-techniques
Download File Size:1017.86 MB
|
