Law Class Excel #3: Statistics For Age Discrimination Case - Jessica's Law Class

Learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical evidence in an Age Discrimination Case. Calculate the Mean, Standard Deviation, Minimum Value, Maximum Value. Jessica Neilson Law Class

Category:

Education

Tags:

• Excel
• Law
• AVERAGE
• STDEV
• MAX
• MIN
• SUM
• function
• statistical
• evidence
• Statistics
• Age
• Discrimination
• Case
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Jessica
• Neilson
• Class

[emailuznow]

Mike you are awesome

Can you do a video on how to make your data presentable and fancy please.

I love the way you have shaded boxes on the statiscal summary. I can't seem to figure it out on how you managed give it that 3D effect.

You are the best

[ExcelIsFun]

I will make a video on 3D effect soon, but in the meantime, watch these videos I have on stylistic formatting:

Excel Magic Trick #150 Formatting Guidelines (Eye Candy)

Excel Basics #12: Stylistic & Number Formatting

[icantloose]

This is good stuff thanks

[ExcelIsFun]

You are welcome. If you like Statistics and Excel videos, I have about 150 videos posted. Search for "Excel Statistics".

[08505excel]

Not sure what the value of the statement that he falls within 1 std deviation from the mean really conveys. Since he is in the 2nd quartile wouldn't the statement that at least 50% of the population sold less units than him be a more convincing argument than saying he is within 68% of population?

[ExcelIsFun]

Yes that is an EXCELlent point to make in any argument presented!

If you want to learn about what Standard Deviation means see my response in the previous comment.

[ExcelIsFun]

EXCELlent!!!

[richardkinzer]

@ExcelIsFun yikes!, I'll have to put aside some quite moments to digest those. Mikey, you are thorough if nothing else. I have learned so much by following you.

[ExcelIsFun]

If explanation of SD is what you want, the complete story are in these videos:

Excel & Statistics 39: Variability Chart - Visual Approach (Dispersion or Spread)

Excel & Statistics 40: Range & Interquartile Range (Variability)

Excel & Statistics 41: Sample Standard Deviation (Variability)

Excel & Statistics 42: Coefficient of Variation

Excel & Statistics 45: Z-Score (# Standard Deviations From Mean)

Excel & Statistics 47: Empirical Rule (Bell Shaped Curve)

more...