Question

For this question, you are required to find the standard deviation for a set of data. The answer alone will not achieve full marks. There are many tools available to calculate the standard deviation. Here you are required to use several of the tools and show your working out to earn the marks. The data is the test results of 21 students who sat a mathematics quiz worth 100 marks.

Results: 60, 47, 17, 43, 30, 90, 77, 61, 54, 89, 22, 80, 67, 37, 63, 50, 81, 21, 36, 51, 59.

a) Calculate the mean and variance and standard deviation using a scientific calculator.

b) Calculate the standard deviation by long hand showing all workings step-by-step.

c) Set up a spreadsheet to calculate the standard deviation. Insert a screen shot or snip to show the data and the answer.   

d) Use an on-line calculator to find the mean, variance and standard deviation of the data. Insert a screen shot or snip to show the three answers.

Answer 1

b)

39963,9, 8, 21ノ3, 51ノ59 2-1 2 + (30-"os) -5y.os)2t&z-St«J€ l-Syeus-Sym)2 (21-1 22,o l

c)

  

marks obtained 60 47 17 43 30 90 61 54 89 80 67 37 63 50 81 21 36 51 59 54.04761905 22.00108222 484.047619 Average Standard Deviation Variance

d)

Standard Deviation Calculator Result Sample Standard Deviation, s 22.001082224464 Variance (Sample Standard), s 484.04761904762 Population Standard Deviation, σ 21.470857747801 Variance (Population Standard), ơ2|4609977324263 Total Numbers, N Sum Mean (Average): Standard Error of the Mean (SEx): 4.8010297459311 21 1135 54.047619047619