NAVIGATION ☰
Home Page
Find Data by Source ►
Topical Collections
By Author
Journal Archives
Ask Facebook Group
Find Data by Subfield ►
African Politics
American Politics
Comparative Politics
European Politics
International Relations
Law Courts & Justice
Public Opinion Surveys
Voting & Elections
Ask Facebook Group
Teach Data Analysis ►
Teaching Resources
Teaching Assistant
Live R Demos
Sample Syllabi
Excel Tutorials ►
1: Excel for Data Analysis
2: Descriptive Statistics
3: Transforming Variables
4: Making Comparisons
5: Graphing Relationships
6: Random Assignment & Sampling
7: Controlled Comparisons
8: Sampling Distributions
9: Hypothesis Tests with One or Two Samples
10: ChiSquare & ANOVA
11: Correlation & Bivariate Regression
12: Multiple Regression
13: Regression Residuals
14: Logistic Regression
15: Doing Your Own Analysis
R Demos & Resourcs
Analyze Data ►
Grade Level of Text
Surname Census Info
Calculate Federal Judge Ideal Points
Crosstabs with Circuit Court Data
Election Simulation
Share Findings ►
Political Science Blogs
Political Science Journals
Political Science Podcasts
Political Theory Journals
Public Administration Journals
Public Policy Journals
Legal Research
It's Better with Music
About ►
This Web Site
Barry C. Edwards
Political Analysis with Microsoft Excel: Tips & Tutorials
Suggest a Link
Alphabetize Page
PrinterFriendly List
Find data. Produce results. Tell the world.
Watch and Learn
Watch and Learn
Watch and Learn
Watch and Learn
How to Create Simple Random Sample and Systematic Sample
From Farhad Zulfiqar (5:18)
Excel Tutorials

Chapter 6
How to Perform a TwoWay ANOVA without Replication
From Stephanie Glen (3:08)
Excel Tutorials

Chapter 10
Creating a Boxplot
Tutorial from Todd Grande (12:03).
Excel Tutorials

Chapter 5
How to Conduct Analysis of Variance (ANOVA) and Graph Results
From Amy Dykstra (9:01)
Excel Tutorials

Chapter 10
How to Group, Ungroup, and Remove PivotTable Rows
Useful for making comparisons with intervallevel independent variable (3:23).
Excel Tutorials

Chapter 4
How to Make a Line Graph
Show you how to create and edit a line chart (6:07).
Excel Tutorials

Chapter 5
Creating a Scatter Plot
Shows you how to make a basic scatterplot and edit it for clarity (4:38).
Excel Tutorials

Chapter 5
Using Count, Average and Sum in Pivot Tables
Useful for creating mean comparison tables (8:16).
Excel Tutorials

Chapter 4
Basic Data Entry & Management
Shows you how to enter and organize data on worksheet (6:13).
Excel Tutorials

Chapter 1
How to Calculate PValue for an FStatistic
Uses Excel F.DIST function (2:26)
Excel Tutorials

Chapter 10
Top 10 Basic Functions & Formulas
Helpful demonstration (16:02).
Excel Tutorials

Chapter 1
OneWay ANOVA with the Data Analysis ToolPak
Nice illustration of underlying data, from Jeffrey Knutsen (4:19)
Excel Tutorials

Chapter 10
How To Calculate Confidence Intervals
Uses Data Analysis ToolPak (4:48)
Excel Tutorials

Chapter 8
Calculating the 95% Confidence Interval after a TTest
From Todd Grande (6:57)
Excel Tutorials

Chapter 9
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials

Chapter 3
Making a Simple Bar Graph
Scott Stevens creates the graph from scratch (5:13)
Excel Tutorials

Chapter 2
Understanding Sample and Population Standard Deviations
Todd Grande Compares Excel's STDEV.S and STDEV.P functions (7:46)
Excel Tutorials

Chapter 8
Multiple Regression Analysis with Data Analysis ToolPak
Tobin Porterfield provides example with movie data (4:56)
Excel Tutorials

Chapter 12
How to Make a Map Chart
Demonstrates using Florida zip codes (4:33).
Excel Tutorials

Chapter 2
Using SUM, COUNT and AVERAGE in PivotTables
Skills needed to make create mean comparison tables (9:51).
Excel Tutorials

Chapter 4
Adding Slicers to PivotTable
Demonstrated with business data (14:01).
Excel Tutorials

Chapter 7
How to Create 100% Stacked Column Chart
Chart option for qualitative dependent variable (4:58).
Excel Tutorials

Chapter 5
How to Generate Discrete Random Numbers
Using the Data Analysis Toolpak (5:48)
Excel Tutorials

Chapter 6
How to Use NORM.DIST and NORM.INV Functions in Excel
From Learn Something (6:12)
Excel Tutorials

Chapter 8
Building a Correlation Matrix with Data Analysis ToolPak
Demo features car data (9:09)
Excel Tutorials

Chapter 11
TukeyKramer Post Hoc Test after OneWay ANOVA
From Todd Grande (15:35)
Excel Tutorials

Chapter 10
Advanced Filter Options Using Criteria Ranges
Leila Gharani shows how to create interactive filters on worksheets (7:23)
Excel Tutorials

Chapter 3
How to Create a Boxplot
Comparing numeric values across multiple categories (2:02).
Excel Tutorials

Chapter 5
How to Make and Interpret a Scatterplot
From Matt Macarty (7:08).
Excel Tutorials

Chapter 5
Excel PivotTables Made Easy
Demonstrates PivotTables with sales data (DV) and addresses common problems (13:17).
Excel Tutorials

Chapter 4
How to Perform a ChiSquare Test for Independence
Includes making table of expected values, from Eugene O'Loughlin (8:42).
Excel Tutorials

Chapter 10
Charts & Graphs to Visualize Quantitative Data
Shows how and when to create different types of charts (34:32).
Excel Tutorials

Chapter 5
Independent Samples TTest from Only Sample Size, Mean, and Standard Deviation
Todd Grande shows how to conduct ttest from descriptive statistics (7:38)
Excel Tutorials

Chapter 9
Analyzing Residuals from Multiple Regression
Cindy Roberts demonstrates with movie revenue example (5:59).
Excel Tutorials

Chapter 13
Conducting a Multiple Regression using Data Analysis Tools
Todd Grande demonstrates with example (10:14).
Excel Tutorials

Chapter 12
Using Dummy Variable in Multiple Regression Analysis
Stephen Peplow demonstrates with example, uses results to make informed predictions (7:23).
Excel Tutorials

Chapter 12
Excel Printing Problems, Solved
Leila Gharani shares tips and suggestions for efficient printing (10:50).
Excel Tutorials

Chapter 1
How to Make CrossTabulation
Uses PivotTable to make crosstable with car data (12:02).
Excel Tutorials

Chapter 4
OneWay ANOVA (Single Factor) with Data Analysis Tools
From Todd Grande (12:02)
Excel Tutorials

Chapter 10
Creating Area Charts to Visualize Data
Shows how and when to create area charts (4:41).
Excel Tutorials

Chapter 5
Binary Logistic Regression
Uses Real Statistics AddIn to analyze business example (4:48).
Excel Tutorials

Chapter 14
ROC Curves and AUC Explained
How to visualize the performance of a binary classifier, useful with logistic regression (14:05).
Excel Tutorials

Chapter 14
Regression with Multiple Dummy Variables and Interaction Terms
Alym Amlani demonstrates with simple business example (8:11)
Excel Tutorials

Chapter 12
How to Create Multiple Line Chart
Plotting two or more lines that have the same xvalues (7:27).
Excel Tutorials

Chapter 5
Logistic Regression Using Excel
Analyzes who survived Titanic disaster using Real Statistics AddIn Logistic Regression Tool (7:54).
Excel Tutorials

Chapter 14
SidebySide Boxplot Tutorial
For Excel 2016 and later versions (3:08).
Excel Tutorials

Chapter 5
How to Generate Normally Distributed Random Numbers
Using Data Analysis Toolpak (5:53)
Excel Tutorials

Chapter 8
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
Excel Tutorials

Chapter 3
Paired Samples tTest in Excel
From Matt Macarty (9:45)
Excel Tutorials

Chapter 9
Assessing Normality of the Residuals using a Histogram
Based on standardized residuals from SAT scores example (5:38).
Excel Tutorials

Chapter 13
Make a Histogram Using Data Analysis ToolPak's Histogram Tool
By Vickie Dominguez (5:40)
Excel Tutorials

Chapter 2
Pivot Table Fields Pane Options
Good overview of Pivot Table options (4:21).
Excel Tutorials

Chapter 7
How to Install Real Statistics AddIn
Expands the statistical capabilities of Excel (11:50).
Excel Tutorials

Chapter 1
How to Generate Uniformly Distributed Random Numbers
Using the Data Analysis Toolpak (6:08)
Excel Tutorials

Chapter 8
Pivot Table Tutorial
By Kevin Stratvert (13:35)
Excel Tutorials

Chapter 2
How to do a Two Sample (Independent) tTest in Excel
From David Dunaetz (8:45)
Excel Tutorials

