Download Start Excel File: http://ift.tt/2G3RUQv
Download pdf Notes: http://ift.tt/2H2WBuV
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to use the COUNTIFS Function and the Part / Base Formula (Rate Formula) to create a Frequency Distribution with Probabilities (Relative Frequencies) that we3 can use to estimate the likelihood of an event in the unknown future.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (01:35) What is Probability?
3. (05:51) What is a Frequency Distribution?
4. (07:07) How to use COUNTIFS Function (to Count with a Specific Condition)
5. (12:00) Example 1: Create a Frequency Distribution to Calculate Probabilities of Getting a Certain Grade in Math Class
6. (16:11) Example 2: Create a Frequency Distribution to Calculate Probabilities of Getting a Certain Grade in English
7. (18:04) Example 3: Create a Frequency Distribution to Calculate Probabilities for # of Banquet Room Use
8. (20:42) Example 4: Create a Frequency Distribution to Calculate Probabilities for What Type of Item Will Be Purchased
9. (23:13) ) Summary
Next Video: 25 Excel & Business Math