Can i get some help with these porblems? Can it be show in excel with the formul
ID: 3174978 • Letter: C
Question
Can i get some help with these porblems? Can it be show in excel with the formulas showing.
Create a Binomial Probability Distribution as follows. Label column A as X Label Column B as P(x) In Column A, list the numbers 0 to 12. What do these numbers represent in our experiment? (Answer here.) Click on cell B2. Click on fx. Choose STATISTICAL then BINOMDIST. In the dialog box: Number_s is the number of successes. Click on cell A2 Trials refers to the total number of trials, in our case 12 donors so type in 12. Probability_s is the probability of success, in our case 40% or .4 since that is the probability of Type Oblood. Cumulative: FALSE calculates the probability of EXACTLY x successes. TRUE calculates the probability of X OR FEWER successes. We are constructing the frequency distribution so we want the EXACT probability for each x. In symbols, we want P(x) for each x = 0, 1, 2, ..., 12. Type in FALSE. Use the fill handle to complete the table for all values of x. Format cells to 3 decimal places. ANSWER THE FOLLOWING QUESTIONS: Each donor gives 1 unit of blood. What is the probability that exactly 5 units collected in this drive will be type O? What is the probability that 5 or fewer units collected in this drive will be type O? Our patient requires 5 units of of Type O blood for his upcoming surgery. What is the probability that this blood drive will get him what he needs (or more)?Explanation / Answer
here in column A list 0 to 12 this number represent number of success in this experiment.
probability that exactly 5 units collected in this drive will be type o is p(x=5) = 0.227030
probability that 5 or fewer units collected in this drive will type o is P(x<= 5) =0.66520
x p(x) 0 0.002176782 1 0.017414259 2 0.063852282 3 0.14189396 4 0.21284094 5 0.227030335 6 0.17657915 7 0.100902371 8 0.042042655 9 0.012457083 10 0.002491417 11 0.00030199 12 0.000016777