Reset an Excel Spreadsheet – Delete your data but not your formulas

About this tutorial: Video duration: 1:53 The “Constants” option in Excel’s Go To command let you select just the cells that don’t contain formulas. That gives you an easy way to reset a spreadsheet so it’s ready to use for a new month or year.

95% Confidence Interval Excel 2016

About this tutorial: Video duration: 2:26 This is how you find the 95% confidence interval in Excel

How to Get Statistical Reports in Outlook

About this tutorial: Video duration: 4:17 This tutorial shows how to get statistical reports and Excel charts on Outlook emails.

How to Make a Bar Chart (Bar Graph) in Excel 2016 for Windows

About this tutorial: Video duration: 4:20 This video describes how to make a bar chart in Excel 2016 for Windows. It assumes you know how to make a frequency table in Excel, which is necessary for making a bar chart. For a video on how to make a frequency table, see Incoming search terms:www bing […]

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 Incoming search terms:HelloWORLDhttps://products office com/en-US/compare-all-microsoft-office-products?&ocid=PROD_OfficeCom-PWA-0_BuyButton_Unknown_BuyOffice365&activetab=tab:primaryr2

Excel Magic Trick 1207: PERCENTILE.EXC, PERCENTILE.INC, QUARTILE.EXC, QUARTILE.INC Functions

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 (