Question

In: Statistics and Probability

USING EXCEL: Consider the probability that no fewer than 75 out of 111 houses will lose...

USING EXCEL:

Consider the probability that no fewer than 75 out of 111 houses will lose power once a year. Assume the probability that a given house will lose power once a year is 98%

Specify whether the normal curve can be used as an approximation to the binomial probability by verifying the necessary conditions.

PLEASE USE EXCEL AND SHOW EXCEL FORMULAS USED FOR SOLUTION. THANK YOU!!

Solutions

Expert Solution

Solution:

Given:

n = sample size = Number of houses = 111

p = probability that a given house will lose power once a year = 98% = 0.98

X = Number of houses will lose power once a year follows a binomial distribution with parameters n = 111 and p = 0.98

We have to check if the normal curve can be used as an approximation to the binomial probability by verifying the necessary conditions.

The necessary conditions are :

and

Thus we get:

Since second condition is not satisfied , we can not use the normal curve as an approximation to the binomial probability.

Thus we need to use Binomial probability to find the probability.

We have to find:

P( No fewer than 75 out of 111 houses will lose power once a year ) = ........?

That is:

P( 75 or more houses out of 111 houses will lose power once a year ) =.........?

That is:

We need to use Excel command:

=1-BINOM.DIST(x , trials , probability , cumulative)

=1 - BINOM.DIST(74, 111, 0.98, TRUE)

=1

Thus required answer is:

the probability that no fewer than 75 out of 111 houses will lose power once a year is 1.


Related Solutions

Consider the probability that fewer than 19 out of 156 people have been in a car...
Consider the probability that fewer than 19 out of 156 people have been in a car accident. Assume the probability that a given person has been in a car accident is 8%. Aprroximate the probability using the normal distribution. Round your answer to four decimal places. Need answer ASAP thanks!
Consider the probability that no less than 21 out of 329 students will not pass their...
Consider the probability that no less than 21 out of 329 students will not pass their college placement exams. Choose the best description of the area under the normal curve that would be used to approximate binomial probability. OPTIONS ARE: Area to the right of 20.5 Area to the right of 21.5 Area to left of 20.5 Area to left of 21.5 Area between 20.5 and 21.5
Consider the probability that no less than 21 out of 329 students will not pass their...
Consider the probability that no less than 21 out of 329 students will not pass their college placement exams. Choose the best description of the area under the normal curve that would be used to approximate binomial probability. OPTIONS ARE: Area to the right of 20.5 Area to the right of 21.5 Area to left of 20.5 Area to left of 21.5 Area between 20.5 and 21.5
Consider the probability that no less than 88 out of 158 computers will not crash in...
Consider the probability that no less than 88 out of 158 computers will not crash in a day. Assume the probability that a given computer will not crash in a day is 57%. Approximate the probability using the normal distribution. Round your answer to four decimal places.
Consider the probability that no more than 49 out of 140 students will graduate on time....
Consider the probability that no more than 49 out of 140 students will graduate on time. Assume the probability that a given student will graduate on time is 64%. Specify whether the normal curve can be used as an approximation to the binomial probability by verifying the necessary conditions.
Consider the probability that greater than 8888 out of 151151 people have not been in a...
Consider the probability that greater than 8888 out of 151151 people have not been in a car accident. Assume the probability that a given person has not been in a car accident is 57%57%. Approximate the probability using the normal distribution. Round your answer to four decimal places.
Consider the probability that more than 99 out of 159 people have not been in a...
Consider the probability that more than 99 out of 159 people have not been in a car accident. Assume the probability that a given person has not been in a car accident is 61%. Approximate the probability using the normal distribution.
Consider the probability that greater than 99 out of 157 people have not been in a...
Consider the probability that greater than 99 out of 157 people have not been in a car accident. Assume the probability that a given person has not been in a car accident is 55%. Approximate the probability using the normal distribution. Round your answer to four decimal places.
Consider the probability that more than 92 out of 160 flights will be on-time. Assume the...
Consider the probability that more than 92 out of 160 flights will be on-time. Assume the probability that a given flight will be on-time is 65%. Approximate the probability using the normal distribution. Round your answer to four decimal places.
Consider the probability that no less than 92 out of 157 registered voters will vote in...
Consider the probability that no less than 92 out of 157 registered voters will vote in the presidential election. Assume the probability that a given registered voter will vote in the presidential election is 64% Approximate the probability using the normal distribution. Round your answer to four decimal places.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT