Consider the random variable x that follows a normal distribution, with a mean o

Question

Consider the random variable x that follows a normal distribution, with a mean of mu = 22 and a standard deviation of sigma = 8. You will enter some of your answers to the questions that follow in this sample Excel spreadsheet: In cell B1 of the sample spreadsheet, select the correct Excel formula for computing the probability that x is less than 32. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. What is the probability that x is less than 32? P(x

Explanation / Answer

We use the following EXCEL function to compute the required probability

=NORM.DIST(32,22,8,TRUE)

And the probability comes out to be:

P( X < 32) = 0.8944

Now for the second part, the probability is computed as:

=NORM.DIST(32.5,22,8,TRUE)-NORM.DIST(30.5,22,8,TRUE)

and the probability comes out to be:

P( 30.5 < x < 32.5 ) = 0.0493

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.