Chapter 9
JarqueBera Test of Normality
Todd Grande covers with example (7:23).
Excel Tutorials

Chapter 13
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials

Chapter 3
How to Create Confidence Intervals for Difference of Proportions
David Houston works through political examples (20:43).
Excel Tutorials

Chapter 9
Sorting and Filtering Data
Starting from blank worksheet, from Organic Chemistry Tutor (13:28)
Excel Tutorials

Chapter 2
Creating Correlation Table Using Data Analysis Tools
Example based on Boston housing data, shows how to colorcode results (9:39).
Excel Tutorials

Chapter 11
Importing Data from a Website to Spreadsheet
Lucy Provost demonstrates Excel 2016 web queries (6:38)
Excel Tutorials

Chapter 15
How to Test for Equal and Unequal Variance (F Test)
Eugene O'Loughlin shows how to use an F test to decide whether to assume equal variances (7:22)
Excel Tutorials

Chapter 9
Excel Formulas and Functions Tutorial
From Kevin Stratvert (12:28)
Excel Tutorials

Chapter 1
Performing a tTest in Excel on Experimental Data
From James Clark (5:32)
Excel Tutorials

Chapter 9
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
Excel Tutorials

Chapter 3
How to Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials

Chapter 3
Confidence Interval Estimation Using Data Analysis Tool
Calculates CI for Sample Mean (7:29)
Excel Tutorials

Chapter 8
Map Chart Tutorial
With helpful tips on mapping at different levels (15:15).
Excel Tutorials

Chapter 4
Graphing Two Data Series on the Same Scatterplot
Plot two data sets on the same scatterplot for visual comparison (6:07).
Excel Tutorials

Chapter 12
Conducting a Multiple Regression using Data Analysis Tools
From Todd Grande (10:14).
Excel Tutorials

Chapter 12
Logistic Regression Analysis Using Optimization with Solver
Vikas Agrawal discusses concept of logistic regression and implements with Solver (16:26).
Excel Tutorials

Chapter 14
How to Create A Stratified Random Sample
From Tim D'Auria (5:25)
Excel Tutorials

Chapter 6
TTest in Excel
Evan Matthews explains how to conduct a ttest in Excel, and how to interpret the results (7:06)
Excel Tutorials

Chapter 9
Efficient Data Entry wih Excel Forms
Leila Gharani demonstrates (6:21).
Excel Tutorials

Chapter 6
Using Excel for Random Assignment
From Matthew Lavery (4:31)
Excel Tutorials

Chapter 6
Residual Analysis of Simple Regression
Nice analysis of business example (10:35).
Excel Tutorials

Chapter 13
Creating a Dummy Variable for Multiple Regression
Stephen Peplow demonstrates (7:23)
Excel Tutorials

Chapter 12
How to do Linear Regression with Data Analysis Toolpak
Matt Macarthy demonstrates bivariate regression with home sale data(10:40).
Excel Tutorials

Chapter 11
Random Number Generation with Multiple Distributions
Distributions reviewed include uniform, normal, Bernoulli, binomial, Poisson, patterned, and discrete (11:36).
Excel Tutorials

Chapter 6
Confidence Intervals (Using tDistribution)
From John Estes Math (5:36)
Excel Tutorials

Chapter 8
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials

Chapter 3
How to Use Descriptive Statistics Tool
Demonstrates with data on heights (2:37).
Excel Tutorials

Chapter 2
TwoWay ANOVA with Replication using Data Analysis Tools
From Todd Grande (12:42)
Excel Tutorials

Chapter 10
How to Copy and Paste Filtered Data using FILL Option
Useful for creating scatterplots for multiple regression analysis (2:02)
Excel Tutorials

Chapter 12
Cleaning Messy Data for Analysis
Andrew Lockwood shares a lot of great tips and suggestions (21:10).
Excel Tutorials

Chapter 15
Testing Difference of Two Proportions
Matt Vespa solves a sample problem (5:45).
Excel Tutorials

Chapter 9
Working with Different Chart Types
Demonstrated with book sales data (4:30).
Excel Tutorials

Chapter 5
Working with Chi Distribution Functions
From Mauricio Arango (4:12)
Excel Tutorials

Chapter 10
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials

Chapter 3
Choosing & Selecting Statistical Functions
Shows you how to access statistical functions and execute them (6:49).
Excel Tutorials

Chapter 1
OneWay ANOVA with PostHoc tTests
From James Clark (14:25)
Excel Tutorials

Chapter 10
Rank and Percentile Tools in Data Analysis ToolPak
How to use additional tools to describe data (1:57).
Excel Tutorials

Chapter 2
How to Create a Column Chart
Good emphasis on design principles (3:40)
Excel Tutorials

Chapter 2
How to Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials

Chapter 3
NORM.DIST and Related Functions
Todd Grande explains how to use these functions in Excel (9:52)
Excel Tutorials

Chapter 8
How To Make a Scatterplot with Slope, Y Intercept & R Value
Emphasizes Excel functions, another approach to regression analysis (13:23).
Excel Tutorials

Chapter 11
How to Insert Column in Worksheet
Fundamental skill for creating new variables in dataset (2:39)
Excel Tutorials

Chapter 3
How to Show % of Total in PivotTable
Helps create percentages column in frequency distribution table (4:30).
Excel Tutorials

Chapter 2
Cross Tabulation With Frequencies and Percentages
Shows how to calculate values and format PivotTable (15:12).
Excel Tutorials

Chapter 4
How to Use PivotTables to Summarize Data
Nice introduction and demonstration (17:39).
Excel Tutorials

Chapter 2
Learn Chart & Graph Basics for Quick Start
From Leila Gharani (14:09)
Excel Tutorials

Chapter 2
Sorting Worksheet Data
Demonstrates basics of sorting (4:30)
Excel Tutorials

Chapter 2
How to Use CHISQ.TEST and CHISQ.INV.RT Functions
Illustrates with a goodness of fit test (4:12)
Excel Tutorials

Chapter 10
Logistic Regression Using Solver
Demonstrates maximum likelihood estimation using Solver (5:52).
Excel Tutorials

Chapter 14
Multiple Regression with Data Analysis Regression Tool
Nice, generic example, good explanation of results (11:01).
Excel Tutorials

Chapter 12
Using Functions for FDistribution and FTest
Shows how to calculate pvalues for Fstatistics (4:12)
Excel Tutorials

Chapter 10
How to Conduct a ChiSquare Test
From Todd Grande (8:03).
Excel Tutorials

Chapter 10
Import Data from Web
Leila Gharani demonstrates wih oil price and weather examples (10:01).
Excel Tutorials

Chapter 15
How to Draw Simple and Systematic Random Samples
Demostrated with student population (7:37)
Excel Tutorials

Chapter 6
Excel Slicers, Inside Out
Mynda Treacy shows how to setup and use slicers (13:04).
Excel Tutorials

Chapter 7
Import Tab Delimited Text File
Shows how to work with common data format (3:35)
Excel Tutorials

Chapter 15
Bivariate Regression Using SLOPE and INTERCEPT Functions
David Houston demonstrates with global life expectancy data (13:17).
Excel Tutorials

Chapter 11
How to Install Real Statistics AddIn with Windows OS
Shows how to resolve some Windows 10 issues (3:04)
Excel Tutorials

Chapter 1
Assessing Normality of Residuals with Skewness, Kurtosis & JarqueBera Test
By Fam & Fami (7:48).
Excel Tutorials

Chapter 13
Calculating Means and Standard Deviations in PivotTable
Useful for creating mean comparison tables (7:34).
Excel Tutorials

Chapter 4
Import Text Files into Excel
Ajay Anand shows 5 different methods (13:07).
Excel Tutorials

Chapter 15
How To Import A Text File
Keith Aul shows how to import data from plain text file (9:14).
Excel Tutorials

Chapter 15
Excel Pivot Tables Explained
Leila Gharani uses PivotTables to summarize sales data by other variables, like sales by product (13:21).
Excel Tutorials

Chapter 4
Using PivotTable to Create Controlled Mean Comparison Table
Example shows repair time (DV) by technician, controlling for job type (4:01).
Excel Tutorials

Chapter 7
Descriptive Statistics with Excel's Data Analysis ToolPak
By Matt Macarty (4:24)
Excel Tutorials

Chapter 2
Residuals and Residual Plots
Daniel McCarron discusses and demonstrates regression diagnostics with residuals (13:50).
Excel Tutorials

Chapter 13
How to Create Simple Random Sample and Systematic Sample
From Farhad Zulfiqar (5:18)
Excel Tutorials

Chapter 6
How to Perform a TwoWay ANOVA without Replication
From Stephanie Glen (3:08)
Excel Tutorials

Chapter 10
Creating a Boxplot
Tutorial from Todd Grande (12:03).
Excel Tutorials

Chapter 5
How to Conduct Analysis of Variance (ANOVA) and Graph Results
From Amy Dykstra (9:01)
Excel Tutorials

Chapter 10
How to Group, Ungroup, and Remove PivotTable Rows
Useful for making comparisons with intervallevel independent variable (3:23).
Excel Tutorials

Chapter 4
How to Make a Line Graph
Show you how to create and edit a line chart (6:07).
Excel Tutorials

Chapter 5
Creating a Scatter Plot
Shows you how to make a basic scatterplot and edit it for clarity (4:38).
Excel Tutorials

Chapter 5
Using Count, Average and Sum in Pivot Tables
Useful for creating mean comparison tables (8:16).
Excel Tutorials

Chapter 4
Basic Data Entry & Management
Shows you how to enter and organize data on worksheet (6:13).
Excel Tutorials

Chapter 1
How to Calculate PValue for an FStatistic
Uses Excel F.DIST function (2:26)
Excel Tutorials

Chapter 10
Top 10 Basic Functions & Formulas
Helpful demonstration (16:02).
Excel Tutorials

Chapter 1
OneWay ANOVA with the Data Analysis ToolPak
Nice illustration of underlying data, from Jeffrey Knutsen (4:19)
Excel Tutorials

Chapter 10
How To Calculate Confidence Intervals
Uses Data Analysis ToolPak (4:48)
Excel Tutorials

Chapter 8
Calculating the 95% Confidence Interval after a TTest
From Todd Grande (6:57)
Excel Tutorials

Chapter 9
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials

Chapter 3
Making a Simple Bar Graph
Scott Stevens creates the graph from scratch (5:13)
Excel Tutorials

Chapter 2
Understanding Sample and Population Standard Deviations
Todd Grande Compares Excel's STDEV.S and STDEV.P functions (7:46)
Excel Tutorials

Chapter 8
Multiple Regression Analysis with Data Analysis ToolPak
Tobin Porterfield provides example with movie data (4:56)
Excel Tutorials

Chapter 12
How to Make a Map Chart
Demonstrates using Florida zip codes (4:33).
Excel Tutorials

Chapter 2
Using SUM, COUNT and AVERAGE in PivotTables
Skills needed to make create mean comparison tables (9:51).
Excel Tutorials

Chapter 4
Adding Slicers to PivotTable
Demonstrated with business data (14:01).
Excel Tutorials

Chapter 7
How to Create 100% Stacked Column Chart
Chart option for qualitative dependent variable (4:58).
Excel Tutorials

Chapter 5
How to Generate Discrete Random Numbers
Using the Data Analysis Toolpak (5:48)
Excel Tutorials

Chapter 6
How to Use NORM.DIST and NORM.INV Functions in Excel
From Learn Something (6:12)
Excel Tutorials

Chapter 8
Building a Correlation Matrix with Data Analysis ToolPak
Demo features car data (9:09)
Excel Tutorials

Chapter 11
TukeyKramer Post Hoc Test after OneWay ANOVA
From Todd Grande (15:35)
Excel Tutorials

Chapter 10
Advanced Filter Options Using Criteria Ranges
Leila Gharani shows how to create interactive filters on worksheets (7:23)
Excel Tutorials

Chapter 3
How to Create a Boxplot
Comparing numeric values across multiple categories (2:02).
Excel Tutorials

Chapter 5
How to Make and Interpret a Scatterplot
From Matt Macarty (7:08).
Excel Tutorials

Chapter 5
Excel PivotTables Made Easy
Demonstrates PivotTables with sales data (DV) and addresses common problems (13:17).
Excel Tutorials

Chapter 4
How to Perform a ChiSquare Test for Independence
Includes making table of expected values, from Eugene O'Loughlin (8:42).
Excel Tutorials

Chapter 10
Charts & Graphs to Visualize Quantitative Data
Shows how and when to create different types of charts (34:32).
Excel Tutorials

Chapter 5
Independent Samples TTest from Only Sample Size, Mean, and Standard Deviation
Todd Grande shows how to conduct ttest from descriptive statistics (7:38)
Excel Tutorials

Chapter 9
Analyzing Residuals from Multiple Regression
Cindy Roberts demonstrates with movie revenue example (5:59).
Excel Tutorials

Chapter 13
Conducting a Multiple Regression using Data Analysis Tools
Todd Grande demonstrates with example (10:14).
Excel Tutorials

Chapter 12
Using Dummy Variable in Multiple Regression Analysis
Stephen Peplow demonstrates with example, uses results to make informed predictions (7:23).
Excel Tutorials

Chapter 12
Excel Printing Problems, Solved
Leila Gharani shares tips and suggestions for efficient printing (10:50).
Excel Tutorials

Chapter 1
How to Make CrossTabulation
Uses PivotTable to make crosstable with car data (12:02).
Excel Tutorials

Chapter 4
OneWay ANOVA (Single Factor) with Data Analysis Tools
From Todd Grande (12:02)
Excel Tutorials

Chapter 10
Creating Area Charts to Visualize Data
Shows how and when to create area charts (4:41).
Excel Tutorials

Chapter 5
Binary Logistic Regression
Uses Real Statistics AddIn to analyze business example (4:48).
Excel Tutorials

Chapter 14
ROC Curves and AUC Explained
How to visualize the performance of a binary classifier, useful with logistic regression (14:05).
Excel Tutorials

Chapter 14
Regression with Multiple Dummy Variables and Interaction Terms
Alym Amlani demonstrates with simple business example (8:11)
Excel Tutorials

Chapter 12
How to Create Multiple Line Chart
Plotting two or more lines that have the same xvalues (7:27).
Excel Tutorials

Chapter 5
Logistic Regression Using Excel
Analyzes who survived Titanic disaster using Real Statistics AddIn Logistic Regression Tool (7:54).
Excel Tutorials

Chapter 14
SidebySide Boxplot Tutorial
For Excel 2016 and later versions (3:08).
Excel Tutorials

Chapter 5
How to Generate Normally Distributed Random Numbers
Using Data Analysis Toolpak (5:53)
Excel Tutorials

Chapter 8
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
Excel Tutorials

Chapter 3
Paired Samples tTest in Excel
From Matt Macarty (9:45)
Excel Tutorials

Chapter 9
Assessing Normality of the Residuals using a Histogram
Based on standardized residuals from SAT scores example (5:38).
Excel Tutorials

Chapter 13
Make a Histogram Using Data Analysis ToolPak's Histogram Tool
By Vickie Dominguez (5:40)
Excel Tutorials

Chapter 2
Pivot Table Fields Pane Options
Good overview of Pivot Table options (4:21).
Excel Tutorials

Chapter 7
How to Install Real Statistics AddIn
Expands the statistical capabilities of Excel (11:50).
Excel Tutorials

Chapter 1
How to Generate Uniformly Distributed Random Numbers
Using the Data Analysis Toolpak (6:08)
Excel Tutorials

Chapter 8
Pivot Table Tutorial
By Kevin Stratvert (13:35)
Excel Tutorials

Chapter 2
How to do a Two Sample (Independent) tTest in Excel
From David Dunaetz (8:45)
Excel Tutorials

Chapter 9
JarqueBera Test of Normality
Todd Grande covers with example (7:23).
Excel Tutorials

Chapter 13
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials

Chapter 3
How to Create Confidence Intervals for Difference of Proportions
David Houston works through political examples (20:43).
Excel Tutorials

Chapter 9
Sorting and Filtering Data
Starting from blank worksheet, from Organic Chemistry Tutor (13:28)
Excel Tutorials

Chapter 2
Creating Correlation Table Using Data Analysis Tools
Example based on Boston housing data, shows how to colorcode results (9:39).
Excel Tutorials

Chapter 11
Importing Data from a Website to Spreadsheet
Lucy Provost demonstrates Excel 2016 web queries (6:38)
Excel Tutorials

Chapter 15
How to Test for Equal and Unequal Variance (F Test)
Eugene O'Loughlin shows how to use an F test to decide whether to assume equal variances (7:22)
Excel Tutorials

Chapter 9
Excel Formulas and Functions Tutorial
From Kevin Stratvert (12:28)
Excel Tutorials

Chapter 1
Performing a tTest in Excel on Experimental Data
From James Clark (5:32)
Excel Tutorials

Chapter 9
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
Excel Tutorials

Chapter 3
How to Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials

Chapter 3
Confidence Interval Estimation Using Data Analysis Tool
Calculates CI for Sample Mean (7:29)
Excel Tutorials

Chapter 8
Map Chart Tutorial
With helpful tips on mapping at different levels (15:15).
Excel Tutorials

Chapter 4
Graphing Two Data Series on the Same Scatterplot
Plot two data sets on the same scatterplot for visual comparison (6:07).
Excel Tutorials

Chapter 12
Conducting a Multiple Regression using Data Analysis Tools
From Todd Grande (10:14).
Excel Tutorials

Chapter 12
Logistic Regression Analysis Using Optimization with Solver
Vikas Agrawal discusses concept of logistic regression and implements with Solver (16:26).
Excel Tutorials

Chapter 14
How to Create A Stratified Random Sample
From Tim D'Auria (5:25)
Excel Tutorials

Chapter 6
TTest in Excel
Evan Matthews explains how to conduct a ttest in Excel, and how to interpret the results (7:06)
Excel Tutorials

