Question

# Can you show me how to do this using Excel? Suppose we gathered the data below...

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.

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 ...!!

#### Earn Coins

Coins can be redeemed for fabulous gifts.