Answer the following Poisson exercises using the Excel function "Poisson" in your equation.
Enter your Excel equations in the highlighted cells.
#1
A textile manufacturer process finds that on average, two flaws occurs per every 50 yards of material produced.
a. Write the Excel equation, using an Excel function, that will calculate the probability of exactly one flaws in a 50-yard piece of material.
b. Write the Excel equation, using an Excel function, thawwill calculate the probability of three or less flaws in a 50-yard piece of material.
c. Write the Excel equation, using an Excel function, that will calculate the probability of three or more flaws in a 50-yard piece of material.
d. Write the Excel equation, using an Excel function, that will calculate the probability of two or less flaws in a 25-yard piece of material.