Excel Statistical Analysis - AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions
ExcelIsFun via YouTube
Overview
Syllabus
) Introduction.
) Venn Diagrams.
) Single Condition Logical Test.
) NOT Logical Test.
) Complement Rule.
) Events and Logical Tests with Two Conditions, including AND and OR Logical Tests.
) Mutually Exclusive Events.
) OR Logical Test for Events that are Mutually Exclusive.
) OR Logical Test for Events that are NOT Mutually Exclusive.
) AND Logical Tests.
) ROWS function to count rows.
) FILTER Array Function to filter data sets based on OR Logical Tests and AND Logical Tests.
) COUNTIFS function to count with a Single Condition Logical Test and a NOT Logical Test.
) Complement Rule for Probability.
) COUNTIFS function to count with an AND Logical Test.
) FILTER and ROWS functions to count with an OR Logical Test, Mutually Exclusive Events and NOT Mutually Exclusive events.
) COUNTIFS function to count with an OR Logical , Mutually Exclusive Events and NOT Mutually Exclusive events.
) Summary of video.
) Closing and Video Links.
Taught by
ExcelIsFun