(00:00) Start, (00:04) Nick Roth ride, (00:3) Nathon Ride, (00:53) Magic ride (excelisfun), (01:23) Isaac “Iceman” Girvin ride. Blue Grass Music Played throughout : )
Two Old Guys on BMX Bikes: Mike āMagicā Girvin (excelisfun at YouTube) and Nick āRad 68ā Roth. Two Young Dudes on Skateboards: Isaac āIcemanā Girvin and Nathon.
Washington BMX Old Guy Adventure 14.
Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about the Normal (Bell) Probability Distribution and the Excel worksheet functions to calculate probability and x values: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV.
Topics:
1. (00:00) Introduction
2. (00:22) pdf notes: characteristics of Normal Bell Probability Distribution.
3. (04:40) pdf notes: Math Formulas for Normal (Bell) Probability Distribution
4. (05:14) pdf notes: X values or Z-score (Standard Value)?
5. (05:50) pdf notes: notes on Excel Functions for Normal (Bell) Probability Distribution: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV
6. (08:49) pdf notes: Professor observes a bell shape (normal) distribution.
7. (09:07) pdf notes: 3 Types of Probability Calculations: Continue reading “Excel Statistical Analysis 32: Bell Curve Functions: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV”
Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about the formulas and calculating probabilities for the Uniform Probability Distribution.
Topics:
1. (00:00) Introduction
2. (00:23) Understanding what a Uniform Distribution is and how it is related to the data behind it.
3. (02:36) Formulas for Uniform Distribution
4. (05:22) Paper Example for Waiting Times on Customer Service Phone Calls
5. (07:11) Excel Example for Waiting Times on Customer Service Phone Calls
6. (12:16) Golf Example using Excel Formulas
7. (14:40) Summary of video
8. (14:58) Closing and Video Links
Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about Continuous Probability Distributions.
Topics:
1. (00:00) Introduction
2. (00:20) Compare Discrete Probability Distributions to Continuous Probability Distributions
3. (05:05) Continuous Probability Distributions Density Function to calculate the height of plotted curve of continuous probability distributions
4. (05:56) Integral Calculus or Excel functions to calculate the area under the curve, or probability
5. (07:03) Three examples of Normal, Uniform and Exponential Distributions.
6. (08:26) The distributions we learn about in this chapter use population data, not sample data.
7. (08:57) Next Video, Closing and Video Links
Download Excel File: https://excelisfun.net/files/EMT1791.xlsx
Learn three important lookup formula tricks: Lookup Last Item, Lookup First Item, Lookup and Return All Matching Records.
Topics:
1. (00:00) Introduction
2. (00:13) Product Lookup Table
3. (00:46) Lookup First using XLOOKUP function (Microsoft 365 = New School)
4. (01:38) Lookup Last using XLOOKUP function (Microsoft 365 = New School)
5. (02:29) Lookup All Matching Records using FILTER function (Microsoft 365 = New School)
6. (03:32) Lookup First using VLOOKUP function (Any Version of Excel)
7. (04:18) Lookup Last using LOOKUP function and Array Operation (Any Version of Excel)
8. (06:11) Lookup All Matching Records using Complicated Array Formula (Any Version Continue reading “XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791”
Uncle S is trying to have a formula copy to new rows. So a table seems like a great way. But he also has merged cells and the table unmerges those.
In this video, two surprising Table tricks:
First, a table can contain Center Across Selection, which is better than Merging Cells in Excel.
Second, a surprising discovery from the Excelforo channel about new headings in a table.
Table of Contents
(0:00) Auto-copying formulas to new rows in Excel
(2:31) Can a table have a merged cell
(4:00) New table columns using custom lists in Excel
Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch05-ESA.pdf
Learn about Hypergeometric Distribution and HYPGEOM.DIST Function to calculate AND Logical Test probabilities for when you have Conditional Probabilities Across a Fixed Number of Trials.
Topics:
1. (00:00) Introduction
2. (00:30) AND Logical Test with Conditional Probabilities for Pulling Two Straight Queens in Two Tries. Long Hand Formula
3. (04:55) HYPGEOM.DIST Function to calculate AND Logical Test probabilities for when you have Conditional Probabilities Across a Fixed Number of Trials. For Hypergeometric Distribution
4. (06:35) Pulling 2 Queen Cards in Five Tries Probability from sample points and with HYPGEOM.DIST function
5. (09:01) HYPGEOM.DIST Continue reading “Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials”
You have a pivot table in Excel. The months and weekday names are appearing alphabetically instead of in calendar sequence. This happens when your pivot table is based on external data or the data model.
There are two solutions. This video prefers using the Custom Sort Order option. This takes 8 clicks to fix the months and 8 clicks to fix weekdays.
If your Pivot Table Slicers are in the wrong sequence, then you should use the Data Model setting to sort one column by another column.
Pictures and videos of epic trip that Magic (Dad) and Iceman (Son) took to Oakland to see pro skateboard contest and skate-punk band Boneless Ones Music Video Shoot.
Download Excel File: https://excelisfun.net/files/EMT1790.xlsx
Learn how to convert improper dates (text or YYYMMDD dates) into proper serial number dates.
Topics:
1. (00:00) Introduction
2. (00:19) Worksheet Formula Method, TEXT function
3. (01:18) Text To Columns Method
4. (02:34) Power Query Method
5. (03:41) Summary, Closing, Video Links
Ronak asks: How can I use Excel to find out how many weekedays per month for the whole year?
This video shows how to do it using SEQUENCE, TEXT and a quick pivot table in Excel.
Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch05-ESA.pdf
Learn about the Poisson Distribution and how to calculate probabilities using the POISSON.DIST function.
Topics:
1. (00:00) Introduction
2. (00:22) Data for arrivals at Dickās Hamburgers restaurant
3. (01:05) Poisson Distribution Characteristics and requirements
4. (03:36) Poisson frequency Distribution pattern
5. (04:35) POISSON.DIST function
6. (08:22) Plot a Poisson Distribution on an Excel Column Chart
7. (09:31) Examples of when you can use Poisson Distribution, kike Waiting and stretches of road
8. (11:02) Poisson Math Formula
9. (11:20) The number e
10. (11:40) EXP worksheet function to calculate the number e
11. (12:20) POISSON.DIST function for the Dickās Hamburgers Continue reading “Excel Statistical Analysis 28: Poisson Distribution, POISSON.DIST function and Poisson Column Chart”