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

Expert Answer

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

help_outline

Image Transcriptionclose

Descriptive statistics #1 count 20 BoxPlot 10 30 40 60 #1 50 20

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

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

Math

Statistics

Other

Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: What type of variable ( nominal or ordinal) is class?

A: Introduction::Nominal scale of measurement: A scale of measurement in which, the observations are ca...

question_answer

Q: Question Help An investment counselor calls with a hot stock tip. He believes that if the economy re...

A: Expected value:The expected value of a random variable is the sum of the possible values that the ra...

question_answer

Q: The College Board National Office recently reported that in 2011-2012, the547,038 high school junior...

A: a) The probability that a high school junior who takes the test will score at least 610 on the mathe...

question_answer

Q: Engineers must consider the breadths of male heads when designing helmets. The company researchers h...

A: The minimum head breadth that will fit the clientele is 3.2 and it is calculated below: Let us defin...

question_answer

Q: Suppose you flip eight fair coins.   What is the probability of flipping exactly eight heads? What...

A: Binomial distribution:The events that has exactly two possible outcomes (success or failure) follows...

question_answer

Q: A simple random sample of size n = 64 is obtained from a population with μ=80 and σ=16. ​(a) Descri...

A: (a) From the Central Limit Theorem, the sampling distribution of sample mean is normal distribution ...

question_answer

Q: The mean difference equals 1.2, the standard deviation of the difference equals 1.5, and n equals 25...

A: It is given that mean difference is 1.2, the standard deviation of the difference is 1.5 and the sam...

question_answer

Q: How much does a sleeping bag cost? Let's say you want a sleeping bag that should keep you warm in te...

A: (a)The mean of the data is,

question_answer

Q: If 3% of the thermometers are rejected because they have readings that are too high and another 3% a...

A: Solution:From the given information, the 3% of thermometers are rejected because that is having read...