Use the RANDBETWEEN function to generate random integers.
=RANDBETWEEN(bottom,top)
where bottom is the smallest integer RANDBETWEEN will return and
top is the largest integer RANDBETWEEN will return.
For example, to simulate a six-sided dice.
=RANDBETWEEN(1,6)
Use a spreadsheet to examine the effect on the calculate summary statistics of changing the value of a score.
Syllabus: Mathematics General Course, page 37
Mean: =AVERAGE(B3:B7)
Median: =MEDIAN(B3:B7)
S.D.: =STDEV.P(B3:B7)
where B3:B7
is the range of cells containing numerical data.
Calculate summary statistics: mean, mode, median
Mean: =AVERAGE(B1:B4)
Mode: =MODE(B1:B4)
Median: =MEDIAN(B1:B4)
where B1:B4
is the range of cells containing numerical data.