Question

Most important in the work below is to show THE FORMULA'S USED IN EXCEL especially for the table asked to be built in (c).

5. According to a recent study, 9% of adults have been diagnosed with diabetes. 8 adults are randomly selected and then each is tested to see if she or he has diabetes. Use this situation to answer the parts below.

(a) Recognizing that this is a binomial situation, give the meaning S and F in this context. That is, define what you will classify as a "success" and what you will classify as a "failure" as it refers to diabetes. S = F =

(b) Next, give the values of n, p, and q. n = p= q=

(c) Construct the complete binomial probability distribution for this situation in a table out to the right.

(d) Using your table, find the probability that exactly two adults have diabetes.

(e) Find the probability that at least 1 adults have diabetes.

(f) Find the probability that less than two adults are diabetic.

(g) Find the mean and standard deviation of this binomial probability distribution.

(h) By writing a sentence, interpret the meaning of the mean value found in (g) as tied to the context of adults with diabetes.

(i) Is it unusual to have 2 adults with diabetes? Briefly explain your answer giving supporting numerical evidence. (Hint: 2 Sigma Rule)

Answer 1