excel compute relative cumulative frequencies correlation of data z scores probability distribution
Most of the exam consists of numerical problems. PLEASE PROVIDE WELL EDITED ANSWERS ON THE SPACE BELOW EACH PROBLEM or in an EXCEL FILE.
PROBLEMS
1
Construct Frequency distributions and histograms for the numerical data in the Excel file Cell phone Survey.Also compute the relative frequencies and cumulative relative frequencies.
2
For the President’s inn Guest Database file find the average length of stay and number of guests. Is there any correlation between the size of the party and the length of stay?
3
Compute the z-scores for the data in the excel file Airline Service Times. How many observations fall further than three standard deviations from the mean? Would you consider these as outliers? Why or why not?
4
Construct the probability distribution for the value of a 2-card hand dealt from a standard deck of 52 cards (all face cards have a value of 10 and an ace has a value of 11).
- What is the probability of being dealt 21?
- What is the probability of being dealt 16?
- Construct a chart for the cumulative distribution function. What is the probability of being dealt 16 or less? Between 12 and 16? Between 17 and 20?
- Find the expected value and standard deviation of a 2-card had.
5
In determining automobile-mileage ratings, it was found that the mpg (X) for a certain model is normally distributed, with a mean of 33 mpg and a standard deviation of 1.7 mpg. Find the Following:
- P(X < 30)
- P (28 < X < 32)
- P ( X > 35)
- P( X > 31)
- The mileage rating that the upper 5% of cars achieve.
