An executive's telephone log showed the lengths of 60 calls initiated during the last week of July. 1 6 1 1 1 3 2 3 2 4 4 3 10 13 1 2 2 6 5 2 7 2 1 1 3 1 1st quartile Median 3rd quartile Interquartile range 3 2 1 2 29 1 1 1 3 1 2 26 3 1 1 1 20 3 1 1 6 5 1 1 2 8 1 1 1 3 12 5 2 18 Click here for the Excel Data File (a) Use Excel to find the quartiles. (Round your answers to 2 decimal places.)
An executive's telephone log showed the lengths of 60 calls initiated during the last week of July. 1 6 1 1 1 3 2 3 2 4 4 3 10 13 1 2 2 6 5 2 7 2 1 1 3 1 1st quartile Median 3rd quartile Interquartile range 3 2 1 2 29 1 1 1 3 1 2 26 3 1 1 1 20 3 1 1 6 5 1 1 2 8 1 1 1 3 12 5 2 18 Click here for the Excel Data File (a) Use Excel to find the quartiles. (Round your answers to 2 decimal places.)
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
I need help with the question provided and show the work.
Transcribed Image Text:An executive's telephone log showed the lengths of 60 calls initiated during the last week of July.
1
6
1
1
1
3
2
3
2
4
4
3
5
2
7
2 2
2
1
6
1
10
13
1
3
2
1
29
1st quartile
Median
3rd quartile
Interquartile range
1
3
3
1
2
1
1
1
2
26
3
1
1
1
20
3
1
1
6
5
1
1
2
8
1
1
1
3
12
5
2
18
Click here for the Excel Data File
(a) Use Excel to find the quartiles. (Round your answers to 2 decimal places.)
Transcribed Image Text:(a) Use Excel to find the quartiles. (Round your answers to 2 decimal places.)
1st quartile
Median
3rd quartile
Interquartile range
(b) Find the midhinge. (Round your answer to 3 decimal places.)
Midhinge
Expert Solution
Step 1:-
First we enter the given data set in excel sheet.
To calculate 1st quartile in excel we use "=quartile (data,1)"
For calculating median in excel we use "=median()" command.
The 3rd quartile is calculated by using "=quartile (data,3)" command.
Interquartile range (IQR) is given by,
IQR= Q3-Q1
Where Q3 is third quartile and Q1 is first quartile.
We subtract first quartile value from third quartile to find IQR.
Step by step
Solved in 3 steps with 1 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman