hello and welcome to tutorial's point in
this video we are going to learn how to
calculate mean median mode and standard
deviation in Microsoft Excel so here we
have this sample data set of baseball
players we have a player name their team
their position Age games played ad Pats
and so on now here let me scroll down
and let me zoom in a bit so here we will
calculate the mean for H all right right
so I'll write here
equals
average and then parenthesis and we will
select all of these age values something
like this now as you can see we only
have about 29 cells of these what if we
have hundreds and thousands of cells
it'll be difficult to select them by
dragging like this so instead of
dragging like this we need to understand
that this age starts from this two and
this D so it starts from D2 all the way
to this
d29 right so I'll write here
D2 colon
d29 this selects all of the age values
now I'll close the parenthesis and hit
enter and we have the mean value for age
now after age what we want is to
calculate median to calculate median
I'll write here
equals median and then parenthesis and
then we we want to select the H column
so again I will write
D2 colon which means all the way to d29
so here I'll write D 29 and close the
parenthesis and hit enter and we have
the median age after median we want to
calculate the mode now here I'll write
the formula equals and then mode as you
can see we have multiple formulas for
mode this one is here but as you can see
it says this function is available for
compatibility with Excel 2007 and
earlier so we will be using this one so
I'll write mode do sngl and then
parenthesis and then again we will
select our ages column which is from D2
Colon D 29 and then close the
parenthesis and hit enter and we have
the mode which is actually equal to the
median itself and then finally we want
to calculate the standard deviation so
here I'll write
equals and then standard deviation and
we have multiple formulas here and we
would like to use this one so I'll write
standard deviation and then after the
parenthesis we want to select the ages
column so again ages start from D2 colon
to
d29 I'll close the parenthesis and hit
enter and we have calculated the
standard deviation now we want to
calculate these values for all of these
starts now instead of writing the
formula again and again we'll just use
the excel's autofill feature so here I'm
going to select this cell and I'll move
my cursor in the bottom right and as you
can see the cursor changes its color so
I'm going to click and drag it all the
way to here and release it and this will
calculate the mean value for all these
stats let me zoom out a bit similarly
for the median I'm going to again select
my cursor and drag it all the way to the
right and we have the median values
similarly for mod I'm just going to drag
my cursor again and for stand standard
deviation as well I'm going to drag my
cursor and we have the standard
deviation for all these player
starts so that will be enough for this
video you can find the link in the
description where you can download this
practice sheet so that you can calculate
these values yourself so that will be it
for this video make sure to share it
with your friends subscribe to this
Channel and I will see you in the next
one