Question

In: Statistics and Probability

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

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

Solutions

Expert Solution

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


Related Solutions

CitiBank recorded the number of customers to use a downtown ATM during the noon hour on...
CitiBank recorded the number of customers to use a downtown ATM during the noon hour on 32 consecutive workdays. I have tried to find the 1st and 3rd quartiles and got 12.5 for the first and 31.5 for the 3rd but my homework thing keeps saying that is wrong, I dont know what to do. 20 36    22    28    5    11    29    32     11 16    15    10    31    38    36...
US Bank has recorded the number of customers who used a downtown ATM during the noon...
US Bank has recorded the number of customers who used a downtown ATM during the noon hour (variable of interest) on 21 randomly selected workdays. The data is given below, 16, 17, 12, 27, 22, 28, 15, 16, 29, 22, 11, 19, 27, 23, 18, 24, 21, 11, 40, 42, 43. Please show your complete manual work, use statistical notations wherever possible, and do not classify the data in answering the following questions. ​a. Compute the Sample Average of customers...
1. A grocery store counts the number of customers who arrive during an hour. The average...
1. A grocery store counts the number of customers who arrive during an hour. The average over a year is 29 customers per hour. Assume the arrival of customers follows a Poisson distribution. (It usually does.) Find the probability that at least one customer arrives in a particular one minute period. Round your answer to 3 decimals. Find the probability that at least two customers arrive in a particular 2 minute period. 2. Label each as one of the following...
Customers arrive at a local ATM at an average rate of 14 per hour. Assume the...
Customers arrive at a local ATM at an average rate of 14 per hour. Assume the time between arrivals follows the exponential probability distribution. Determine the probability that the next customer will arrive in the following time frames. ​a) What is the probability that the next customer will arrive within the next 2 ​minutes? ​b) What is the probability that the next customer will arrive in more than 15 ​minutes? ​c) What is the probability that the next customer will...
The number of customers that visit a 24-hour local supermarket during the off-peak hours between 8am...
The number of customers that visit a 24-hour local supermarket during the off-peak hours between 8am - 11am is known to be distributed as Poisson with mean 2 per hour. Determine the probability that i. no customers will visit the supermarket between 8am - 9am. ii. exactly one customer will visit the supermarket between 9am - 11am. iii. exactly one customer will visit the supermarket for each of the time intervals 8am - 9am and 9am-11am.
A bank wants to develop an improved process for serving customers during the noon-to-1pm lunch period....
A bank wants to develop an improved process for serving customers during the noon-to-1pm lunch period. Management decides to first study the waiting time of the current process. Data is collected from a random sample of 15 customer and their waiting time is recorded (in minutes) and is located in the Excel data file for this assignment under the tab bank1. For comparative purposes, similar data is collected from bank2. Bank1: 4.21 5.55 3.02 5.13 4.77 2.34 3.54 3.20 4.50...
The number of students coming for treatment at a health facility each half hour was recorded:...
The number of students coming for treatment at a health facility each half hour was recorded: {14, 11, 11, 11, 8, 12, 9, 13, 10, 14, 21, 7, 16, 9, 12, 9, 15, 10, 12, 11, 13, 10, 12, 10, 15, 14, 9, 11, 11, 8}. Do these data follow a Poisson distribution? Conduct the appropriate Chi-Square test.
The mean number of arrival at an airport during rush hour is 20 planes per hour...
The mean number of arrival at an airport during rush hour is 20 planes per hour while the mean number of departures is 30 planes per hour. Let us suppose that the arrivals and departures can each be described by a respective poisson process. The number of passengers in each arrival or departure has a mean of 100 and a coefficient of variation of 40%. a.) What is the probability that there will be a total of two arrivals and/or...
The number of customers arriving per hour at a certain automobile service facility is assumed to...
The number of customers arriving per hour at a certain automobile service facility is assumed to follow a Poisson distribution with mean λ=5. a) Compute the probability that more than 11 customers will arrive in a 2​-hour period. b) What is the mean number of arrivals during a 2​-hour ​period?
The number of customers arriving per hour at a certain automobile service facility is assumed to...
The number of customers arriving per hour at a certain automobile service facility is assumed to follow a Poisson distribution with mean λ=9. ​(a) Compute the probability that more than 16 customers will arrive in a 2-hour period.​ (b) What is the mean number of arrivals during a 2-hour period? ​(a) The probability that more than 16 customers will arrive is ​(Round to four decimal places as​ needed.) ​(b) The mean number of arrivals is ​(Type an integer or a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT