Question

In: Statistics and Probability

using excel software If 84.3% of Canadian homes have Internet access, find the probability that in...

using excel software If 84.3% of Canadian homes have Internet access, find the probability that in a random sample of 15 Canadians that:

a. Exactly 13 have Internet access.

b. Between 12 and 14, inclusive, have Internet access.

c. At least 13 have Internet access.

d. At most 13 have Internet access.

Solutions

Expert Solution

BIONOMIAL DISTRIBUTION
pmf of B.D is = f ( k ) = ( n k ) p^k * ( 1- p) ^ n-k
where   
k = number of successes in trials
n = is the number of independent trials
p = probability of success on each trial
I.
mean = np
where
n = total number of repetitions experiment is executed
p = success probability
mean = 15 * 0.843
= 12.645
II.
variance = npq
where
n = total number of repetitions experiment is executed
p = success probability
q = failure probability
variance = 15 * 0.843 * 0.157
= 1.9853
III.
standard deviation = sqrt( variance ) = sqrt(1.9853)
=1.409
a.
probability that exactly 13 have internet access
P( X = 13 ) = ( 15 13 ) * ( 0.843^13) * ( 1 - 0.843 )^2
= 0.281
b.
probability that between 12 and 14 inclusive have internet access
To find P(a < = Z < = b) = F(b) - F(a)
P( X < 12) = P(X=11) + P(X=10) + P(X=9) + P(X=8) + P(X=7) + P(X=6) + P(X=5) + P(X=4) + P(X=3) + P(X=2)
= ( 15 11 ) * 0.843^11 * ( 1- 0.843 ) ^4 + ( 15 10 ) * 0.843^10 * ( 1- 0.843 ) ^5 + ( 15 9 ) * 0.843^9 * ( 1- 0.843 ) ^6 + ( 15 8 ) * 0.843^8 * ( 1- 0.843 ) ^7 + ( 15 7 ) * 0.843^7 * ( 1- 0.843 ) ^8 + ( 15 6 ) * 0.843^6 * ( 1- 0.843 ) ^9 + ( 15 5 ) * 0.843^5 * ( 1- 0.843 ) ^10 + ( 15 4 ) * 0.843^4 * ( 1- 0.843 ) ^11 + ( 15 3 ) * 0.843^3 * ( 1- 0.843 ) ^12 + ( 15 2 ) * 0.843^2 * ( 1- 0.843 ) ^13
= 0.1994
P( X < 14) = P(X=13) + P(X=12) + P(X=11) + P(X=10) + P(X=9) + P(X=8) + P(X=7) + P(X=6) + P(X=5) + P(X=4)
= ( 15 13 ) * 0.843^13 * ( 1- 0.843 ) ^2 + ( 15 12 ) * 0.843^12 * ( 1- 0.843 ) ^3 + ( 15 11 ) * 0.843^11 * ( 1- 0.843 ) ^4 + ( 15 10 ) * 0.843^10 * ( 1- 0.843 ) ^5 + ( 15 9 ) * 0.843^9 * ( 1- 0.843 ) ^6 + ( 15 8 ) * 0.843^8 * ( 1- 0.843 ) ^7 + ( 15 7 ) * 0.843^7 * ( 1- 0.843 ) ^8 + ( 15 6 ) * 0.843^6 * ( 1- 0.843 ) ^9 + ( 15 5 ) * 0.843^5 * ( 1- 0.843 ) ^10 + ( 15 4 ) * 0.843^4 * ( 1- 0.843 ) ^11
= 0.7073
P(12 < X < 14) = 0.7073-0.1994 =0.5079
c.
probability that at least 13 have internet access
P( X < 13) = P(X=12) + P(X=11) + P(X=10) + P(X=9) + P(X=8) + P(X=7) + P(X=6) + P(X=5) + P(X=4) + P(X=3) +
= ( 15 12 ) * 0.843^12 * ( 1- 0.843 ) ^3 + ( 15 11 ) * 0.843^11 * ( 1- 0.843 ) ^4 + ( 15 10 ) * 0.843^10 * ( 1- 0.843 ) ^5 + ( 15 9 ) * 0.843^9 * ( 1- 0.843 ) ^6 + ( 15 8 ) * 0.843^8 * ( 1- 0.843 ) ^7 + ( 15 7 ) * 0.843^7 * ( 1- 0.843 ) ^8 + ( 15 6 ) * 0.843^6 * ( 1- 0.843 ) ^9 + ( 15 5 ) * 0.843^5 * ( 1- 0.843 ) ^10 + ( 15 4 ) * 0.843^4 * ( 1- 0.843 ) ^11 + ( 15 3 ) * 0.843^3 * ( 1- 0.843 ) ^12
= 0.4262
P( X > = 13 ) = 1 - P( X < 13) = 0.5738
d.
probability that atmost 13 have internet access
P( X < = 13) = P(X=13) + P(X=12) + P(X=11) + P(X=10) + P(X=9) + P(X=8) + P(X=7) + P(X=6) + P(X=5) + P(X=4) + P(X=3)   
= ( 15 13 ) * 0.843^13 * ( 1- 0.843 ) ^2 + ( 15 12 ) * 0.843^12 * ( 1- 0.843 ) ^3 + ( 15 11 ) * 0.843^11 * ( 1- 0.843 ) ^4 + ( 15 10 ) * 0.843^10 * ( 1- 0.843 ) ^5 + ( 15 9 ) * 0.843^9 * ( 1- 0.843 ) ^6 + ( 15 8 ) * 0.843^8 * ( 1- 0.843 ) ^7 + ( 15 7 ) * 0.843^7 * ( 1- 0.843 ) ^8 + ( 15 6 ) * 0.843^6 * ( 1- 0.843 ) ^9 + ( 15 5 ) * 0.843^5 * ( 1- 0.843 ) ^10 + ( 15 4 ) * 0.843^4 * ( 1- 0.843 ) ^11 + ( 15 3 ) * 0.843^3 * ( 1- 0.843 ) ^12 +
= 0.7073


