Basic Excel Business Analytics #21: AVERAGE, MEDIAN, MODE.MULT functions & PivotTable Mode

Review the reasons why have three average calculations:
1) (00:11) Mean, Median, Mode = Average = One number that represents all the data points = A measure of central tendency.
2) (00:40) Mean to get a typical value. Add them up, Divide by the count. Use AVERAGE function.
3) (01:26) Median to get a typical value. The middle value in a sorted list. Median is the calculations to make if there are extreme values. Use MEDIAN Function.
4) (03:01) Mode to get a typical value for quantitative or categorical data. Finds the item that occurs most frequently. MODE.SNGL is for number data (quantitative data) and will find the mode when there is a single mode.
5) (04:18) If distribution is symmetrical Mean = Median = Mode.
6) (04:31) PivotTable and Sort feature to find the Mode for Categorical Data.
7) (06:29) MODE.MULT Array Function for number data (quantitative data) when there are multiple modes. This is an Array Function that requires the special key stroke: Ctrl + Shift + Enter. See Two Examples.

Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.

[farid]

I cannot believe you are displaying the whole course for free! I have been subscribed with you for a long time now and I tend to see your videos every time I need a reference or understand how some excel formulas work. I am extremely interested in analytics and seeing them on excel it is just amazing.

Thanks for everything!

[paulsingleton]

Hi Mike, when using MODE.SNGL in Office beta how would you use this to report on a column of (monthly) data where the values increase day by day but ignores days of the month that have not yet occurred. I would still want to capture "0" if it is recorded. Thank you 🙂👍

[ismailismaili]

i love this so much thank you it's fan