Chapter 9
Efficient Data Entry wih Excel Forms
Leila Gharani demonstrates (6:21).
Excel Tutorials

Chapter 6
Using Excel for Random Assignment
From Matthew Lavery (4:31)
Excel Tutorials

Chapter 6
Residual Analysis of Simple Regression
Nice analysis of business example (10:35).
Excel Tutorials

Chapter 13
Creating a Dummy Variable for Multiple Regression
Stephen Peplow demonstrates (7:23)
Excel Tutorials

Chapter 12
How to do Linear Regression with Data Analysis Toolpak
Matt Macarthy demonstrates bivariate regression with home sale data(10:40).
Excel Tutorials

Chapter 11
Random Number Generation with Multiple Distributions
Distributions reviewed include uniform, normal, Bernoulli, binomial, Poisson, patterned, and discrete (11:36).
Excel Tutorials

Chapter 6
Confidence Intervals (Using tDistribution)
From John Estes Math (5:36)
Excel Tutorials

Chapter 8
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials

Chapter 3
How to Use Descriptive Statistics Tool
Demonstrates with data on heights (2:37).
Excel Tutorials

Chapter 2
TwoWay ANOVA with Replication using Data Analysis Tools
From Todd Grande (12:42)
Excel Tutorials

Chapter 10
How to Copy and Paste Filtered Data using FILL Option
Useful for creating scatterplots for multiple regression analysis (2:02)
Excel Tutorials

Chapter 12
Cleaning Messy Data for Analysis
Andrew Lockwood shares a lot of great tips and suggestions (21:10).
Excel Tutorials

Chapter 15
Testing Difference of Two Proportions
Matt Vespa solves a sample problem (5:45).
Excel Tutorials

Chapter 9
Working with Different Chart Types
Demonstrated with book sales data (4:30).
Excel Tutorials

Chapter 5
Working with Chi Distribution Functions
From Mauricio Arango (4:12)
Excel Tutorials

Chapter 10
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials

Chapter 3
Choosing & Selecting Statistical Functions
Shows you how to access statistical functions and execute them (6:49).
Excel Tutorials

Chapter 1
OneWay ANOVA with PostHoc tTests
From James Clark (14:25)
Excel Tutorials

Chapter 10
Rank and Percentile Tools in Data Analysis ToolPak
How to use additional tools to describe data (1:57).
Excel Tutorials

Chapter 2
How to Create a Column Chart
Good emphasis on design principles (3:40)
Excel Tutorials

Chapter 2
How to Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials

Chapter 3
NORM.DIST and Related Functions
Todd Grande explains how to use these functions in Excel (9:52)
Excel Tutorials

Chapter 8
How To Make a Scatterplot with Slope, Y Intercept & R Value
Emphasizes Excel functions, another approach to regression analysis (13:23).
Excel Tutorials

Chapter 11
How to Insert Column in Worksheet
Fundamental skill for creating new variables in dataset (2:39)
Excel Tutorials

Chapter 3
How to Show % of Total in PivotTable
Helps create percentages column in frequency distribution table (4:30).
Excel Tutorials

Chapter 2
Cross Tabulation With Frequencies and Percentages
Shows how to calculate values and format PivotTable (15:12).
Excel Tutorials

Chapter 4
How to Use PivotTables to Summarize Data
Nice introduction and demonstration (17:39).
Excel Tutorials

Chapter 2
Learn Chart & Graph Basics for Quick Start
From Leila Gharani (14:09)
Excel Tutorials

Chapter 2
Sorting Worksheet Data
Demonstrates basics of sorting (4:30)
Excel Tutorials

Chapter 2
How to Use CHISQ.TEST and CHISQ.INV.RT Functions
Illustrates with a goodness of fit test (4:12)
Excel Tutorials

Chapter 10
Logistic Regression Using Solver
Demonstrates maximum likelihood estimation using Solver (5:52).
Excel Tutorials

Chapter 14
Multiple Regression with Data Analysis Regression Tool
Nice, generic example, good explanation of results (11:01).
Excel Tutorials

Chapter 12
Using Functions for FDistribution and FTest
Shows how to calculate pvalues for Fstatistics (4:12)
Excel Tutorials

Chapter 10
How to Conduct a ChiSquare Test
From Todd Grande (8:03).
Excel Tutorials

Chapter 10
Import Data from Web
Leila Gharani demonstrates wih oil price and weather examples (10:01).
Excel Tutorials

Chapter 15
How to Draw Simple and Systematic Random Samples
Demostrated with student population (7:37)
Excel Tutorials

Chapter 6
Excel Slicers, Inside Out
Mynda Treacy shows how to setup and use slicers (13:04).
Excel Tutorials

Chapter 7
Import Tab Delimited Text File
Shows how to work with common data format (3:35)
Excel Tutorials

Chapter 15
Bivariate Regression Using SLOPE and INTERCEPT Functions
David Houston demonstrates with global life expectancy data (13:17).
Excel Tutorials

Chapter 11
How to Install Real Statistics AddIn with Windows OS
Shows how to resolve some Windows 10 issues (3:04)
Excel Tutorials

Chapter 1
Assessing Normality of Residuals with Skewness, Kurtosis & JarqueBera Test
By Fam & Fami (7:48).
Excel Tutorials

Chapter 13
Calculating Means and Standard Deviations in PivotTable
Useful for creating mean comparison tables (7:34).
Excel Tutorials

Chapter 4
Import Text Files into Excel
Ajay Anand shows 5 different methods (13:07).
Excel Tutorials

Chapter 15
How To Import A Text File
Keith Aul shows how to import data from plain text file (9:14).
Excel Tutorials

Chapter 15
Excel Pivot Tables Explained
Leila Gharani uses PivotTables to summarize sales data by other variables, like sales by product (13:21).
Excel Tutorials

Chapter 4
Using PivotTable to Create Controlled Mean Comparison Table
Example shows repair time (DV) by technician, controlling for job type (4:01).
Excel Tutorials

Chapter 7
Descriptive Statistics with Excel's Data Analysis ToolPak
By Matt Macarty (4:24)
Excel Tutorials

Chapter 2
Residuals and Residual Plots
Daniel McCarron discusses and demonstrates regression diagnostics with residuals (13:50).
Excel Tutorials

Chapter 13
How to Create Simple Random Sample and Systematic Sample
From Farhad Zulfiqar (5:18)
Excel Tutorials

Chapter 6
How to Perform a TwoWay ANOVA without Replication
From Stephanie Glen (3:08)
Excel Tutorials

Chapter 10
Creating a Boxplot
Tutorial from Todd Grande (12:03).
Excel Tutorials

Chapter 5
How to Conduct Analysis of Variance (ANOVA) and Graph Results
From Amy Dykstra (9:01)
Excel Tutorials

Chapter 10
How to Group, Ungroup, and Remove PivotTable Rows
Useful for making comparisons with intervallevel independent variable (3:23).
Excel Tutorials

Chapter 4
How to Make a Line Graph
Show you how to create and edit a line chart (6:07).
Excel Tutorials

Chapter 5
Creating a Scatter Plot
Shows you how to make a basic scatterplot and edit it for clarity (4:38).
Excel Tutorials

Chapter 5
Using Count, Average and Sum in Pivot Tables
Useful for creating mean comparison tables (8:16).
Excel Tutorials

Chapter 4
Basic Data Entry & Management
Shows you how to enter and organize data on worksheet (6:13).
Excel Tutorials

Chapter 1
How to Calculate PValue for an FStatistic
Uses Excel F.DIST function (2:26)
Excel Tutorials

Chapter 10
Top 10 Basic Functions & Formulas
Helpful demonstration (16:02).
Excel Tutorials

Chapter 1
OneWay ANOVA with the Data Analysis ToolPak
Nice illustration of underlying data, from Jeffrey Knutsen (4:19)
Excel Tutorials

Chapter 10
How To Calculate Confidence Intervals
Uses Data Analysis ToolPak (4:48)
Excel Tutorials

Chapter 8
Calculating the 95% Confidence Interval after a TTest
From Todd Grande (6:57)
Excel Tutorials

Chapter 9
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials

Chapter 3
Making a Simple Bar Graph
Scott Stevens creates the graph from scratch (5:13)
Excel Tutorials

Chapter 2
Understanding Sample and Population Standard Deviations
Todd Grande Compares Excel's STDEV.S and STDEV.P functions (7:46)
Excel Tutorials

Chapter 8
Multiple Regression Analysis with Data Analysis ToolPak
Tobin Porterfield provides example with movie data (4:56)
Excel Tutorials

Chapter 12
How to Make a Map Chart
Demonstrates using Florida zip codes (4:33).
Excel Tutorials

Chapter 2
Using SUM, COUNT and AVERAGE in PivotTables
Skills needed to make create mean comparison tables (9:51).
Excel Tutorials

Chapter 4
Adding Slicers to PivotTable
Demonstrated with business data (14:01).
Excel Tutorials

Chapter 7
How to Create 100% Stacked Column Chart
Chart option for qualitative dependent variable (4:58).
Excel Tutorials

