### Excel 2010 Statistics #34.5: Z-Score IF, Standard Deviation IF, Mean IF, Mode IF, Median IF

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm1. Calculate Numerical measure with criteria or a condition using array formulas.2. There is a built in function for Mean If: AVERAGEIF function3. For Standard Deviation, Mode, Median and Z-Score, you can use array formulas with the functions STDEV, MODE, MEDIAN and the IF Function.4. For the z-score, since it is a non-aggregate calculation, we can use VLOOKUP functions to calculate a z-score IF.5. See how to use Advanced Filter to extract a Unique List (list of elements) so that we can the make calculations Mean, Median, Mode, Standard Deviation and Z-score with CriteriaThis is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin

Length:
15:42