Channel: ExcelIsFun

Category: Education

Tags: business statistical analysisdata analysisinclude argument in filter functionfilter array functionnot logical testcountifs functionhighline collegeexcel statisticsmike girvinand logical testmutually exclusiveor logical testunion of two eventsrows functionmicrosoft 365 excelintersection of two eventsbusn 210mike excelisfun girvincomplement rulestatistical analysisexcelisfunexcel statistical analysisvenn diagramchapter 4

Description: Download Excel File: excelisfun.net/files/Ch04-ESA.xlsm pdf notes: excelisfun.net/files/Ch04-ESA.pdf Learn about the basics of Logical Tests: AND, OR and NOT. Lean how to count based on logical tests using COUNTIFS, FILTER and ROWS functions. Topics: 1. (00:00) Introduction 2. (00:41) Venn Diagrams 3. (01:11) Single Condition Logical Test 4. (01:52) NOT Logical Test 5. (02:05) Complement Rule 6. (02:44) Events and Logical Tests with Two Conditions, including AND and OR Logical Tests 7. (04:52) Mutually Exclusive Events 8. (05:22) OR Logical Test for Events that are Mutually Exclusive 9. (06:35) OR Logical Test for Events that are NOT Mutually Exclusive 10. (08:06) AND Logical Tests 11. (09:32) ROWS function to count rows 12. (09:58) FILTER Array Function to filter data sets based on OR Logical Tests and AND Logical Tests 13. (09:23) COUNTIFS function to count with a Single Condition Logical Test and a NOT Logical Test 14. (22:23) Complement Rule for Probability 15. (23:19) COUNTIFS function to count with an AND Logical Test 16. (24:25) FILTER and ROWS functions to count with an OR Logical Test, Mutually Exclusive Events and NOT Mutually Exclusive events 17. (25:44) COUNTIFS function to count with an OR Logical , Mutually Exclusive Events and NOT Mutually Exclusive events 18. (28:02) Summary of video 19. (28:28) Closing and Video Links