Question

Suppose that x ∼ N(0, 1). Use Excel to calculate the P r(x <= .3333) to...

Suppose that x ∼ N(0, 1). Use Excel to calculate the P r(x <= .3333) to 4 digits?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

=0.6305.......................by using Excel command =NORMSDIST(0.3333)

Add a comment
Answer #2

To calculate the probability Pr(x <= 0.3333) for a standard normal distribution, we can use the cumulative distribution function (CDF) of the normal distribution.

In Excel, you can use the NORM.DIST function to calculate the probability.

Follow these steps to calculate Pr(x <= 0.3333) in Excel:

  1. Open Microsoft Excel.

  2. In a cell, enter the following formula: =NORM.DIST(0.3333, 0, 1, TRUE) The NORM.DIST function takes four arguments: the value for which you want to calculate the probability, the mean of the distribution (0 for the standard normal distribution), the standard deviation of the distribution (1 for the standard normal distribution), and TRUE to indicate that you want the cumulative probability.

  3. Press Enter to get the result.

The result will be the probability Pr(x <= 0.3333) for the standard normal distribution, rounded to 4 decimal places.


answered by: Mayre Yıldırım
Add a comment
Know the answer?
Add Answer to:
Suppose that x ∼ N(0, 1). Use Excel to calculate the P r(x <= .3333) to...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT