Descriptive Statistics in Excel Mean, Median, Mode, Std. Deviation,...

How to obtain Mean, Median, Mode, Variance, Standard deviation, ... in Excel using the Data Analysis Add in.
How to install Data Analysis Toolpak in Excel: • How to install Data An...

[@graciouslybusisiwe248]

i am a beginner in data analysis, thank you for making my life better sir, u didn't frustrate or confuse me it was short and well explained.

[@Digital_productsmoney]

I agree he makes it very easy to understand, i am a beginner too😊

[@MichaellaSmithhhh]

so helpful and efficient! loved that I got the help I needed in less than a minute's time. thanks!

[@joshemman]

Glad it helped!

[@understandablehaveagreatda4231]

thank you, I was so stuck on this and you helped me in a minute!

[@tiasanders3167]

Excellent and easy to follow instructions! Your help is greatly appreciated!

[@edwardunderwood5343]

short. sweet. to the point. excellent

[@iwuvanime-kun8887]

Thanks for this! We'll be havinh an exam for tom and i havnt quite good at this in excel. Glad to watch this!

[@rajaryansingh3195]

Finally some worthy content

[@jaydahuyla4220]

WHAT A GOOD TEACHER❤❤❤

[@sifayatsamim6759]

So much helpful tutorial. Thanks 😊

[@degomua4398]

Thank bro , mi teacher show us this like half a minute

[@mas7850]

Wonderful! Thanks a lot!

[@joshemman]

Thank you too!

[@Jug1212Original]

this is amazing and helped me so much

[@pulithegirl6226]

Thank you very much

[@dannybrown317]

Thanks! This is excellent! However when I did same with my data, it was off. The count was one number short. Will redo but most importantly thanks for sharing this possibility!

[@dannybrown317]

it was the label thing. It is perfect now.

[@joshemman]

You probably do have a title (Age, in my example). If you select (highlight) the title along with the data, then check "Labels in First Row". If you do not select the title, do not check it.

[@massibarakzai1642]

@@joshemman Sir, if we don't have a title, that means we should CHECK the "Labels in first row' ? and when I CHECK labels in first row (even when I don't have a title) then I get one short counting, like I have 30 numbers but it gets counted as 29 also the total sum differs why?

[@joshemman]

@@massibarakzai1642 only check Labels if you select them.

[@massibarakzai1642]

​@@joshemman thank you so much, I have one more question, which is: if I get my MEAN as 43.53 and my standard deviation as 11.46, this means that my standard deviation is lower than my mean yes? which means the data points are near the mean yes?

[@rohayasuliman3120]

Why I cannot get mode value

[@joshemman]

It could be that there is no mode (no value occurs mode than once).

[@Googleuser-yg6zt]

Can I do this on the mobile app version?

[@user-vu9me9yz3n]

Thank you!!!

[@sweetygoud584]

Tq so much bruh..

[@surangathelahera8162]

😍😍😍😍😍😍

[@SuryaSingawarapu]

B17,b21

[@ghadaghada4881]

Wonderful..thanks