Purchase Solution

Normal Distribution- probability calculations using Excel

Not what you're looking for?

Ask Custom Question

USE EXCEL TO SOLVE THE FOLLOWING PROBLEMS

PROBLEM 9.13:
The heights of North American women are normally distributed with a mean of 64 inches and a standard deviation of 2 inches.

(a) What is the probability that a randomly selected woman is taller than 66 inches?

(b) A random sample of four women is selected. What is the probability that the sample mean height is greater than 66 inches?

(c) What is the probability that the mean height of a random sample of 100 women is greater than 66 inches?

PROBLEM 9.14

Refer to Exercise 9.13. If the population of women's heights is not normally distributed, which, if any, of the questions can you answer? Explain.

Exercise 9.13: The heights of North American women are normally distributed with a mean of 64 inches and a standard deviation of 2 inches.

(a) What is the probability that a randomly selected woman is taller than 66 inches?

(b) A random sample of four women is selected. What is the probability that the sample mean height is greater than 66 inches?

(c) What is the probability that the mean height of a random sample of 100 women is greater than 66 inches?

[PLEASE SEE THE EXCEL SPREAD SHEET ATTACHED TO HELP WITHA SOLUTION]

Attachments
Purchase this Solution
Solution Summary

Uses Excel for calculating probabilities in a Normal Distribution.

Solution Preview

Please see attached file:

USE EXCEL TO SOLVE THE FOLLOWING PROBLEMS:

PROBLEM 9.13: The heights of North American women are normally distributed with a mean of 64 inches and a standard deviation of 2 inches.

(a) What is the probability that a randomly selected woman is taller than 66 inches?

Probability for x
Mean=M = 64 inches
Standard deviation =s= 2 inches
x= 66
z=(x-M )/s= 1 =(66-64)/2
Cumulative Probability corresponding to z= 1 is= 0.8413
Or Probability corresponding to x< 66.00 is Prob(Z)= 0.8413 0r= 84.13%
Therefore probability corresponding to x> 66.00 is 1-Prob(Z)= 0.1587 =1-0.8413
0r= 15.87%
Answer: 0.1587 or 15.87%

Note: Cumulative probability for x=66 is calculated using EXCEL worksheet function NORMDIST
0.8413 =NORMDIST(66,64,2,1)

The format for NORMDIST worksheet function is
NORMDIST(x,mean,standard_dev,cumulative)
cumulative =1 when we want the probability of x<= 66

(b) A random sample of four women is selected. What is the probability that the sample mean ...

Purchase this Solution
Free BrainMass Quizzes
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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Sample Mean and Proportion

    spending has a normal distribution and using the mean and standard deviation you calculated in the previous step, calculate the probability that the sample mean is more than 9% using the following samples (show the calculations of the Z-score for each

  • Normal Distribution Curve/Chart Statistics

    477642 Normal Distribution Curve/Chart Statistics I need to know how to solve this question using the normal distribution curve / chart and how to answer using Excels Fx statistics function The first statistics exam had a mean of 65 and a standard

  • This is a Statistics Problem

    Based on the graph, I think you are safe using a normal distribution to carry out any hypothesis tests.

  • Probability Analysis for Quality Measurements

    How do the normal probability calculations compare? What do you conclude? 5.Summarize all findings. Please see the attachments. Answer attached in Excel.

  • Six Sigma Computation and Interpretations

    (Note that for a normal distribution sigma means the standard deviation). The one-sigma level probability is the shaded region in the following figure This probability can be easily calculated using the NORMSDIST function in Excel.

  • Vehicle Mileage Statistical Analysis

    Assume a normal distribution. Use this information to answer questions #13 - #14.

  • Calculating Probability in Excel

    This solution gives calculations for probability in Excel.

  • Probability: Using the Normal Distribution

    212622 Probability: Using the Normal Distribution See attached file for solution regarding a problem about a normal distribution. Provide step by step calculations.

  • Finding Probability of Temperature Values

    This solution of 267 words show step-by-step calculations to determine the indicated probability of thermometer readings. All equations are shown and a graph of the distribution is included.

  • Excel: binomial distribution, normal distribution, uniform

    Amount $ Please check attachment The solution gives detailed steps on solving a series of statistical questions using excel: binomial distribution, normal distribution, uniform distribution, probability and so on.

View More Related Solutions