(Use Excel) The quality manager believes there may be a relationship between the experience level of an inspector and whether a product passes or fails inspection. Inspection records were reviewed for 630 units of a particular product, and the number of units which passed and failed inspection was determined based on three inspector experience levels. The results are shown in the following table.

a. Specify the competing hypotheses to determine whether the inspector pass/fail decision depends on experience level.
b. Calculate the value of the test statistic.
c. Use Excel's CHISQ.DIST.RT function to calculate the p-value.
d. At the 5% significance level, what is your conclusion? Does your conclusion change at the 1% significance level?

Transcribed Image Text:

Experience Level Medium Low High Decision <2 years) (2-8 years) 8 years) Pass Fail 152 16 287 46 103 26