Download Start Excel File: http:\/\/ift.tt\/2G3RUQv
\nDownload pdf Notes: http:\/\/ift.tt\/2H2WBuV
\nEntire Class Web Site: http:\/\/ift.tt\/2BjafuY<\/p>\n
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.
\nExcel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College \/ Mike Girvin at excelisfun Channel at YouTube Channel.
\nTopics in Video:
\n1. (00:01) Introduction
\n2. (01:35) What is Probability?
\n3. (05:51) What is a Frequency Distribution?
\n4. (07:07) How to use COUNTIFS Function (to Count with a Specific Condition)
\n5. (12:00) Example 1: Create a Frequency Distribution to Calculate Probabilities of Getting a Certain Grade in Math Class
\n6. (16:11) Example 2: Create a Frequency Distribution to Calculate Probabilities of Getting a Certain Grade in English
\n7. (18:04) Example 3: Create a Frequency Distribution to Calculate Probabilities for # of Banquet Room Use
\n8. (20:42) Example 4: Create a Frequency Distribution to Calculate Probabilities for What Type of Item Will Be Purchased
\n9. (23:13) ) Summary<\/p>\n
Next Video: 25 Excel & Business Math<\/p>\n