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

Posted on by Annie D

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

ExcelIsFunSun, February 20, 2022 6:22pm