Q) The Sales data set lists the annual sales (in millions of dollars) for 21 pharmaceutical companies. Put your answers in the yellow cells. Use Excel functions to compute your answers.

Sales

8408

1374

1872

8879

2459

11413

608

14138

6452

1850

2818

1356

10498

7478

4019

4341

739

2127

3653

5794

8305

part 1. C /reate a five-number summary, including the IQR.

Min Q1 Q2 Q3

Max IQR

part 2. Using the IQR, determine if there are any outliers. If there are, identify the outliers.

ower upper

outliers:

Part 3. What scoes are at the 10th and 90th percentile? Interpret your answers.

P.10 p.90

Interpretation:??

Part 4. What is the percentile rank of scores 739 and 11,413? Interpret your answers

PR(739) PR(11,413)

Interpretation:??

Part 5. C /reate a box plot for the data. Be sure to provide an approprite title.