Get documents about "calculate-measures-central-tendency
Document Sample
3: How to calculate measures of central tendency
First enter the data
from p.61 of Basic
Statistics for
Psychologists into
your Excel file:
Write M = in cell C1,
Median = in cell C2,
and Mode = in cell
C3
Marc Brysbaert www.palgrave.com/psychology/brysbaert
Basic Statistics for Psychologists 3: How to calculate measures of central tendency
Palgrave, 2011 1
Put the cursor in cell
D1 and click on fx:
From the selection
choose Statistical
and Average:
Marc Brysbaert www.palgrave.com/psychology/brysbaert
Basic Statistics for Psychologists 3: How to calculate measures of central tendency
Palgrave, 2011 2
Click on OK and
enter the range of
data A1:A9 (or
activate the cells
with your cursor):
Marc Brysbaert www.palgrave.com/psychology/brysbaert
Basic Statistics for Psychologists 3: How to calculate measures of central tendency
Palgrave, 2011 3
Click again on OK to
get the result:
Go to cell D2 and
select the Median
from fx:
Marc Brysbaert www.palgrave.com/psychology/brysbaert
Basic Statistics for Psychologists 3: How to calculate measures of central tendency
Palgrave, 2011 4
Then go to cell D3
and enter the Mode:
If everything went
well, this is your
output:
Change a value to see the impact on the various measures of central tendency. You can also increase the range (e.g.
A1:A20) of the various statistics, so that you can enter more data. Notice that empty cells are not taken into account to
calculate the measures. So, you can define a range larger than you need, as long as you make sure the “empty” cells
(i.e., the ones without data) are actually empty.
Marc Brysbaert www.palgrave.com/psychology/brysbaert
Basic Statistics for Psychologists 3: How to calculate measures of central tendency
Palgrave, 2011 5
