Excel Lecture Videos
Dr. Valenzuela (Ph.D.)
Using Excel in Statistics
Please watch the videos listed below videos on using Excel for Statistics. All the videos have a Closed Caption option on the bottom right of the video that you can use for the on-screen transcripts
Use the below video to learn about developing graphs and charts in Excel
Excel Charts & Graphs: Learn the Basics for a Quick Start
Use the below video to learn about Advanced Graphs in Excel
Advanced Graphs - Excel for Advanced - Lesson 4
Use the below video on using the Data Analysis tool in Excel for mean, median, mode, etc.
https://www.youtube.com/watch?v=4lAvbp-yVs8
Use the below video on how to add the Data Analysis tool to Excel
https://www.youtube.com/watch?v=mIoS7IRo36c
Getting Started with Excel - Videos by Dr. Valenzuela
Use the below video on creating a Frequency Distribution in Excel
https://youtu.be/asEuFvWGJDs
Use the below video to create a Histogram in Exel
https://youtu.be/53DOu_vstvI
Use the below video to develop a Box Plot in Excel
Creating a Boxplot in Excel 2016
Use the below video on doing percentiles in Excel
Percentiles in Excel 2016
Use the below video to learn about correlation and regression with Excel
Correlation and Regression in Excel 2016
Use the below video to learn how to do Normal Distribution problems with Excel
How to Use Excel's Normal Distribution Function =NORM.DIST and =NORM.INV
Use the below video to learn how to do Binomial Probabilities in Excel
How to Calculate Binomial Distribution Probabilities in Excel 2016
Use the below video to learn how to do a Stem and Leaf Plot with Excel
Create a Basic Stem and Leaf Plot
Use this video to learn how to use Excel for Cumulative Frequency and Relative Frequency
Excel Cumulative Frequency and Relative Frequency
The below videos will help you understand Hypothesis Testing
Intro to Hypothesis Testing in Statistics - Hypothesis Testing Statistics Problems & Examples
Null and Alternate Hypothesis - Statistical Hypothesis Testing - Statistics Course
The below videos will show you how to do a two sample t-test with Excel
Hypothesis test for 2 Population Means using Excel's Data Analysis
How to do a two sample t test paired two sample for means in Excel 2013
The below video will show you how to use P-values in Excel for Hypothesis Testing
How to do a Two Sample (Independent) t-Test in Excel 2016 (Mac and Windows)
The below video will show you how to do a One Sample Z test with Excel
One Sample Z-Test in Excel
The below video will show you how to use Hypothesis Testing with Excel
Hypothesis testing in excel