Excel & Business Math 24: COUNTIFS Function & Part/Base for Probabilities & Frequency Distributions

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

[dramjl]

I have no problem with audio, its working perfectly fine for me. You are awesome thanks for sharing your knowledge.

[DougHExcel]

Likelihood the this is another great video = HIGH!

[ismailismaili]

actually Probability is really so powerful especially in statistics thank you so much Mr. Mike looking forward the next video

[mohamedchakroun]

Countifs is one of the most and main useful function i love it

[deedubdolphinsdialogue]

Good tips! You always explain it well!

[karimmansour]

Thanks a lot ...really as we said: give the cook to the chief ... difficult object, but you are Sir make it very easy.

[markdayphotography]

Hi Mike, Is it possible to use the COUNTIFS function when looking for data on a separate sheet of the same workbook? If so, how is this done, as I can only seem to use the COUNTIFS function on the same worksheet? Many thanks, Mark

[AnikSikderBlog]

Hello sir,
I'm your big fan. I always try to stay with ExcelIsFun.

Recently I'm in a trouble. and I personally trust that only you can help me out.

I wanna give admin authority to my workbook for access all sheets. Prompt login at starting and keep login/out details. For other normal user can see only one sheet.

So I hope you must help me.
Love you & keep going.

[SynistrCarter]

@ExcellsFun Is it possible to determine an argument if E2 is 50% of F2 to color format E2 for column E?

[simfinso]

sir please make video on FRM financial Risk Management Basic & Advanced ( stddev *norminvers (5%)) it is new demanding area in India...

[Giggidygiggidy]

Could you redo the audio? I had to turn it all the way up on my headphones to hear you, and my hearing is normal