FOUR PICS,
ONE WORD
2
D A E M I N
M E D I A N
A A E G R V E
A V E R A G E
D
S T A N S
D A R D
S T A N D A R D
O D M E
M O D E
E D V I A I T O N
D E V I A T I O N
Topic : Using Excel to Calculate
Mean, Median, Mode, and
standard Deviation
Lesson Outline
Objectives
In the end of discussion, the students are expected to:
Understand and calculate Mean (Average),
Median, and Mode using Excel formulas.
Apply these statistical concepts to real-world
data using Excel.
What is Mean, Median, Mode,
and Standard Deviation ?
Mean (AVERANGE)
Excel Formula:
=AVERAGE(range) Definition: The mean, also called the average,
is the sum of all values in a data set divided by
Example:
the number of values.
=AVERAGE(A2:A10) calculates the
average of values in cells A2 to A10.
Median
Excel Formula:
=MEDIAN(range) Definition: The median is the middle value in
an ordered dataset. If there is an even
Example:
number of values, the median is the average
=MEDIAN(A2:A10) returns the middle of the two middle numbers.
value from cells A2 to A10 after
sorting the data.
Mode
Excel Formula:
=[Link](range) returns the most Definition: The mode is the most frequently
frequent single value. occurring value in a dataset. A dataset can
Example: have more than one mode or none if no value
repeats.
=[Link](A2:A10) finds the most
common value in cells A2 to A10.
Standard Deviation
Excel Formula:
=STDEV.S(range) for sample data Definition: The standard deviation measures
(most common). the amount of variation or dispersion in a
=STDEV.P(range) for population data.
dataset. A low standard deviation means
Example: data points are close to the mean, while a
=STDEV.S(A2:A10) calculates the
high standard deviation means data points
standard deviation for a sample of are spread out.
values in cells A2 to A10.
Summary:
In Excel, these statistical measures provide valuable
insights into the characteristics of a dataset. Mean is
used to determine the overall trend or central value of
the data, offering a general summary of performance or
behavior. Median is the middle value in an ordered
dataset. If there is an even number of values, the
median is the average of the two middle numbers.
Mode identifies the most common value, making it
helpful for recognizing patterns or popular choices in the
data. Standard Deviation measures data variability,
allowing users to assess consistency or spread, which is
critical when comparing different datasets. Together,
these metrics give a comprehensive view of the data, 6
aiding in informed decision-making.
Thank you
for listening!
Short Quiz:
1. What is the mean? 4. What does the mode represent?
A) The middle value in a dataset A) The middle value
B) The sum of values divided by the number of values B) The most frequently occurring value
C) The most frequently occurring value C) The average value
D) The range of values D) The sum of the dataset
2. What Excel formula calculates the mean? 5. In Excel, what formula is used to
A) =MEDIAN(range) find the median?
B) =[Link](range) A) =AVERAGE(range)
C) =AVERAGE(range) B) =MEDIAN(range)
D) =STDEV.S(range) C) =[Link](range)
D) =STDEV.S(range)
3. Which of the following describes the median?
A) The average of the two middle numbers
B) The sum of all values
C) The most common value
D) The highest value in the dataset
7
Answer Key:
Answer Key:
1. What is the mean? 4. What does the mode represent?
A) The middle value in a dataset A) The middle value
B) The sum of values divided by the number of values B) The most frequently occurring value
C) The most frequently occurring value C) The average value
D) The range of values D) The sum of the dataset
2. What Excel formula calculates the mean? 5. In Excel, what formula is used to
A) =MEDIAN(range) find the median?
B) =[Link](range) A) =AVERAGE(range)
C) =AVERAGE(range) B) =MEDIAN(range)
D) =STDEV.S(range) C) =[Link](range)
D) =STDEV.S(range)
3. Which of the following describes the median?
A) The average of the two middle numbers
B) The sum of all values
C) The most common value
D) The highest value in the dataset
7
