Excel 2010 Statistics #34: Data Analysis Add-in Descriptive Statistics tool

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Use the Data Analysis Add-in Descriptive Statistics tool to quick calculate Numerical descriptive statistics like, Mean, Median, Mode, Standard Deviation, Range. Min, Max This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin


About this tutorial: Video duration: 12:52 Download File: See how to use the different percentile and quartile functions in Excel:: 1. (00:11) What is a percentile? 2. (00:47) Difference between PERCENTILE.EXC and PERCENTILE.INC functions AND the difference between the QUARTILE.EXC and QUARTILE.INC functions. 3. (2:30) Algorithm for calculating position of item in list for .EXC […]

Lecture 2 | Motivation of Resampling | Machine Learning Resampling Methods by Dr. Ahmad Bazzi

About this tutorial: Video duration: 1:14:18 Lecture 2 of this course entitled “Machine Learning Resampling Methods” will serve as a transition from the review of statistics we did in Lecture 1 to the world of resampling, bootstrapping and Monte Carlo. Along the way, we shall demonstrate some important examples on R studio. The outline is […]

Logit and probit

About this tutorial: Video duration: 8:53 Currell: Scientific Data Analysis. Excel analysis for Fig 8.22 © Oxford University Press

How to make box plots in Microsoft Excel

After you create the array of the 5 statistics the plot sequence is: 1. select the array of the 5 statistics as shown in the video 2. select insert and then line plot 3. select the first type in the second row of line plot types 4. select “switch row-column” 5. then right click on […]

How To… Create a Random Sample in Excel 2016

About this tutorial: Video duration: 3:23 When you need to select a random data sample from a larger group or population, you can use Excel to generate the sample and avoid any bias in your sampling technique. In this short video you will learn how to select a sample of 10 from a population of […]

Testing for Outliers in Excel – Single Variable Sample

About this tutorial: Video duration: 3:45 Example of how to use Excel to check for official outliers in a sample consisting of a single variable, e.g., several measurements of a singly quantity like pressure or voltage, etc. The modified Thompson tau technique is used.

DAX Fridays! #95: Binning, Frequency and relative frequency | Data profiler

About this tutorial: Video duration: 17: This is the first of a series of videos about data profiling and descriptive statistics. In today’s video, I will show you how to bin data, calculate the frequency and relative frequency using DAX. What you think about the series? let me know in the comment box. Download file […]

Get Descriptive Statistics in Excel with Data Analysis Toolpak

About this tutorial: Video duration: 4:25 Generate a table of descriptive statistics in Excel for Windows and Excel 2016 for the MAC with the Data Analysis Toolpak Addin Incoming search terms:setting excel up for descriptive statistics

Create a Frequency Table and Chart

About this tutorial: Video duration: 9:13 Check out my Blog: How to create a frequency table/chart with the COUNTIF function and using PivotTables #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel

MS Statistics for development with ceaser Part 1

About this tutorial: Video duration: 14:24

How to Make a Histogram in Excel 2016 for Mac

About this tutorial: Video duration: 4:58 This video demonstrates how to make a histogram from a frequency table in Excel. The data set used in this exercise can be downloaded here:

How To… Forecast Using Exponential Smoothing in Excel 2013

About this tutorial: Video duration: 6:22 Learn how to use exponential smoothing to forecast future needs in Excel 2013 for Time Series Analysis. Exponential Smoothing forecasts demand in the next time period by taking into account the actual demand in the current period and the forecasted demand for the current time period. Please visit (and […]

Plot 95% Confidence Interval.mp4

About this tutorial: Video duration: 4:51 Two 95% confidence intervals are plotted on a single graph. The two confidence intervals overlap. This means that at the 95% level of confidence, there is not sufficient evidence that the population means are different.

A Vision of Students Today

About this tutorial: Video duration: 4:45 a short video summarizing some of the most important characteristics of students today – how they learn, what they need to learn, their goals, hopes, dreams, what their lives will be like, and what kinds of changes they will experience in their lifetime. Created by Michael Wesch in collaboration […]

Making a Simple Bar Graph in Excel

About this tutorial: Video duration: 5:14 This demonstration shows you how to create a simple bar graph in Excel. This demonstration corresponds to the Introduction to Statistics, Think & Do textbook by Scott Stevens (

Getting Started With JMP 12: Basic Statistics

About this tutorial: Video duration: 24:34 Learn how to perform basic statistical analyses in JMP. See how to use Distribution to analyze data one variable at a time, using Fit Y by X for analyses involving two variables and using Fit Model for analyses involving more than two variables. Learn about tools for summarizing and […]

Readability Statistics Tutorial – Microsoft Word 2016 / 2013

About this tutorial: Video duration: 2:20 My first tutorial! This is a little known trick in the Microsoft community. Enable the statistics once and you won’t need to re-enable! I hope this helps as I think it’s very important to curtail your message to the capability of your audience so you don’t lose them. Enjoy […]

Excel 2010 – Creating Pivot Charts

About this tutorial: Video duration: 6:36 A tutorial showing how to create and format a Pivot Chart object from a Pivot Table in Excel 2010

How to Use Statistical Functions for Forecasting in Microsoft Excel 2016 – Part 1

About this tutorial: Video duration: 12:40 Get the complete 9-hour Excel 2016 Advanced course here ► During this Microsoft Excel 2016 advanced training tutorial video, we will cover the statistical functions for forecasting. We will show examples using the functions SLOPE and INTERCEPT, FORECAST.LINEAR, and TREND. We will also explain what are independent and dependent […]