Question

1. Use the following data to answer the questions listed below:

17                    13

18                    16

20                    24

15                    19

19                    12

10                    16

26                    27

13                    23

17                    15

24                    20

14                    21

26                    22

1. Using excel, compute the mean, median, range, and standard deviation of this sample.
2. Create a table organized into bins starting with 10 and going up by 4 (10-13, 14-17, 18-21, etc.)
3. Create a histogram that shows the distributions from part b. Describe the distribution shown on your output.

Answer 1

a) Since we know that

Median for a list of even number of data point is the mean of 2 middle most values if we sort the list in increasing order while for a list of odd number it is the middle most value if the list is sorted in increasing order.

Since our list have even number of data points, this implies that

Median = 18.5

The range is the difference between the largest and smallest values in a set of values.

This implies that

Range = 27.0 - 10.0

Range = 17.0

b)

10.0, 12.0, 13.0, 13.0, 14.0, 15.0, 15.0, 16.0, 16.0, 17.0, 17.0, 18.0, 19.0, 19.0, 20.0, 20.0, 21.0, 22.0, 23.0, 24.0, 24.0, 26.0, 26.0, 27.0

Class interval	Frequency
10-13	4
14-17	7
18-21	6
22-25	4
26-29	3

c)

Data is skewed, right-skewed