Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

ExcelIsFun via YouTube

Overview

Dive into a comprehensive 29-minute video tutorial on Excel statistical analysis, focusing on AND, OR, and NOT logical tests for COUNTIFS and FILTER functions. Explore Venn diagrams, single condition and multiple condition logical tests, mutually exclusive events, and the complement rule. Learn to use ROWS, FILTER, and COUNTIFS functions for various counting scenarios, including single condition, NOT logical tests, AND logical tests, and OR logical tests for both mutually exclusive and non-mutually exclusive events. Apply these concepts to probability calculations and data filtering. Gain practical skills through step-by-step demonstrations and explanations, concluding with a summary of key points covered.

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

Reviews

Start your review of Excel Statistical Analysis - AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.