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.
About this tutorial: Video duration: 2:26 This is how you find the 95% confidence interval in Excel
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 […]
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
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 […]
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 […]
About this tutorial: Video duration: 8:53 Currell: Scientific Data Analysis. Excel analysis for Fig 8.22 © Oxford University Press
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 […]
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 […]
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.
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 […]
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
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
About this tutorial: Video duration: 14:24
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:
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 […]
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.
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 […]
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 (