Chapter 5
How to Generate Discrete Random Numbers
Using the Data Analysis Toolpak (5:48)
Excel Tutorials

Chapter 6
How to Use NORM.DIST and NORM.INV Functions in Excel
From Learn Something (6:12)
Excel Tutorials

Chapter 8
Building a Correlation Matrix with Data Analysis ToolPak
Demo features car data (9:09)
Excel Tutorials

Chapter 11
TukeyKramer Post Hoc Test after OneWay ANOVA
From Todd Grande (15:35)
Excel Tutorials

Chapter 10
Advanced Filter Options Using Criteria Ranges
Leila Gharani shows how to create interactive filters on worksheets (7:23)
Excel Tutorials

Chapter 3
How to Create a Boxplot
Comparing numeric values across multiple categories (2:02).
Excel Tutorials

Chapter 5
How to Make and Interpret a Scatterplot
From Matt Macarty (7:08).
Excel Tutorials

Chapter 5
Excel PivotTables Made Easy
Demonstrates PivotTables with sales data (DV) and addresses common problems (13:17).
Excel Tutorials

Chapter 4
How to Perform a ChiSquare Test for Independence
Includes making table of expected values, from Eugene O'Loughlin (8:42).
Excel Tutorials

Chapter 10
Charts & Graphs to Visualize Quantitative Data
Shows how and when to create different types of charts (34:32).
Excel Tutorials

Chapter 5
Independent Samples TTest from Only Sample Size, Mean, and Standard Deviation
Todd Grande shows how to conduct ttest from descriptive statistics (7:38)
Excel Tutorials

Chapter 9
Analyzing Residuals from Multiple Regression
Cindy Roberts demonstrates with movie revenue example (5:59).
Excel Tutorials

Chapter 13
Conducting a Multiple Regression using Data Analysis Tools
Todd Grande demonstrates with example (10:14).
Excel Tutorials

Chapter 12
Using Dummy Variable in Multiple Regression Analysis
Stephen Peplow demonstrates with example, uses results to make informed predictions (7:23).
Excel Tutorials

Chapter 12
Excel Printing Problems, Solved
Leila Gharani shares tips and suggestions for efficient printing (10:50).
Excel Tutorials

Chapter 1
How to Make CrossTabulation
Uses PivotTable to make crosstable with car data (12:02).
Excel Tutorials

Chapter 4
OneWay ANOVA (Single Factor) with Data Analysis Tools
From Todd Grande (12:02)
Excel Tutorials

Chapter 10
Creating Area Charts to Visualize Data
Shows how and when to create area charts (4:41).
Excel Tutorials

Chapter 5
Binary Logistic Regression
Uses Real Statistics AddIn to analyze business example (4:48).
Excel Tutorials

Chapter 14
ROC Curves and AUC Explained
How to visualize the performance of a binary classifier, useful with logistic regression (14:05).
Excel Tutorials

Chapter 14
Regression with Multiple Dummy Variables and Interaction Terms
Alym Amlani demonstrates with simple business example (8:11)
Excel Tutorials

Chapter 12
How to Create Multiple Line Chart
Plotting two or more lines that have the same xvalues (7:27).
Excel Tutorials

Chapter 5
Logistic Regression Using Excel
Analyzes who survived Titanic disaster using Real Statistics AddIn Logistic Regression Tool (7:54).
Excel Tutorials

Chapter 14
SidebySide Boxplot Tutorial
For Excel 2016 and later versions (3:08).
Excel Tutorials

Chapter 5
How to Generate Normally Distributed Random Numbers
Using Data Analysis Toolpak (5:53)
Excel Tutorials

Chapter 8
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
Excel Tutorials

Chapter 3
Paired Samples tTest in Excel
From Matt Macarty (9:45)
Excel Tutorials

Chapter 9
Assessing Normality of the Residuals using a Histogram
Based on standardized residuals from SAT scores example (5:38).
Excel Tutorials

Chapter 13
Make a Histogram Using Data Analysis ToolPak's Histogram Tool
By Vickie Dominguez (5:40)
Excel Tutorials

Chapter 2
Pivot Table Fields Pane Options
Good overview of Pivot Table options (4:21).
Excel Tutorials

Chapter 7
How to Install Real Statistics AddIn
Expands the statistical capabilities of Excel (11:50).
Excel Tutorials

Chapter 1
How to Generate Uniformly Distributed Random Numbers
Using the Data Analysis Toolpak (6:08)
Excel Tutorials

Chapter 8
Pivot Table Tutorial
By Kevin Stratvert (13:35)
Excel Tutorials

Chapter 2
How to do a Two Sample (Independent) tTest in Excel
From David Dunaetz (8:45)
Excel Tutorials

Chapter 9
JarqueBera Test of Normality
Todd Grande covers with example (7:23).
Excel Tutorials

Chapter 13
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials

Chapter 3
How to Create Confidence Intervals for Difference of Proportions
David Houston works through political examples (20:43).
Excel Tutorials

Chapter 9
Sorting and Filtering Data
Starting from blank worksheet, from Organic Chemistry Tutor (13:28)
Excel Tutorials

Chapter 2
Creating Correlation Table Using Data Analysis Tools
Example based on Boston housing data, shows how to colorcode results (9:39).
Excel Tutorials

Chapter 11
Importing Data from a Website to Spreadsheet
Lucy Provost demonstrates Excel 2016 web queries (6:38)
Excel Tutorials

Chapter 15
How to Test for Equal and Unequal Variance (F Test)
Eugene O'Loughlin shows how to use an F test to decide whether to assume equal variances (7:22)
Excel Tutorials

Chapter 9
Excel Formulas and Functions Tutorial
From Kevin Stratvert (12:28)
Excel Tutorials

Chapter 1
Performing a tTest in Excel on Experimental Data
From James Clark (5:32)
Excel Tutorials

Chapter 9
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
Excel Tutorials

Chapter 3
How to Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials

Chapter 3
Confidence Interval Estimation Using Data Analysis Tool
Calculates CI for Sample Mean (7:29)
Excel Tutorials

Chapter 8
Map Chart Tutorial
With helpful tips on mapping at different levels (15:15).
Excel Tutorials

Chapter 4
Graphing Two Data Series on the Same Scatterplot
Plot two data sets on the same scatterplot for visual comparison (6:07).
Excel Tutorials

Chapter 12
Conducting a Multiple Regression using Data Analysis Tools
From Todd Grande (10:14).
Excel Tutorials

Chapter 12
Logistic Regression Analysis Using Optimization with Solver
Vikas Agrawal discusses concept of logistic regression and implements with Solver (16:26).
Excel Tutorials

Chapter 14
How to Create A Stratified Random Sample
From Tim D'Auria (5:25)
Excel Tutorials

Chapter 6
TTest in Excel
Evan Matthews explains how to conduct a ttest in Excel, and how to interpret the results (7:06)
Excel Tutorials

Chapter 9
Efficient Data Entry wih Excel Forms
Leila Gharani demonstrates (6:21).
Excel Tutorials

Chapter 6
Using Excel for Random Assignment
From Matthew Lavery (4:31)
Excel Tutorials

Chapter 6
Residual Analysis of Simple Regression
Nice analysis of business example (10:35).
Excel Tutorials

Chapter 13
Creating a Dummy Variable for Multiple Regression
Stephen Peplow demonstrates (7:23)
Excel Tutorials

Chapter 12
How to do Linear Regression with Data Analysis Toolpak
Matt Macarthy demonstrates bivariate regression with home sale data(10:40).
Excel Tutorials

Chapter 11
Random Number Generation with Multiple Distributions
Distributions reviewed include uniform, normal, Bernoulli, binomial, Poisson, patterned, and discrete (11:36).
Excel Tutorials

Chapter 6
Confidence Intervals (Using tDistribution)
From John Estes Math (5:36)
Excel Tutorials

Chapter 8
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials

Chapter 3
How to Use Descriptive Statistics Tool
Demonstrates with data on heights (2:37).
Excel Tutorials

Chapter 2
TwoWay ANOVA with Replication using Data Analysis Tools
From Todd Grande (12:42)
Excel Tutorials

Chapter 10
How to Copy and Paste Filtered Data using FILL Option
Useful for creating scatterplots for multiple regression analysis (2:02)
Excel Tutorials

Chapter 12
Cleaning Messy Data for Analysis
Andrew Lockwood shares a lot of great tips and suggestions (21:10).
Excel Tutorials

Chapter 15
Testing Difference of Two Proportions
Matt Vespa solves a sample problem (5:45).
Excel Tutorials

Chapter 9
Working with Different Chart Types
Demonstrated with book sales data (4:30).
Excel Tutorials

Chapter 5
Working with Chi Distribution Functions
From Mauricio Arango (4:12)
Excel Tutorials

Chapter 10
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials

Chapter 3
Choosing & Selecting Statistical Functions
Shows you how to access statistical functions and execute them (6:49).
Excel Tutorials

Chapter 1
OneWay ANOVA with PostHoc tTests
From James Clark (14:25)
Excel Tutorials

