For doing the case study you need to respond the following 4 questions, and for

For doing the case study you need to respond the following 4 questions, and for required data you will use the Excel files that are attached below(you can see two files one is “question 1,2,3” will be used for questions 1, 2 and 3.)
1- Open the sheet Mc 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 for number of sandwiches was ordered by costumers.
b) What is the probability of getting order with more than 4 sandwiches?
c) Construct a histogram for Customer 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.
Final reminder: I expect you to send me your worksheet with formulas.
CASE STUDY RUBRICS
Follow me in this video and you should be all set!
https://youtu.be/xBGU3ZSz0C8
questions 1,2,3.xlsx questions 1,2,3.xlsx

Leave a comment

Your email address will not be published. Required fields are marked *