the data of 362 costumers in drive-thru ordering line you can find the data set in attached file below.
a) Construct a frequency distribution, and relative frequency fornumber of sandwiches was ordered by costumers.
b) What is the probability of getting order with more than 4 sandwiches?
c)Construct a histogram forCustomer Waiting Time. Discuss the shape of distribution, is it symmetric or not?
d) Calculate the mean and standard deviation for customer waiting time.
e) If we suppose a Normal distribution for waiting time, what is the chance that customer wait more than 200 seconds in McDonald drive thru?
2-Open the sheet "Airplanes" then use appropriate diagram for discovering the relationship between passenger capacity and fuel consumption. Explain the result.
3- Open the "Gasoline Prices" worksheet and then use appropriate tool for representing the price trend over the time.
4- At a recent meeting, the manager of a national call center for a major Internet bank made the statement that the average past-due amount for customers who have been called previously about their bills is now no longer than $20. Other bank managers at the meeting suggested that this statement may be in error and it needs to be tested. The file called
Bank Call Centerattached below, contains data for a random sample of 67 customers from the call center population. What should be conducted based on the sample data? Test usingα = 0.10.
1- Open the sheetMc Donald:Waiting Times are very important factor in Drive-Thru ordering system.McDonald has collected the data of 362 costumers in drive-thru ordering line you can find the data set in attached file below.
a) Construct a frequency distribution, and relative frequency fornumber of sandwiches was ordered by costumers.
b) What is the probability of getting order with more than 4 sandwiches?
c)Construct a histogram forCustomer Waiting Time. Discuss the shape of distribution, is it symmetric or not?
d) Calculate the mean and standard deviation for customer waiting time.
e) If we suppose a Normal distribution for waiting time, what is the chance that customer wait more than 200 seconds in McDonald drive thru?
2-Open the sheet "Airplanes" then use appropriate diagram for discovering the relationship between passenger capacity and fuel consumption. Explain the result.
3- Open the "Gasoline Prices" worksheet and then use appropriate tool for representing the price trend over the time.
4- At a recent meeting, the manager of a national call center for a major Internet bank made the statement that the average past-due amount for customers who have been called previously about their bills is now no longer than $20. Other bank managers at the meeting suggested that this statement may be in error and it needs to be tested. The file called
Bank Call Centerattached below, contains data for a random sample of 67 customers from the call center population. What should be conducted based on the sample data? Test usingα = 0.10.
Final reminder: I expect you to write your analysis on numerical and graphical output. I will see your reports that is supported by enough informative comments. The format of the report is Docs or PDF.