Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Statistics for Data Analysis Using Excel 2016


Statistics Introduction and Definitions :
Introduction and Welcome
Statistics Defined

Basics of Statistics and Microsoft Excel :
Section Introduction - Basics of Statistics and Excel
Excel Interface (Excel)
Types of Data in Excel - Text, Numbers, Date/Time, Logical (Excel)
Qualitative vs Quantitative Data / Continuous vs Discrete (Theory)
Measurement Scales - Nominal, Ordinal, Interval & Ratio (Theory)
Basic Statistical Terms - Population and Sample (Theory)
Understanding Data Types in mtcars Dataset (Excel)
Understanding Formulas and Functions (Excel)
Applying Formula to Convert Car Weights from lb to kg (Excel)
Relative vs Absolute Reference (Excel)
Basic Formulas, Functions and Named Ranges (Excel)
More Functions (Excel)
Practice Activity - Basics of Statistics and Excel - Quiz 1
5 questions

Descriptive Statistics :
Section Introduction - Descriptive Statistics
Descriptive Statistics (Theory)
Descriptive Statistics - Central Tendency (Theory)
Descriptive Statistics - Variation (Theory)
Installing Data Analysis Pack and Calculating Descriptive Statistics (Excel)
Descriptive Statistics - Central Tendency (Excel)
Descriptive Statistics - Variation (Excel)
Descriptive Statistics - Shapes (Theory and Excel)
Arrays (Excel)
Practice Activity - Descriptive Statistics - Quiz 2
7 questions

Data Visualization :
Section Introduction - Three commonly used Charts
Histogram (Theory)
Create Histogram (Excel)
Histogram Shapes (Theory)
Box and Whisker Chart (Theory)
Create Box and Whisker Plot (Excel)
Scatter Diagram (Theory)
Create Scatter Plot using Excel
Practice Activity - Data Visualization - Quiz 3
5 questions

Basic Probability Concepts :
Section Introduction - Basics Probability Concepts
Basic Probability Concepts - Part 1 (Theory)
Basic Probability Concepts - Part 2 (Theory)
Basic Probability Concepts - Part 3 (Theory)
Basic Probability Concepts - Part 4 (Theory)
Calculate Factorial, Permutations and Combinations (Excel)
Practice Activity - Basic Probability Concepts - Quiz 4
4 questions

Probability Distributions :
Section Introduction - Probability Distributions
Central Limit Theorem (Theory)
Central Limit Theorem Demonstration (Excel)
Normal Probability Distribution (Theory)
Normal Probability Distribution (Excel)
Binomial Probability Distribution (Theory)
Binomial Probability Distribution (Excel) - 1
Binomial Probability Distribution (Excel) - 2
Other Distributions Related to Binomial Distribution (Theory)
Other Distributions Related to Binomial Distribution (Excel)
Poisson Distribution (Theory)
Poisson Distribution (Excel)
Practice Activity - Probability Distributions - Quiz 5
6 questions

Hypothesis Testing :
Section Introduction - Hypothesis Testing
Hypothesis Testing - Types of Errors
Hypothesis Testing Explained
Tests for Mean, Variance and Proportions - Introduction
One Sample z Test (Theory)
One Sample z Test - Introduction (Excel)
One Sample z Test - Two Tail Example (Excel)
One Sample z Test - One Tail Example (Excel)
Understanding the p Value (Theory)
One Sample t Test (Theory)
One Sample t Test - Introduction to T Functions (Excel)
One Sample t Test - Example (Excel)
One Sample p Test (Theory)
One Sample p Test (Excel)
Two Sample z Test (Theory)
Two Sample z Test (Excel)
Two Sample t Test (Theory)
Two Sample t Test - Equal Variance (Theory)
Two Sample t Test - Equal Variance (Excel)
Two Sample t Test - Unequal Variance (Theory)
Two Sample t Test - Unequal Variance (Excel)
Two Sample t Test - Paired t Test (Theory)
Two Sample t Test - Paired t Test (Excel)
Two Sample p Test - Introduction (Theory)
Two Sample p Test - Example (Excel)
Tests for Variance (F and Chi Square) - Introduction
F Test to Compare Variances
Plotting F Distribution in Excel
F Distribution Related Functions in Excel
F.TEST Function in Excel
F Test Using Data Aanalysis Pack
Chi Square Test for Variance
Plotting Chi Square Distribution in Excel
Chi Square Distribution Related Functions in Excel
Chi Square Test Example using Excel
Practice Activity - Hypothesis Testing - Quiz 6
6 questions

ANOVA - Analysis of Variance :
Section Introduction - ANOVA
Why do you need ANOVA?
Understanding the concept behind ANOVA without doing any calculation.
Formulas and calculations in ANOVA
Performing ANOVA with manual calculations
Performing ANOVA using Microsoft Excel
Two Factor ANOVA without Replication (Excel)
Two Factor ANOVA with Replication (Excel)
Practice Activity - ANOVA - Quiz 7
2 questions

Goodness of Fit and Contingency Table :
Section Introduction - Goodness of Fit and Contingency Tables
Goodness of Fit Test (Theory)
Goodness of Fit Test (Excel))
Contingency Table (Theory)
Contingency Table (Excel)

Correlation and Linear Regression :
Section Introduction - Correlation and Regression
Introduction to Correlation
Correlation Coefficient - Manual Calculation
Plotting Scatter Plot and Calculating Correlation Coefficient (Excel)
Correlation Coefficient for Mutliple Variables (Excel)
Correlation Related Functions (Excel)
Correlation Coefficient - Summary
Correlation vs Causation
Coefficient of Determination
Regression Equation - Manual Calculation
Regression Related Functions - Slope, Intercept (Excel)
Regression Related Functions - Forecast.Linear (Excel)
Regression Related Functions - Trend (Excel)
Regression Related Functions - Linest (Excel)
Regression using Data Analysis Pack (Excel)

Conclusion :
Download Slides