# Use the accompanying data set to complete the following actions.a. Find the quartiles.b. Find the interquartile range.c. Identify any outliers.  42 51 37 43 40 36 39 46 45 38 34 55 42 36 15 51 39 51 29 30

Question
Asked Oct 27, 2019
20 views
Use the accompanying data set to complete the following actions.
a. Find the quartiles.
b. Find the interquartile range.
c. Identify any outliers.

42 51 37 43 40 36 39 46 45 38 34 55 42 36 15 51 39 51 29 30
check_circle

Step 1

a.Obtaining quartiles of this data:

The first quartile for the given data can be obtained by entering the formula “=QUARTILE.EXC(A1:A20,1)” in EXCEL software.

The value of the first quartile is 36.

The second quartile for the given data can be obtained by entering the formula “=QUARTILE.EXC(A1:A20,2)” in EXCEL software.

The value of the first quartile is 39.5.

The third quartile for the given data can be obtained by entering the formula “=QUARTILE.EXC(A1:A20,3)” in EXCEL software.

The value of the first quartile is 45.75.

Step 2

b.obtaining interquartile range of this data is,

Inter quartile range is,

IQR=Q3–Q1=45.75–39.5=6.25

Step 3

c.The outlier is identified below:

Excel add-in (MegaStat) procedure:

Step 1: In EXCEL, Select Add-Ins > MegaStat > Descriptive Statistics.

Step 2: In Input range, select the cell range A1:A20.

Step 3: Check Select Defaults.

Step 4: Choose Boxplot.

Step 5: Click OK.

The output is obtained below:

From the output, the outlier observat...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in