Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples)

preview_player
Показать описание
Topics in this video:
1. (00:13) Discuss Handwritten notes for Adding Laws For Probability and cover the terms: Venn Diagram, Complement, Union, Intersection.
2. (08:25) Excel: Counting for AND Events use COUNTIFS with Two Criteria
3. (09:40) Excel: Counting for OR Events that are Mutually Exclusive use multiple COUNTIFS with One Condition/Criteria and simply add them. P(A OR B) = COUNTIFS(range,A)+COUNTIFS(range,B).
4. (11:23)Excel: Counting for OR Events that are NOT Mutually Exclusive use multiple COUNTIFS with One Condition/Criteria and simply add them, then subtract a COUNTIFS with AND Criteria. P(A OR B) = COUNTIFS(range,A)+COUNTIFS(range,B) – COUNTIFS(rangeA,A,rangeB,B).
5. (15:26) Compliment Rule
6. (16:30) Adding Probabilities from Frequency Distribution
7. (17:38) Adding Probabilities from Cross Tabulated Table with % of Grand Totals (Joint Probability Table)
8. (21:32) Frequency Distributions contain Mutually Exclusive categories. Examples of OR Events and Complement Events
9. (22:57) Adding events that are not Mutually Exclusive when you have just the Marginal and AND (Joint) probabilities. How to add when you don’t have original data set, a frequency distribution or a Cross Tabulated Table.
  1. excelisfun
  2. Excel 2013
  3. Statistical Analysis
  4. Excel Statistics
  5. Highline College
  6. Business and Economic Statistical Analysis
Рекомендации по теме
Excel 2013 Statistical 0:25:27

Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples)

Excel Statistical Analysis 0:32:04

Excel Statistical Analysis 27: Binomial Probability Distributions. BINOM.DIST.RANGE Function & C...

Excel 2013 Statistical 0:33:18

Excel 2013 Statistical Analysis #28: Multiplication Law of Probability AND Events (16 Examples)

Excel 2013 Statistical 0:17:29

Excel 2013 Statistical Analysis #67: Hypothesis Testing for Population Differences Sigma NOT Known

Office 2013 Class 0:13:18

Office 2013 Class #27: Excel Basics 09: Keeping Data in Excel: Proper Data Set or Excel Table

Highline Excel 2013 0:21:36

Highline Excel 2013 Class Video 27: How To Track Down Excel Formula Errors (16 Examples)

Excel 2013 Statistical 0:09:52

Excel 2013 Statistical Analysis #64: Confidence Interval for Population Differences Sigma Known

Excel 2013 Statistical 0:07:02

Excel 2013 Statistical Analysis #15: Create Dot Plot in Excel Using COUNTIFS and REPT functions

Basic Excel Business 0:29:49

Basic Excel Business Analytics #27: Clean & Transform Data: Formulas, Flash Fill, Power Query, T...

Excel 2013 Statistical 2:22:43

Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)

Excel 2013 Statistical 0:20:17

Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, Ratio

Excel 2013 Statistical 0:19:41

Excel 2013 Statistical Analysis #36: Dynamic Binomial Probability Charts (3 Examples)

Excel 2013 Statistical 0:30:11

Excel 2013 Statistical Analysis #72: Chi-Square Test For 2 or More Population Proportions (Formulas)

Excel 2013 Statistical 0:41:36

Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable

Excel 2013 Statistical 0:19:22

Excel 2013 Statistical Analysis #24: Numerical Measures: Covariance and Correlation Coefficient

Excel 2013 Statistical 0:20:48

Excel 2013 Statistical Analysis #68: Matched/Paired Samples Population Differences Sigma NOT Known

Excel 2013 Statistical 0:09:01

Excel 2013 Statistical Analysis #37: Introduction to Continuous Probability Distributions

Excel 2013 Statistical 0:06:30

Excel 2013 Statistical Analysis #29: Create Joint Probability Table from Raw Data & Calc Event P...

Excel 2013 PowerPivot 0:53:02

Excel 2013 PowerPivot Basics #10: CALCULATE function to Change Filter Context (14 Examples)

Excel 2013 Statistical 0:24:08

Excel 2013 Statistical Analysis #39: Probabilities for Normal (Bell) Probability Distribution

Excel 2013 Statistical 0:33:32

Excel 2013 Statistical Analysis #06: Frequency Distributions & Column Charts, Categorical Variab...

Excel 2013 Statistical 0:18:37

Excel 2013 Statistical Analysis #12: Cross Tabulation & Charts For Two Variables, Simpson’s Para...

Excel 2013 Statistical 0:38:09

Excel 2013 Statistical Analysis #53: 5 Steps Hypothesis Testing: P-value & Critical Value Method...

Office 2013 Class 0:06:23

Office 2013 Class #25: Excel Basics 07: What Excel Does: Calculations and Data Analysis

Комментарии
Автор

Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples)
Topics in this video:
1. (00:13) Discuss Handwritten notes for Adding Laws For Probability and cover the terms: Venn Diagram, Complement, Union, Intersection.
2. (08:25) Excel: Counting for AND Events use COUNTIFS with Two Criteria
3. (09:40) Excel: Counting for OR Events that are Mutually Exclusive use multiple COUNTIFS with One Condition/Criteria and simply add them. P(A OR B) = COUNTIFS(range, A)+COUNTIFS(range, B).
4. (11:23)Excel: Counting for OR Events that are NOT Mutually Exclusive use multiple COUNTIFS with One Condition/Criteria and simply add them, then subtract a COUNTIFS with AND Criteria. P(A OR B) = COUNTIFS(range, A)+COUNTIFS(range, B) – COUNTIFS(rangeA, A, rangeB, B).
5. (15:26) Compliment Rule
6. (16:30) Adding Probabilities from Frequency Distribution
7. (17:38) Adding Probabilities from Cross Tabulated Table with % of Grand Totals (Joint Probability Table)
8. (21:32) Frequency Distributions contain Mutually Exclusive categories. Examples of OR Events and Complement Events
9. (22:57) Adding events that are not Mutually Exclusive when you have just the Marginal and AND (Joint) probabilities. How to add when you don’t have original data set, a frequency distribution or a Cross Tabulated Table.

excelisfun
Автор

May I ask which textbook are you referring to? I understand it is needed for the class which I am not taking, and I really like the hand-written *.pdf-s, but still I think it's a good thing to have a textbook too. There are so many textbooks on statistics and I am completely lost there. Could you please, recommend me one that is suitable for self-studying?

vaniad
Автор

I think it is a wrong calculation.IF it is not mutually exclusive we should multiplied each other for exam 0.4*0.3=0.12 and it is should be subtracted from 0.7-0.12=0.58

elnuralim