Purchases	Frequency	Relative Frequency
9	13	44	2	77		0 to 15	12	0.30000
35	38	8	41	16		16 to 31	9	0.22500
15	27	47	51	20		32 to 47	10	0.25000
48	59	17	34	55		48 to 63	7	0.17500
21	0	37	11	68		64 to 79	2	0.05000
7	45	23	63	32
23	25	12	62	4
19	9	38	0	55

Using Excel calculations, give the five-number summary (in order: min, Q1, median, Q3, max) for the data set above. Determine if there are any outliers based on the 1.5 IQR rule (see page 167 in the text). Work must be shown to the right, and final classification of outliers, if any exists, must be stated explicitly. Then, answer the percentile questions.

a.	min:
b.	Q1:
c.	median:
d.	Q3:
f.	max:
g.	IQR:
h	list any outlier(s) and explain why there are or are not any outliers for the data set

i	Using Q1, the median, and Q3, give the percentile for each, and explain the meaning of these percentiles in the context of the number of items ordered from Amazon in the past 6 months.
j.	Using Excel, calculate the 40th percentile and label it.
k	Using Excel, calculate the 88th percentile and label it.
l.	Using Excel, determine the percentile rank for the purchase of 32 items from Amazon in the past 6 months and label.
m.	Using Excel, determine the percentile rank for the purchase of 48 items from Amazon in the past 6 months and label.