Keeping in mind data set for site 1 is 1000 and for site 2 is 1000

A chip manufacturer observes that chips seem to be failing in two different ways. The manufacturer is trying to determine whether or not the two failures are independent , but believes that they are independent. After testing a thousand chips, give in El the number failures at site 1, and the number in E2 the number of failures at site 2, and at E3 the number of failures at both sites. If the two failures are independent, use the proportion of observed failures at site 1 and the proportion of observed failures at site 2 to give in ES the number of samples expected to fail at both sites from a sample of size one thousand. We will compare the number of failures observed at both sites with the number expected. Give the lower and upper bounds for a 90% confidence interval for the number of failures at both sites, assuming independence. If the observed number of failures at both sites is within this confidence interval display "YES" in E10, otherwise display NOInsert Formulas Data Home Draw Page Layout Review Arial1 - 11 E General Conditional Formatting * Insert BIU- AA $ * % " Format as Table Delete a A 28 98 Cell Styles Analyz Format Data board Font Alignment Number Styles Cells Editing Analyst X V fx A B C D E F G H Site 1 Site 2 # of failures at site 1 114 N N # of failures at site 2 118 N N # of failures at both 232 Y N N N expected # of failures at both if independent N N N N lower bound for 90% confidence interval N N upper bound for 90% confidence interval N Y N N independent? N N N Y N N N N : ZZ Z Z 2 2 2 2 2 2 2 2 2 2 2 2 2