Law Class Excel #3: Statistics For Age Discrimination Case - Jessica's Law 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.

[richardkinzer]

I liked this 3 vid series as much as anything you've done, Mike. I've recommended that my new Excel students watch this. I, personally, have a pretty thorough understanding of Excel, but have never seen a better explanation of SD. I know explaining SD wasn't your intent, but I have really benefited from that inadvertent lesson.

I really enjoy your light hearted style of presentation! What a pro!

[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...

[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]

EXCELlent!!!

[hethuszar01]

Nice.

Please change the title. It is #3 and not #2.

Zsolt

[ExcelIsFun]

Thanks for the heads up!