Busn 210, Excel Statistics for Business class taught by Excel MVP Mike Girvin at Highline College.
This is the intro video for matriculating students at Highline College in summer quarter, 2022.
To watch at YouTube here is the playlist: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN
Episode 2490:
The Android phone has had it for a long time, but the new Data From Picture has finally reached the Office Insiders beta channel on desktop Excel. Bill gives this new feature a spin with various pictures of data.
Table of Contents
(0:00) Speech Recognition 1989 to today
(1:10) From Picture near Power Query tools
(1:35) Creating data picture
(2:00) Data From Picture no gridlines
(3:40) Cleaning the results
(4:15) The numbers all match
(4:30) Gridlines don’t help
(5:35) Right-align headings
(7:20) Need to proof
(7:50) With real photo test 1
(8:40) From clipboard test 2
(10:03) This will improve
Buy the e-Book today: https://lnkd.in/gZMZMSYD
e-book out June 15. Physical book out Aug 1.
This is a preview of Michael “excelisfun” Girvin’s new 800 page Excel and Power BI book. Two years in the making. Every topic you ever wanted in Excel, PivotTables, Array Formulas, Data Analysis, Power BI Desktop and much more.
Download Excel File: https://excelisfun.net/files/EMT1793.xlsx
Learn how to determine if there are duplicates in a row.
Topics:
1. (00:00) Introduction
2. (00:09) Logical Formula to indicate if duplicates are in row. OR and COUNTIFS functions.
3. (03:02) Conditional Formatting to indicate if duplicates are in row. COUNTIFS function.
4. (05:54) Count Unique Items with UNIQUE and COLUMNS functions.
5. (06:45) Logical Formula to indicate if duplicates are in row. COLUMNS and UNIQUE functions.
6. (07:29) Count Unique Items with FREQUENCY, MATCH, COLUMN and SUM functions. Old School Formula.
7. (07:59) Summary
8. (08:20) Closing, Video Links
Isaac “Iceman” Girvin and his dad, Mike “Magic” Girvin (excelisfun at YouTube), ride at Jefferson Skate Park on Sunday, June 12, 2022.
The Boneless Ones Skate Punk Band Sond Back To The Grind pumps the action and creates rad!
Washington BMX / Skate Adventure 16.
Download Excel File: https://excelisfun.net/files/Ch14-ESA.xlsm Download 2 PDF note files: https://excelisfun.net/files/Ch14-ESA.pdf, Download Deductive Proof 1 PDF: https://excelisfun.net/files/Linear%20Regression%20Slope%20Deductive%20Proof.pdf Download Deductive Proof 2 PDF (short version): https://excelisfun.net/files/Linear%20Regression%20Slope%20Deductive%20Proof-Shorter.pdf
Learn about the 12 important calculations for Linear Regression: Covariance, Correlation, Slope, Y Intercept, Sum of Squares Total = SST, Sum of Squares Regression = SSR, Sum of Squares Error (Residual) = SSE, R Squared = Coefficient of Determination, Mean Square Error, Standard Error of Estimate, p-value for F. See many diagrams, pictures and animations to help make the complicated math easy to understand.
Download Excel File: https://excelisfun.net/files/EMT1792.xlsx
Learn how to create a report that lists a unique list of case sensitive items with the frequency for each.
Learn how to create an Expandable Range in a Spilled Array Formula:
1. (00:00) Introduction
2. (00:49) Power Query Solution. Learn that Power Query is case sensitive by default and that the Group By feature makes the task easy.
3. (02:04) Dynamic Spilled Array Formula Solution. See the powerful Array Functions: BYROW, LAMBDA, LET, VSATCK, HSTACK, INDEX and more.
4. (05:45) Expandable Range in a Spilled Array Formula using BYROW, LAMBDA and INDEX functions.
5. (11:04) Test Solution with Continue reading “Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792”
Mike “Magic” Girvin (excelisfun at YouTube) rides at Greenlake Park on Sunday, May 29, 2022. Washington BMX Old Guy Adventure 15.
This video is all about the Excel function for WORKDAY.INTL. It allows you to make sure that you are always scheduling an event to occur on a Saturday, or Tues/Thurs or Friday.
The secret here is the alternate syntax for the Weekend argument.
Table of Contents
(0:00) Find a particular Saturday in Excel
(0:25) WORKDAY introduction
(1:37) Find a particular Saturday in Excel
(2:32) Find the next Tuesday
(5:02) Find next Tuesday or Thursday
(5:46) Handling holidays
(6:58) Wrap-up
Download Excel File: https://excelisfun.net/files/Ch09-ESA.xlsm Download 2 PDF note files: https://excelisfun.net/files/Ch09-ESA.pdf, Ch09-ESA-JustFormulas.pdf
Learn about how to use the NORM.S.DIST and NORM.S.INV Excel functions to run a hypothesis test for a proportion.
Topics:
1. (00:00) Introduction
2. (00:21) Hypothesis Testing for Proportion (Binominal) using Normal Curve. Student knowledge of presidential election example. See NORM.S.DIST and NORM.S.INV Excel functions.
3. (07:11) Summary of video, Closing, Next Video and Video Links
Download Excel File: https://excelisfun.net/files/Ch09-ESA.xlsm Download 2 PDF note files: https://excelisfun.net/files/Ch09-ESA.pdf, Ch09-ESA-JustFormulas.pdf
Learn about Two Tail Hypothesis Test with t Distribution. Learn about the Excel worksheet functions T.DIST, T.DIST.2T, T.INV, T.INV.2T
Topics:
1. (00:00) Introduction
2. (00:21) Two Tail Test with t Distribution from point of view of Seattle Used Auto Dealers
3. (02:30) Formulas for calculations from sample data
4. (04:04) Calculate p-value using the T.DIST function or T.DIST.2T function
5. (06:22) Calculate critical value using the T.DIST function or T.INV.2T function
6. (08:40) Summary of video, Closing, Next Video and Video Links
Download Excel File: https://excelisfun.net/files/Ch09-ESA.xlsm Download 2 PDF note files: https://excelisfun.net/files/Ch09-ESA.pdf, Ch09-ESA-JustFormulas.pdf
Learn about 1 Tail Lower (Left) Hypothesis Test with t Distribution. Learn about the Excel worksheet functions T.DIST and T.INV
Topics:
1. (00:00) Introduction
2. (00:24) 1 Tail Lower (Left) Test with t Distribution from point of view of a Construction company that wants to decide if a new building technique is faster than an older technique
3. (02:46) Formulas for calculations from sample data
4. (04:20) Calculate p-value using the T.DIST function
5. (05:04) Calculate critical value using the T.INV function
6. (07:28 Closing, Next Video and Continue reading “Excel Statistical Analysis 47: Hypothesis Testing with T Distribution, 1 Tail Lower (Left) Test”