Chapter 10
Rank and Percentile Tools in Data Analysis ToolPak
How to use additional tools to describe data (1:57).
Excel Tutorials

Chapter 2
How to Create a Column Chart
Good emphasis on design principles (3:40)
Excel Tutorials

Chapter 2
How to Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials

Chapter 3
NORM.DIST and Related Functions
Todd Grande explains how to use these functions in Excel (9:52)
Excel Tutorials

Chapter 8
How To Make a Scatterplot with Slope, Y Intercept & R Value
Emphasizes Excel functions, another approach to regression analysis (13:23).
Excel Tutorials

Chapter 11
How to Insert Column in Worksheet
Fundamental skill for creating new variables in dataset (2:39)
Excel Tutorials

Chapter 3
How to Show % of Total in PivotTable
Helps create percentages column in frequency distribution table (4:30).
Excel Tutorials

Chapter 2
Cross Tabulation With Frequencies and Percentages
Shows how to calculate values and format PivotTable (15:12).
Excel Tutorials

Chapter 4
How to Use PivotTables to Summarize Data
Nice introduction and demonstration (17:39).
Excel Tutorials

Chapter 2
Learn Chart & Graph Basics for Quick Start
From Leila Gharani (14:09)
Excel Tutorials

Chapter 2
Sorting Worksheet Data
Demonstrates basics of sorting (4:30)
Excel Tutorials

Chapter 2
How to Use CHISQ.TEST and CHISQ.INV.RT Functions
Illustrates with a goodness of fit test (4:12)
Excel Tutorials

Chapter 10
Logistic Regression Using Solver
Demonstrates maximum likelihood estimation using Solver (5:52).
Excel Tutorials

Chapter 14
Multiple Regression with Data Analysis Regression Tool
Nice, generic example, good explanation of results (11:01).
Excel Tutorials

Chapter 12
Using Functions for FDistribution and FTest
Shows how to calculate pvalues for Fstatistics (4:12)
Excel Tutorials

Chapter 10
How to Conduct a ChiSquare Test
From Todd Grande (8:03).
Excel Tutorials

Chapter 10
Import Data from Web
Leila Gharani demonstrates wih oil price and weather examples (10:01).
Excel Tutorials

Chapter 15
How to Draw Simple and Systematic Random Samples
Demostrated with student population (7:37)
Excel Tutorials

Chapter 6
Excel Slicers, Inside Out
Mynda Treacy shows how to setup and use slicers (13:04).
Excel Tutorials

Chapter 7
Import Tab Delimited Text File
Shows how to work with common data format (3:35)
Excel Tutorials

Chapter 15
Bivariate Regression Using SLOPE and INTERCEPT Functions
David Houston demonstrates with global life expectancy data (13:17).
Excel Tutorials

Chapter 11
How to Install Real Statistics AddIn with Windows OS
Shows how to resolve some Windows 10 issues (3:04)
Excel Tutorials

Chapter 1
Assessing Normality of Residuals with Skewness, Kurtosis & JarqueBera Test
By Fam & Fami (7:48).
Excel Tutorials

Chapter 13
Calculating Means and Standard Deviations in PivotTable
Useful for creating mean comparison tables (7:34).
Excel Tutorials

Chapter 4
Import Text Files into Excel
Ajay Anand shows 5 different methods (13:07).
Excel Tutorials

Chapter 15
How To Import A Text File
Keith Aul shows how to import data from plain text file (9:14).
Excel Tutorials

Chapter 15
Excel Pivot Tables Explained
Leila Gharani uses PivotTables to summarize sales data by other variables, like sales by product (13:21).
Excel Tutorials

Chapter 4
Using PivotTable to Create Controlled Mean Comparison Table
Example shows repair time (DV) by technician, controlling for job type (4:01).
Excel Tutorials

Chapter 7
Descriptive Statistics with Excel's Data Analysis ToolPak
By Matt Macarty (4:24)
Excel Tutorials

Chapter 2
Residuals and Residual Plots
Daniel McCarron discusses and demonstrates regression diagnostics with residuals (13:50).
Excel Tutorials

Chapter 13
How to Create Simple Random Sample and Systematic Sample
From Farhad Zulfiqar (5:18)
Excel Tutorials

Chapter 6
How to Perform a TwoWay ANOVA without Replication
From Stephanie Glen (3:08)
Excel Tutorials

Chapter 10
Creating a Boxplot
Tutorial from Todd Grande (12:03).
Excel Tutorials

Chapter 5
How to Conduct Analysis of Variance (ANOVA) and Graph Results
From Amy Dykstra (9:01)
Excel Tutorials

Chapter 10
How to Group, Ungroup, and Remove PivotTable Rows
Useful for making comparisons with intervallevel independent variable (3:23).
Excel Tutorials

Chapter 4
How to Make a Line Graph
Show you how to create and edit a line chart (6:07).
Excel Tutorials

Chapter 5
Creating a Scatter Plot
Shows you how to make a basic scatterplot and edit it for clarity (4:38).
Excel Tutorials

Chapter 5
Using Count, Average and Sum in Pivot Tables
Useful for creating mean comparison tables (8:16).
Excel Tutorials

Chapter 4
Basic Data Entry & Management
Shows you how to enter and organize data on worksheet (6:13).
Excel Tutorials

Chapter 1
How to Calculate PValue for an FStatistic
Uses Excel F.DIST function (2:26)
Excel Tutorials

Chapter 10
Top 10 Basic Functions & Formulas
Helpful demonstration (16:02).
Excel Tutorials

Chapter 1
OneWay ANOVA with the Data Analysis ToolPak
Nice illustration of underlying data, from Jeffrey Knutsen (4:19)
Excel Tutorials

Chapter 10
How To Calculate Confidence Intervals
Uses Data Analysis ToolPak (4:48)
Excel Tutorials

Chapter 8
Calculating the 95% Confidence Interval after a TTest
From Todd Grande (6:57)
Excel Tutorials

Chapter 9
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials

Chapter 3
Making a Simple Bar Graph
Scott Stevens creates the graph from scratch (5:13)
Excel Tutorials

Chapter 2
Understanding Sample and Population Standard Deviations
Todd Grande Compares Excel's STDEV.S and STDEV.P functions (7:46)
Excel Tutorials

Chapter 8
Multiple Regression Analysis with Data Analysis ToolPak
Tobin Porterfield provides example with movie data (4:56)
Excel Tutorials

Chapter 12
How to Make a Map Chart
Demonstrates using Florida zip codes (4:33).
Excel Tutorials

Chapter 2
Using SUM, COUNT and AVERAGE in PivotTables
Skills needed to make create mean comparison tables (9:51).
Excel Tutorials

Chapter 4
Adding Slicers to PivotTable
Demonstrated with business data (14:01).
Excel Tutorials

Chapter 7
How to Create 100% Stacked Column Chart
Chart option for qualitative dependent variable (4:58).
Excel Tutorials

Chapter 5
How to Generate Discrete Random Numbers
Using the Data Analysis Toolpak (5:48)
Excel Tutorials

Chapter 6
How to Use NORM.DIST and NORM.INV Functions in Excel
From Learn Something (6:12)
Excel Tutorials

Chapter 8
Building a Correlation Matrix with Data Analysis ToolPak
Demo features car data (9:09)
Excel Tutorials

Chapter 11
TukeyKramer Post Hoc Test after OneWay ANOVA
From Todd Grande (15:35)
Excel Tutorials

Chapter 10
Advanced Filter Options Using Criteria Ranges
Leila Gharani shows how to create interactive filters on worksheets (7:23)
Excel Tutorials

Chapter 3
How to Create a Boxplot
Comparing numeric values across multiple categories (2:02).
Excel Tutorials

Chapter 5
How to Make and Interpret a Scatterplot
From Matt Macarty (7:08).
Excel Tutorials

Chapter 5
Excel PivotTables Made Easy
Demonstrates PivotTables with sales data (DV) and addresses common problems (13:17).
Excel Tutorials

Chapter 4
How to Perform a ChiSquare Test for Independence
Includes making table of expected values, from Eugene O'Loughlin (8:42).
Excel Tutorials

Chapter 10
Charts & Graphs to Visualize Quantitative Data
Shows how and when to create different types of charts (34:32).
Excel Tutorials

Chapter 5
Independent Samples TTest from Only Sample Size, Mean, and Standard Deviation
Todd Grande shows how to conduct ttest from descriptive statistics (7:38)
Excel Tutorials

Chapter 9
Analyzing Residuals from Multiple Regression
Cindy Roberts demonstrates with movie revenue example (5:59).
Excel Tutorials

Chapter 13
Conducting a Multiple Regression using Data Analysis Tools
Todd Grande demonstrates with example (10:14).
Excel Tutorials

Chapter 12
Using Dummy Variable in Multiple Regression Analysis
Stephen Peplow demonstrates with example, uses results to make informed predictions (7:23).
Excel Tutorials

Chapter 12
Excel Printing Problems, Solved
Leila Gharani shares tips and suggestions for efficient printing (10:50).
Excel Tutorials

Chapter 1
How to Make CrossTabulation
Uses PivotTable to make crosstable with car data (12:02).
Excel Tutorials

