0:00
hello and welcome to tutorial's point in
0:03
this video we are going to learn how to
0:05
calculate mean median mode and standard
0:09
deviation in Microsoft Excel so here we
0:12
have this sample data set of baseball
0:15
players we have a player name their team
0:18
their position Age games played ad Pats
0:21
and so on now here let me scroll down
0:24
and let me zoom in a bit so here we will
0:27
calculate the mean for H all right right
0:34
average and then parenthesis and we will
0:37
select all of these age values something
0:41
like this now as you can see we only
0:43
have about 29 cells of these what if we
0:47
have hundreds and thousands of cells
0:48
it'll be difficult to select them by
0:51
dragging like this so instead of
0:53
dragging like this we need to understand
0:55
that this age starts from this two and
1:00
this D so it starts from D2 all the way
1:06
d29 right so I'll write here
1:12
d29 this selects all of the age values
1:16
now I'll close the parenthesis and hit
1:18
enter and we have the mean value for age
1:23
now after age what we want is to
1:25
calculate median to calculate median
1:31
equals median and then parenthesis and
1:34
then we we want to select the H column
1:37
so again I will write
1:40
D2 colon which means all the way to d29
1:44
so here I'll write D 29 and close the
1:49
parenthesis and hit enter and we have
1:52
the median age after median we want to
1:55
calculate the mode now here I'll write
1:58
the formula equals and then mode as you
2:02
can see we have multiple formulas for
2:05
mode this one is here but as you can see
2:07
it says this function is available for
2:09
compatibility with Excel 2007 and
2:12
earlier so we will be using this one so
2:15
I'll write mode do sngl and then
2:18
parenthesis and then again we will
2:20
select our ages column which is from D2
2:24
Colon D 29 and then close the
2:28
parenthesis and hit enter and we have
2:31
the mode which is actually equal to the
2:33
median itself and then finally we want
2:35
to calculate the standard deviation so
2:40
equals and then standard deviation and
2:43
we have multiple formulas here and we
2:47
would like to use this one so I'll write
2:51
standard deviation and then after the
2:54
parenthesis we want to select the ages
2:57
column so again ages start from D2 colon
3:03
d29 I'll close the parenthesis and hit
3:07
enter and we have calculated the
3:10
standard deviation now we want to
3:13
calculate these values for all of these
3:16
starts now instead of writing the
3:18
formula again and again we'll just use
3:20
the excel's autofill feature so here I'm
3:23
going to select this cell and I'll move
3:25
my cursor in the bottom right and as you
3:28
can see the cursor changes its color so
3:31
I'm going to click and drag it all the
3:34
way to here and release it and this will
3:38
calculate the mean value for all these
3:42
stats let me zoom out a bit similarly
3:45
for the median I'm going to again select
3:47
my cursor and drag it all the way to the
3:50
right and we have the median values
3:53
similarly for mod I'm just going to drag
3:56
my cursor again and for stand standard
4:00
deviation as well I'm going to drag my
4:03
cursor and we have the standard
4:06
deviation for all these player
4:10
starts so that will be enough for this
4:12
video you can find the link in the
4:14
description where you can download this
4:16
practice sheet so that you can calculate
4:18
these values yourself so that will be it
4:21
for this video make sure to share it
4:23
with your friends subscribe to this
4:25
Channel and I will see you in the next
