Completed
) Summary of video
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Statistical Analysis - AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Venn Diagrams
- 3 ) Single Condition Logical Test
- 4 ) NOT Logical Test
- 5 ) Complement Rule
- 6 ) Events and Logical Tests with Two Conditions, including AND and OR Logical Tests
- 7 ) Mutually Exclusive Events
- 8 ) OR Logical Test for Events that are Mutually Exclusive
- 9 ) OR Logical Test for Events that are NOT Mutually Exclusive
- 10 ) AND Logical Tests
- 11 ) ROWS function to count rows
- 12 ) FILTER Array Function to filter data sets based on OR Logical Tests and AND Logical Tests
- 13 ) COUNTIFS function to count with a Single Condition Logical Test and a NOT Logical Test
- 14 ) Complement Rule for Probability
- 15 ) COUNTIFS function to count with an AND Logical Test
- 16 ) FILTER and ROWS functions to count with an OR Logical Test, Mutually Exclusive Events and NOT Mutually Exclusive events
- 17 ) COUNTIFS function to count with an OR Logical , Mutually Exclusive Events and NOT Mutually Exclusive events
- 18 ) Summary of video
- 19 ) Closing and Video Links