Chapter 4
OneWay ANOVA (Single Factor) with Data Analysis Tools
From Todd Grande (12:02)
Excel Tutorials

Chapter 10
Creating Area Charts to Visualize Data
Shows how and when to create area charts (4:41).
Excel Tutorials

Chapter 5
Binary Logistic Regression
Uses Real Statistics AddIn to analyze business example (4:48).
Excel Tutorials

Chapter 14
ROC Curves and AUC Explained
How to visualize the performance of a binary classifier, useful with logistic regression (14:05).
Excel Tutorials

Chapter 14
Regression with Multiple Dummy Variables and Interaction Terms
Alym Amlani demonstrates with simple business example (8:11)
Excel Tutorials

Chapter 12
How to Create Multiple Line Chart
Plotting two or more lines that have the same xvalues (7:27).
Excel Tutorials

Chapter 5
Logistic Regression Using Excel
Analyzes who survived Titanic disaster using Real Statistics AddIn Logistic Regression Tool (7:54).
Excel Tutorials

Chapter 14
SidebySide Boxplot Tutorial
For Excel 2016 and later versions (3:08).
Excel Tutorials

Chapter 5
How to Generate Normally Distributed Random Numbers
Using Data Analysis Toolpak (5:53)
Excel Tutorials

Chapter 8
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
Excel Tutorials

Chapter 3
Paired Samples tTest in Excel
From Matt Macarty (9:45)
Excel Tutorials

Chapter 9
Assessing Normality of the Residuals using a Histogram
Based on standardized residuals from SAT scores example (5:38).
Excel Tutorials

Chapter 13
Make a Histogram Using Data Analysis ToolPak's Histogram Tool
By Vickie Dominguez (5:40)
Excel Tutorials

Chapter 2
Pivot Table Fields Pane Options
Good overview of Pivot Table options (4:21).
Excel Tutorials

Chapter 7
How to Install Real Statistics AddIn
Expands the statistical capabilities of Excel (11:50).
Excel Tutorials

Chapter 1
How to Generate Uniformly Distributed Random Numbers
Using the Data Analysis Toolpak (6:08)
Excel Tutorials

Chapter 8
Pivot Table Tutorial
By Kevin Stratvert (13:35)
Excel Tutorials

Chapter 2
How to do a Two Sample (Independent) tTest in Excel
From David Dunaetz (8:45)
Excel Tutorials

Chapter 9
JarqueBera Test of Normality
Todd Grande covers with example (7:23).
Excel Tutorials

Chapter 13
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials

Chapter 3
How to Create Confidence Intervals for Difference of Proportions
David Houston works through political examples (20:43).
Excel Tutorials

Chapter 9
Sorting and Filtering Data
Starting from blank worksheet, from Organic Chemistry Tutor (13:28)
Excel Tutorials

Chapter 2
Creating Correlation Table Using Data Analysis Tools
Example based on Boston housing data, shows how to colorcode results (9:39).
Excel Tutorials

Chapter 11
Importing Data from a Website to Spreadsheet
Lucy Provost demonstrates Excel 2016 web queries (6:38)
Excel Tutorials

Chapter 15
How to Test for Equal and Unequal Variance (F Test)
Eugene O'Loughlin shows how to use an F test to decide whether to assume equal variances (7:22)
Excel Tutorials

Chapter 9
Excel Formulas and Functions Tutorial
From Kevin Stratvert (12:28)
Excel Tutorials

Chapter 1
Performing a tTest in Excel on Experimental Data
From James Clark (5:32)
Excel Tutorials

Chapter 9
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
Excel Tutorials

Chapter 3
How to Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials

Chapter 3
Confidence Interval Estimation Using Data Analysis Tool
Calculates CI for Sample Mean (7:29)
Excel Tutorials

Chapter 8
Map Chart Tutorial
With helpful tips on mapping at different levels (15:15).
Excel Tutorials

Chapter 4
Graphing Two Data Series on the Same Scatterplot
Plot two data sets on the same scatterplot for visual comparison (6:07).
Excel Tutorials

Chapter 12
Conducting a Multiple Regression using Data Analysis Tools
From Todd Grande (10:14).
Excel Tutorials

Chapter 12
Logistic Regression Analysis Using Optimization with Solver
Vikas Agrawal discusses concept of logistic regression and implements with Solver (16:26).
Excel Tutorials

Chapter 14
How to Create A Stratified Random Sample
From Tim D'Auria (5:25)
Excel Tutorials

Chapter 6
TTest in Excel
Evan Matthews explains how to conduct a ttest in Excel, and how to interpret the results (7:06)
Excel Tutorials

Chapter 9
Efficient Data Entry wih Excel Forms
Leila Gharani demonstrates (6:21).
Excel Tutorials

Chapter 6
Using Excel for Random Assignment
From Matthew Lavery (4:31)
Excel Tutorials

Chapter 6
Residual Analysis of Simple Regression
Nice analysis of business example (10:35).
Excel Tutorials

Chapter 13
Creating a Dummy Variable for Multiple Regression
Stephen Peplow demonstrates (7:23)
Excel Tutorials

Chapter 12
How to do Linear Regression with Data Analysis Toolpak
Matt Macarthy demonstrates bivariate regression with home sale data(10:40).
Excel Tutorials

Chapter 11
Random Number Generation with Multiple Distributions
Distributions reviewed include uniform, normal, Bernoulli, binomial, Poisson, patterned, and discrete (11:36).
Excel Tutorials

Chapter 6
Confidence Intervals (Using tDistribution)
From John Estes Math (5:36)
Excel Tutorials

Chapter 8
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials

Chapter 3
How to Use Descriptive Statistics Tool
Demonstrates with data on heights (2:37).
Excel Tutorials

Chapter 2
TwoWay ANOVA with Replication using Data Analysis Tools
From Todd Grande (12:42)
Excel Tutorials

Chapter 10
How to Copy and Paste Filtered Data using FILL Option
Useful for creating scatterplots for multiple regression analysis (2:02)
Excel Tutorials

Chapter 12
Cleaning Messy Data for Analysis
Andrew Lockwood shares a lot of great tips and suggestions (21:10).
Excel Tutorials

Chapter 15
Testing Difference of Two Proportions
Matt Vespa solves a sample problem (5:45).
Excel Tutorials

Chapter 9
Working with Different Chart Types
Demonstrated with book sales data (4:30).
Excel Tutorials

Chapter 5
Working with Chi Distribution Functions
From Mauricio Arango (4:12)
Excel Tutorials

Chapter 10
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials

Chapter 3
Choosing & Selecting Statistical Functions
Shows you how to access statistical functions and execute them (6:49).
Excel Tutorials

Chapter 1
OneWay ANOVA with PostHoc tTests
From James Clark (14:25)
Excel Tutorials

Chapter 10
Rank and Percentile Tools in Data Analysis ToolPak
How to use additional tools to describe data (1:57).
Excel Tutorials

Chapter 2
How to Create a Column Chart
Good emphasis on design principles (3:40)
Excel Tutorials

Chapter 2
How to Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials

Chapter 3
NORM.DIST and Related Functions
Todd Grande explains how to use these functions in Excel (9:52)
Excel Tutorials

Chapter 8
How To Make a Scatterplot with Slope, Y Intercept & R Value
Emphasizes Excel functions, another approach to regression analysis (13:23).
Excel Tutorials

Chapter 11
How to Insert Column in Worksheet
Fundamental skill for creating new variables in dataset (2:39)
Excel Tutorials

Chapter 3
How to Show % of Total in PivotTable
Helps create percentages column in frequency distribution table (4:30).
Excel Tutorials

Chapter 2
Cross Tabulation With Frequencies and Percentages
Shows how to calculate values and format PivotTable (15:12).
Excel Tutorials

Chapter 4
How to Use PivotTables to Summarize Data
Nice introduction and demonstration (17:39).
Excel Tutorials

Chapter 2
Learn Chart & Graph Basics for Quick Start
From Leila Gharani (14:09)
Excel Tutorials

Chapter 2
Sorting Worksheet Data
Demonstrates basics of sorting (4:30)
Excel Tutorials

Chapter 2
How to Use CHISQ.TEST and CHISQ.INV.RT Functions
Illustrates with a goodness of fit test (4:12)
Excel Tutorials

Chapter 10
Logistic Regression Using Solver
Demonstrates maximum likelihood estimation using Solver (5:52).
Excel Tutorials

Chapter 14
Multiple Regression with Data Analysis Regression Tool
Nice, generic example, good explanation of results (11:01).
Excel Tutorials

Chapter 12
Using Functions for FDistribution and FTest
Shows how to calculate pvalues for Fstatistics (4:12)
Excel Tutorials

Chapter 10
How to Conduct a ChiSquare Test
From Todd Grande (8:03).
Excel Tutorials

Chapter 10
Import Data from Web
Leila Gharani demonstrates wih oil price and weather examples (10:01).
Excel Tutorials

Chapter 15
How to Draw Simple and Systematic Random Samples
Demostrated with student population (7:37)
Excel Tutorials

