In: Statistics and Probability
CitiBank recorded the number of customers to use a downtown ATM during the noon hour on 32 consecutive workdays. 15 24 20 32 26 38 36 32 32 20 33 26 21 11 5 29 39 5 38 23 35 22 7 6 11 18 39 16 28 32 20 37 (a) Use Excel’s quantile function to find the quartiles and the midhinge. (Round your answers to 2 decimal places.) 1st quartile Median 3rd quartile Midhinge
Sol:
Quartile function 5 number summary
=QUARTILE(A1:A32,1) --->gives Q1
=QUARTILE(A1:A32,2) --->gives median
=QUARTILE(A1:A32,3) --->gives Q3
Midhinge=Q1+Q3/2
Q1=
=QUARTILE(A1:A32,1)
=17.5
Q2=
=QUARTILE(A1:A32,2)
=25
Q3==QUARTILE(A1:A32,2)
=32.25
midhinge=Q1+Q3/2
=17.5+32.25/2
= 24.875
=24.88
1st quartile=17.5
Median =25
3rd quartile=32.25
Midhinge=24.88