Reference no: EM13741657

The following data were collected on scores (out of a possible 100) for a pretest in quantitative methods. Using Excels statistical functions complete the following questions.

Arrivals

Data Set 1                                                                                                                                            95   75   68                                                                                                                                         102 67   65                                                                                                                                           99   87  94                                                                                                                                           88   120   81                                                                                                                                         100  71   104

Data Set 2

45   25   18

62   17 15

49   37   54

48   70    31

50   21    54

a.   What are the means for the 2 data sets?

b.   What are the medians for the 2 data sets? Is there a difference or similarity between the mean and the median? Explain the similarity or difference?

c.  What are the standard deviations for each of the data set?

d.  Construct a histogram for each data set, using 5 as your class width and starting with 60 as your lowest class for data set 1 and 10 for data set 2.

e.      Relate the standard deviation you calculated in part c to your histograms in part d.

Eastern airlines knows that 20 percent of its customers fly first class, 20 percent fly business class, and the rest fly coach. Of those customers who fly first class, 70 percent are from the east coast while 30 percent are form elsewhere. In addition of those customers who fly business class 50 percent are from the east coast and 50 percent are from elsewhere. Finally, of those customers who fly coach, 75 are from elsewhere and 25 percent are from the east coast.

a.       Construct a probability tree for this problem

b.      Construct a probability table for this problem

c.       Determine the probability that a customer from the east coast will fly first class?

d.      What is the probability that a customer will be from the east coast?

Based on problem 8, which data set is more stable. Base your answer on standard deviation values. Compare both frequency histograms and which shows a normal distribution behavior?

Based on problem 11, if you are the owner of the Eastern airlines how many seats do you need to cover the East Coast flights with a monthly total demand of 487,000 people for the entire airline? If the airplane
has 200 seats, how you will distribute them by first class, business class and coach?