Chapter 6
Excel Slicers, Inside Out
Mynda Treacy shows how to setup and use slicers (13:04).
Excel Tutorials

Chapter 7
Import Tab Delimited Text File
Shows how to work with common data format (3:35)
Excel Tutorials

Chapter 15
Bivariate Regression Using SLOPE and INTERCEPT Functions
David Houston demonstrates with global life expectancy data (13:17).
Excel Tutorials

Chapter 11
How to Install Real Statistics AddIn with Windows OS
Shows how to resolve some Windows 10 issues (3:04)
Excel Tutorials

Chapter 1
Assessing Normality of Residuals with Skewness, Kurtosis & JarqueBera Test
By Fam & Fami (7:48).
Excel Tutorials

Chapter 13
Calculating Means and Standard Deviations in PivotTable
Useful for creating mean comparison tables (7:34).
Excel Tutorials

Chapter 4
Import Text Files into Excel
Ajay Anand shows 5 different methods (13:07).
Excel Tutorials

Chapter 15
How To Import A Text File
Keith Aul shows how to import data from plain text file (9:14).
Excel Tutorials

Chapter 15
Excel Pivot Tables Explained
Leila Gharani uses PivotTables to summarize sales data by other variables, like sales by product (13:21).
Excel Tutorials

Chapter 4
Using PivotTable to Create Controlled Mean Comparison Table
Example shows repair time (DV) by technician, controlling for job type (4:01).
Excel Tutorials

Chapter 7
Descriptive Statistics with Excel's Data Analysis ToolPak
By Matt Macarty (4:24)
Excel Tutorials

Chapter 2
Residuals and Residual Plots
Daniel McCarron discusses and demonstrates regression diagnostics with residuals (13:50).
Excel Tutorials

Chapter 13
Additional References
Additional References
Additional References
Additional References
RegressIt: Excel AddOn for Data Analysis
Performs multivariate descriptive data analysis and regression analysis with highquality table and chart output in
...
Excel Tutorials

Chapter 15
Monte Carlo Simulation with Excel
Short article from Real Statistics Using Excel web site described how to generate random numbers with functions and
...
Excel Tutorials

Chapter 8
SolverStat
SolverStat is an Excel addin (xla) that performs advanced statistical tests on least squares regression data.
Excel Tutorials

Chapter 15
Excel Exposure
As easy reference for Excel users of all skill levels helping you to develop and refine your skills, many free less
...
Excel Tutorials

Chapter 1
Logistic Regression Reference
Detailed reference from Real Statistics Using Excel, covers logistic regression AddIn.
Excel Tutorials

Chapter 14
ExcelJet
Learn data analysis with Excel from clear examples and bitesized videos.
Excel Tutorials

Chapter 1
ChiSquare and F Distributions
Excellent references for ChiSquare Test and ANOVA featuring Excel.
Excel Tutorials

Chapter 10
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.
Excel Tutorials

Chapter 10
Sampling with Excel
Short howto article from Real Statistics Using Excel web site.
Excel Tutorials

Chapter 6
Xelplus: Courses, Tutorials, and Instructional Videos
Succinct and clear Excel tutorials, see
YouTube Channel
.
Excel Tutorials

Chapter 1
Regression Analysis Output Explained
Page describes tables generated by Data Analysis Regression Tool in detail.
Excel Tutorials

Chapter 11
Linear Regression Reference
Real Statistics Using Excel shows how to conduct linear regression analysis, including advanced models.
Excel Tutorials

Chapter 11
Real Statistics Using Excel
A practical guide for how to do statistical analysis in Excel plus free statistics software which extends Excel's b
...
Excel Tutorials

Chapter 1
RegressIt: Excel AddOn for Data Analysis
Performs multivariate descriptive data analysis and regression analysis with highquality table and chart output in
...
Excel Tutorials

Chapter 15
Monte Carlo Simulation with Excel
Short article from Real Statistics Using Excel web site described how to generate random numbers with functions and
...
Excel Tutorials

Chapter 8
SolverStat
SolverStat is an Excel addin (xla) that performs advanced statistical tests on least squares regression data.
Excel Tutorials

Chapter 15
Excel Exposure
As easy reference for Excel users of all skill levels helping you to develop and refine your skills, many free less
...
Excel Tutorials

Chapter 1
Logistic Regression Reference
Detailed reference from Real Statistics Using Excel, covers logistic regression AddIn.
Excel Tutorials

Chapter 14
ExcelJet
Learn data analysis with Excel from clear examples and bitesized videos.
Excel Tutorials

Chapter 1
ChiSquare and F Distributions
Excellent references for ChiSquare Test and ANOVA featuring Excel.
Excel Tutorials

Chapter 10
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.
Excel Tutorials

Chapter 10
Sampling with Excel
Short howto article from Real Statistics Using Excel web site.
Excel Tutorials

Chapter 6
Xelplus: Courses, Tutorials, and Instructional Videos
Succinct and clear Excel tutorials, see
YouTube Channel
.
Excel Tutorials

Chapter 1
Regression Analysis Output Explained
Page describes tables generated by Data Analysis Regression Tool in detail.
Excel Tutorials

Chapter 11
Linear Regression Reference
Real Statistics Using Excel shows how to conduct linear regression analysis, including advanced models.
Excel Tutorials

Chapter 11
Real Statistics Using Excel
A practical guide for how to do statistical analysis in Excel plus free statistics software which extends Excel's b
...
Excel Tutorials

Chapter 1
RegressIt: Excel AddOn for Data Analysis
Performs multivariate descriptive data analysis and regression analysis with highquality table and chart output in
...
Excel Tutorials

Chapter 15
Monte Carlo Simulation with Excel
Short article from Real Statistics Using Excel web site described how to generate random numbers with functions and
...
Excel Tutorials

Chapter 8
SolverStat
SolverStat is an Excel addin (xla) that performs advanced statistical tests on least squares regression data.
Excel Tutorials

Chapter 15
Excel Exposure
As easy reference for Excel users of all skill levels helping you to develop and refine your skills, many free less
...
Excel Tutorials

Chapter 1
Logistic Regression Reference
Detailed reference from Real Statistics Using Excel, covers logistic regression AddIn.
Excel Tutorials

Chapter 14
ExcelJet
Learn data analysis with Excel from clear examples and bitesized videos.
Excel Tutorials

Chapter 1
ChiSquare and F Distributions
Excellent references for ChiSquare Test and ANOVA featuring Excel.
Excel Tutorials

Chapter 10
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.
Excel Tutorials

Chapter 10
Sampling with Excel
Short howto article from Real Statistics Using Excel web site.
Excel Tutorials

Chapter 6
Xelplus: Courses, Tutorials, and Instructional Videos
Succinct and clear Excel tutorials, see
YouTube Channel
.
Excel Tutorials

Chapter 1
Regression Analysis Output Explained
Page describes tables generated by Data Analysis Regression Tool in detail.
Excel Tutorials

Chapter 11
Linear Regression Reference
Real Statistics Using Excel shows how to conduct linear regression analysis, including advanced models.
Excel Tutorials

Chapter 11
Real Statistics Using Excel
A practical guide for how to do statistical analysis in Excel plus free statistics software which extends Excel's b
...
Excel Tutorials

Chapter 1
RegressIt: Excel AddOn for Data Analysis
Performs multivariate descriptive data analysis and regression analysis with highquality table and chart output in
...
Excel Tutorials

Chapter 15
Monte Carlo Simulation with Excel
Short article from Real Statistics Using Excel web site described how to generate random numbers with functions and
...
Excel Tutorials

Chapter 8
SolverStat
SolverStat is an Excel addin (xla) that performs advanced statistical tests on least squares regression data.
Excel Tutorials

Chapter 15
Excel Exposure
As easy reference for Excel users of all skill levels helping you to develop and refine your skills, many free less
...
Excel Tutorials

Chapter 1
Logistic Regression Reference
Detailed reference from Real Statistics Using Excel, covers logistic regression AddIn.
Excel Tutorials

Chapter 14
ExcelJet
Learn data analysis with Excel from clear examples and bitesized videos.
Excel Tutorials

Chapter 1
ChiSquare and F Distributions
Excellent references for ChiSquare Test and ANOVA featuring Excel.
Excel Tutorials

Chapter 10
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.
Excel Tutorials

Chapter 10
Sampling with Excel
Short howto article from Real Statistics Using Excel web site.
Excel Tutorials

Chapter 6
Xelplus: Courses, Tutorials, and Instructional Videos
Succinct and clear Excel tutorials, see
YouTube Channel
.
Excel Tutorials

Chapter 1
Regression Analysis Output Explained
Page describes tables generated by Data Analysis Regression Tool in detail.
Excel Tutorials

Chapter 11
Linear Regression Reference
Real Statistics Using Excel shows how to conduct linear regression analysis, including advanced models.
Excel Tutorials

Chapter 11
Real Statistics Using Excel
A practical guide for how to do statistical analysis in Excel plus free statistics software which extends Excel's b
...
Excel Tutorials

Chapter 1
Over 18,000 Members!