Related Solutions

The 2018 Canadian internet use survey showed, overall, 94% of Canadians had home internet access, and...
The 2018 Canadian internet use survey showed, overall, 94% of Canadians had home internet access, and about 85% of the internet users bought goods or services online, spending $57.4 billion. Suppose 64 internet users with home internet access were randomly and independently sampled. Find the probability that at least 25% of those sampled currently did not buy goods or services online. Round your answers to the nearest ten-thousandth (4 decimals).
The 2018 Canadian internet use survey showed, overall, 94% of Canadians had home internet access, and...
The 2018 Canadian internet use survey showed, overall, 94% of Canadians had home internet access, and about 84% of the internet users bought goods or services online, spending $57.4 billion. Suppose 64 internet users with home internet access were randomly and independently sampled. Find the probability that at least 20% of those sampled currently did not buy goods or services online. Round your answers to the nearest ten-thousandth (4 decimals).
Mainstream spreadsheet and database software, such as Excel and Access, are often sufficient for analyzing the...
Mainstream spreadsheet and database software, such as Excel and Access, are often sufficient for analyzing the variety and volume presented by big data. T or F ? Organizations that spend more on legacy systems tend to experience a lower incidence of security breaches. True or False ? One of the challenges the accounting profession faces is that the tools accountants have traditionally used are ill-equipped for analyzing the types and quantity of data present in big data. True or Flase
Using the internet, find examples of IS projects that have failed. Were these easy to find?...
Using the internet, find examples of IS projects that have failed. Were these easy to find? if not, explain some of the reasons why organizations do not publicize project failures. Answer the question in great detail 5-7 sentences.
I have an access link to the internet (Institutional Router to Internet Router) that is 1...
I have an access link to the internet (Institutional Router to Internet Router) that is 1 Gbps access link. Suppose that on my network there are typically 1000 Requests/second going to the Internet that are each 1 Mbits. Calculate the traffic intensity on the access link. What does this number imply about delays on my network?
a/Use Excel to find the discrete probability and cumulative probability of the Binomial distribution with probability...
a/Use Excel to find the discrete probability and cumulative probability of the Binomial distribution with probability of success p = 0.75 and n = 80. Find its mean and variance. b/Based upon Excel chart, what can you conclude about the binomial convergence? Hint: Use binom.dist function on Excel and sketch the curve.
Find an article on the Internet about a software deployment problem that happened in the last...
Find an article on the Internet about a software deployment problem that happened in the last year. 2.Create an MS Word document and write up a brief (2 paragraph) summary of what happened and the link to the article. Include in your summary who the problem impacted and how it impacted them?
On the internet (e.g., the Micron Technologies web site) find the access time and size of...
On the internet (e.g., the Micron Technologies web site) find the access time and size of a state-of-the-art a) DRAM chip b) SRAM chip c) FLASH chip
find the mean using excel 1,2,3,11,22,33
find the mean using excel 1,2,3,11,22,33
Calculate the following binomial probability by either using one of the binomial probability tables, software, or...
Calculate the following binomial probability by either using one of the binomial probability tables, software, or a calculator using the formula below. Round your answer to 3 decimal places. P(x | n, p) = n! (n − x)! x! · px · qn − x where q = 1 − p P(x > 15, n = 20, p = 0.8) =
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT