Excel Statistical Analysis 17: AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions

Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm pdf notes: https://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