Question;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.ArrivalsData Set 1Data Set 295 75 6845 25 18102 67 6562 17 1599 87 9449 37 5488 120 8148 70 31100 71 10450 21 54a. 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.Construct a probability tree for this problemConstruct a probability table for this problemDetermine the probability that a customer from the east coast will fly first class?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 tocover the East Coast flights with a monthly total demand of 487,000 people for the entire airline? If theairplane has 200 seats, how you will distribute them by first class, business class and coach?
Paper#61519 | Written in 18-Jul-2015Price : $25