Completed
) FILTER Array Function to filter data sets based on OR Logical Tests and AND Logical Tests
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
