Question

Using Excel - normal probabilities Consider the random variable x that follows a normal distribution, with...

Using Excel - normal probabilities Consider the random variable x that follows a normal distribution, with a mean of μ = 54 and a standard deviation of σ = 4. You will select some of your answers to the questions that follow in this sample Excel spreadsheet: A B 1 P(x < 50.5) 2 P(49 < x < 51) In cell B1 of the sample spreadsheet, select the correct Excel formula for computing the probability that x is less than 50.5. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. What is the probability that x is less than 50.5? P(x < 50.5) = 0.4053 P(x < 50.5) = 0.1908 P(x < 50.5) = 0.1421 P(x < 50.5) = 0.0947 In cell B2 of the previous sample spreadsheet, select the correct Excel formula for computing the probability that x is between 49 and 51. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. What is the probability that x is between 49 and 51? P(49 < x < 51) = 0.1271 P(49 < x < 51) = 0.1210 P(49 < x < 51) = 0.0605 P(49 < x < 51) = 0.1089

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Ans Excel formula
(a) 0.1908 =NORM.DIST(50.5,54,4,TRUE)
(b) 0.1210 =NORM.DIST(51,54,4,TRUE)-NORM.DIST(49,54,4,TRUE)
Add a comment
Know the answer?
Add Answer to:
Using Excel - normal probabilities Consider the random variable x that follows a normal distribution, with...
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
  • =POISSON.DIST(3,6.1,FALSE) 1 P(x = 3) 2 P( x3) 3 P(x > 3) You are about to...

    =POISSON.DIST(3,6.1,FALSE) 1 P(x = 3) 2 P( x3) 3 P(x > 3) You are about to watch an under 12 boys indoor soccer game. In cell B1 of the sample spreadsheet, select the correct Excel formula for computing the probability that three fouls will be called in this game. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. The probability that three fouls will be called in this game is 7. (Round your answer to...

  • Given a normal distribution with u = 51 and o = 8, and given you select...

    Given a normal distribution with u = 51 and o = 8, and given you select a sample of n = 100, complete parts (a) through (d). a. What is the probability that X is less than 49? PIX<49) = 0.0061 (Type an integer or decimal rounded to four decimal places as needed.) b. What is the probability that is between 49 and 50.5? P(49< <50.5)= (Type an integer or de mal rounded to four decimal places as needed.).

  • CENGAGE | MINDTAP Q Search this course Ch 05: Mastery Assignment - Discrete Probability Distributions <...

    CENGAGE | MINDTAP Q Search this course Ch 05: Mastery Assignment - Discrete Probability Distributions < Back to Assignment =1-POISSON.DIST(6.1,4, TRUE) =POISSON.DIST(4,6.1, TRUE) Attempts: Average: /4 =POISSON.DIST(4,6.1, FALSE) 10. Using Excel - Poisson probabilities =POISSON.DIST(6.1,4, TRUE) =POISSON.DIST(6,6.1, FALSE) =POISSON.DIST(6.1,4,FALSE) =POISSON.DIST(6.1,6, FALSE) Suppose the number of fouls called per game in an under 16 girls indoor soccer league follows a Poisson distribution with 6.1 fouls per game. Define x as the number of fouls called in a game. You will answer...

  • 5. Using Excel - Entering data and computing averages 5. Using Excel Entering data and computing...

    5. Using Excel - Entering data and computing averages 5. Using Excel Entering data and computing averages You are curious about how many emails you send in a typical 5-day business week. You randomly select ten 5-day business weeks and count how many emails you sent in each. The following table shows the hypothetical results for your sample 120 110 118 134 136 118 131 109 129 101 Enter a label (such as "Emails Sent") in cell A1 of an...

  • Using Excel - Entering data and computing average You are curious about how many emails you...

    Using Excel - Entering data and computing average You are curious about how many emails you receive in a typical day. You randomly select ten days and count how many emails you received in each. The following table shows the hypothetical results for your sample: Enter a label (such as "Emails Received") in cell A1 of an Excel spreadsheet. Then enter your hypothetical results in cells A2 through All. Your spreadsheet should look similar to the following sample spreadsheet: In...

  • 1. Let Xi l be a random sample from a normal distribution with mean μ 50 and variance σ2 16. Find...

    1. Let Xi l be a random sample from a normal distribution with mean μ 50 and variance σ2 16. Find P (49 < Xs <51) and P (49< X <51) 2. Let Y = X1 + X2 + 15 be the sun! of a random sample of size 15 from the population whose + probability density function is given by 0 otherwise 1. Let Xi l be a random sample from a normal distribution with mean μ 50 and...

  • Find the answer using StatCrunch. A random variable X follows a normal distribution with mean 135...

    Find the answer using StatCrunch. A random variable X follows a normal distribution with mean 135 and standard deviation 12. If a sample of size 10 is taken, find P (x̅ < 137). (4 decimal places)

  • Urgent help! Thank you. Given a normal distribution with μ= 51 and σ= 8, and given...

    Urgent help! Thank you. Given a normal distribution with μ= 51 and σ= 8, and given you select a sample of n= 100, complete parts (a) through (d). a. What is the probability that X is less than 49? PR 49) Type an integer or decimal rounded to four decimal places as needed.) b. What is the probability that X is between 49 and 49.5? P(49 <X-49.5)= □ Type an integer or decimal rounded to four decimal places as needed.)...

  • compute p(x) using the binomial probability formula. then determine whether the normal distribution can be used...

    compute p(x) using the binomial probability formula. then determine whether the normal distribution can be used to estimate this probability. if so, p(x) using the normal distribution and compare the result with the exact probability. n=78, p= 0.83, and x=60 for n= 78, p= 0.83, and x=60, find P(x) using the binomial probability distribution. P(x) _. (round to four decimal places as needed.) can the normal distribution be used to approximate this probability? A. no, the normal distribution cannot be...

  • A population of values has a normal distribution with μ=148.3μ=148.3 and σ=92.3σ=92.3. You intend to draw...

    A population of values has a normal distribution with μ=148.3μ=148.3 and σ=92.3σ=92.3. You intend to draw a random sample of size n=49n=49. Find the probability that a single randomly selected value is less than 144.3. P(X < 144.3) = Find the probability that a sample of size n=49n=49 is randomly selected with a mean less than 144.3. P(M < 144.3) = Enter your answers as numbers accurate to 4 decimal places. Answers obtained using exact z-scores or z-scores rounded to...

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