The answers for the 3rd quartile and midhinge are wrong. Could you please explai
ID: 3351773 • Letter: T
Question
The answers for the 3rd quartile and midhinge are wrong. Could you please explain how to get those answers? Thank you!
CitiBank recorded the number of customers to use a downtown ATM during the noon hour on 32 consecutive workdays. 8 37 11 28 16 30 23 10 26 40 27 34 36 11 36 32 14 35 9 38 20 13 18 13 36 38 7 10 27 34 5 11 Click here for the Excel Data File (a) Use Excel's quartile function to find the quartiles and the midhinge. (Round your answers to 2 decimal places.) 1st quartile Median rd quartile Midhinge 24.50 34.25 22.63 (b) What does the box plot of the given data indicate? 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
1) For Third quartile
QUARTILE. EXC(A1:H4,3)
= 34.75
2) Mid range = (high+low)/2 = (40+5)/2 = 22.50
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.