Главная
Study mode:
on
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
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Mathematics #Statistics & Probability #Statistical Analysis
0:00 / 0:00
1 of 19

) Introduction