Question

Can you show me how to do this using Excel?

Suppose we gathered the data below by an unbiased method.  (The data is sorted DOWN the columns.)

111	116	119	120	123	126	128	131	136	142
115	117	119	120	123	127	129	132	136	142
115	117	120	121	123	127	129	133	138	143
115	118	120	121	123	128	131	133	138	158
116	118	120	123	125	128	131	135	141	163

1. (4 pts) Use the data to create a histogram using six (6) classes. First class should start at 111.
2. Give the Five-number summary of the data.
3. Describe the data set.  Be specific and note any gaps and/or outliers. Use the 1.5-IQR test to locate outliers.
4. What description of center would be appropriate for the data set?  Explain why?
5. Draw a box plot.

Answer 1

Solution:

a)

Class	Class bonudires	Frequency
110 - 119	109.5 - 119.5	12
120 - 129	119.5 - 129.5	21
130 - 139	129.5 139.5	11
140 - 149	139.5 - 149.5	4
150 - 159	149.5 - 159.5	1
160 - 169	159.5 - 169.5	1

b) Five number summary

Q1	Median	Q3	IQR	minimum	maximum
120	125.5	132.75	12.75	111	163

c)

Outlier using 1.5*IQR

oulier Range		minimum	maximum
		100.875	151.875

Outliers are 163 and 158

using this range we say that there are two outlier i.e 163 and 158 which lies above the maximum value i.e 151.875 therefore this are the outlier

d)

mean	meadian	mode
127.26	125.5	120

now if we the value of mean median and mode this are close to each other .hence all three measures of central tendency are usefull for this data set

e)

Comment : using this box plot we say that there are two outliers in the data

Thank You..!!

I give my 100% hope you satisfied with my answer Please like it ..

I am waiting for feedback ...!!