Purchase Solution

Z-Score and Percentile in Excel

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
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:
Anwesha Ghosh, MSc
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!!!!"
Purchase this Solution
Free BrainMass Quizzes
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.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Percentile rank & Inter-quartile range

    Please find the attached answers in an Excel file. This solution provides detailed explanations of how to find percentile ranks and inter-quartile range for normally distributed data.

  • Normal Distribution

    In order to estimate the percentile, a normal distribution approximation can be used.
    The z-score is equal to (90 - 100)/15 = -0.67.

  • Standard Scores and Percentiles

    (Use Table 6.3 on page 390 of your e-text to find the Percentile based on the z-score that you calculate.) a. What are the standard score and percentile of a height of 72 inches? b.

  • Statistics: Distribution Analysis

    The Z score is calculated z=(x-mean)/(standard deviation) x=110000 mean=105000 standard deviation=18200 So: z=(110000-105000)/18200=.274725 Using NORMSDIST(.274725) on excel, we get that 60.8% of houses in the family’s current city costs less than

  • Normal Probability of Household Spending

    NOTE: Please use attached Excel spreadsheet to show all computations. Please do not just give the answer but show fully exactly how you arrive at each answer. All computations should be complete and in agreement with all answers.

  • Statistics - Highest Relative Score

    < 0.2222) = 100 * 0.5879 = 58.79 (C) z = (18 - 15)/5 = 0.60 Percentile score = 100 * P(z < 0.60) = 100 * 0.7257 = 72.57 The score in Test (C) is the highest relative score.

  • Z-score and percentile

    In other words 8.9% members will have weigh more than 27.8 pounds. This provides an example of using z-score and percentile to determine percentage.

  • Descriptive Statistics Exercises

    Instead, use the Z distribution table below and Appendix A in the Jackson text. a. If Andrew scored 45 on this test, what is his Z score? Since the mean is 45, Z = 0 His Z score is 0. b. If Anna scored 30 on this test, what is her Z score?

  • Test and Measurements Task

    Person B received a z-score of 0: T score (50), CEEB score (500), IQ score (100), Subset scores (10), and approximate percentile score (50).

  • Percentile Rank

    P (X < 90) = = P (Z < -0.6667) = 0.2525 Hence the percentile rank = 0.2525 * 100 = 25 The solution provides step by step method for the calculation of probability using the Z score and percentile rank.

View More Related Solutions