The following sample data represents the age of 30 lottery winners. NS

puntgewelb5

puntgewelb5

Answered question

2021-12-04

The following sample data represents the age of 30 lottery winners.
18 27 29 32 34 35 37 38 43 46 48 50 51 52 54 57 57 58 59 60 62 63 67 67 69 71 72 72 75 81
a) Estimate the sample standard deviation of this data using the formula S=R4S=R4 where SS is the standard deviation and RR is the range.
b) Use Excel to get the sample standard deviation.

Answer & Explanation

George Spencer

George Spencer

Beginner2021-12-05Added 12 answers

Step 1
a) The value of range is obtained below:
From the given information, the minimum value of the data set is =18, the maximum value of the data set is =81.
The range formula is given below:
Range=Maximum valueMinimum value
=8118
=63
Thus, the value of the range is 63.
Step 2
By using the formula s=R4 to find the sample standard deviation is given below:
S=R4
=634
=15.75
Thus, the sample standard deviation is 15.75.
b) By using the Excel formula to get the sample standard deviation is given below.
First need enter the given data into the excel spreadsheet.
The excel formula for calculate the sample standard deviation is = STDEV (number 1, number 2…)
The sample standard deviation is: = STDEV (18, 27, 29…)
Thus, the sample standard deviation (s) is 16.1425.

Do you have a similar question?

Recalculate according to your conditions!

New Questions in High school statistics

Ask your question.
Get an expert answer.

Let our experts help you. Answer in as fast as 15 minutes.

Didn't find what you were looking for?