Explore BrainMass
Share

Z-Score and Percentile in Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

In determining automobile mileage ratings, it was found that the mpg in the city (x) for a certain model is normally distributed, with a mean of 24 mpg and a standard deviation of 1.0 mpg. Find the following:

a. P(X) < 25)
b. P(22 < X < 24)
c. P(X > 26)
d. P(X < 23)
e. The mileage rating that the upper 5% of cars achieve.

© BrainMass Inc. brainmass.com October 17, 2018, 2:12 am ad1c9bdddf
https://brainmass.com/statistics/percentile/zscore-percentile-excel-369965

Solution Summary

This solution is comprised of detailed explanation and step-by-step calculation of the given problems. Supplemented with Interactive EXCEL sheet, this solution provides students with a clear perspective of the underlying concepts.

$2.19
Similar Posting

Percentile rank and inter-quartile range: Example question

For a normally distributed test with a mean of 100 and standard deviation of 20:

a) What score would be associated with the 80th percentile?
b) What would the inter-quartile range be for the test?
c) What would be the percentile rank of a score of 125?

Please give detailed notes explaining the steps required to answer each of these questions.

View Full Posting Details