CitiBank recorded the number of customers to use a downtown ATM during the noon

Question

CitiBank recorded the number of customers to use a downtown ATM during the noon hour on 32 consecutive workdays. 39 19 26 23 15 25 19 36 8 35 20 14 28 18 9 16 16 17 10 7 12 23 22 37 20 8 30 10 19 20 29 40 ata (a) Use Excel's quartile function to find the quartiles and the midhinge. (Round your answers to 2 decimal places.) 1st quartile Median 3rd quartile Midhinge 25 (b) What does the box plot of the given data indicate? O The box plot indicates that there are extreme values or outliers. The box plot indicates that there are no extreme values or outliers.

Explanation / Answer

a) Use Excel function

QUARTILE.EXC(A1:H4,1) = 14.25

QUARTILE.EXC(A1:H4,1) = 19.50

QUARTILE.EXC(A1:H4,1) = 27.50

mid hine = (Q1+Q3)/2 = 20.88

b) Yes, there is no extreme outliers

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---