Purchase Solution

# Z-Score and Percentile in Excel

Not what you're looking for?

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.

##### 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.

Solution provided by:
###### Education
• MSc, Osmania University
• MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
• BSc, Banaras Hindu University
###### Recent Feedback
• "Very fast turnaround. Excellent communication! Much appreciated!"
• "excellent"
• "excellent"
• "excellent work"
• "Fantastic..great solution and very well explained!!!!"

##### Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

##### Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.