Please show work so I can learn. Also can this be done in excel?

Reducing scrap of 4-foot planks of hardwood is an important factor in reducing cost at a wood-flooring manufacturing company. Accordingly, engineers at Lumberworks are investigating a potential new cutting method involving lateral sawing that may reduce the scrap rate. To examine its viability, samples of 600 and 500 planks, respectively, were examined under the old and new methods. Sixty-three of the 600 planks were scrapped under the old method, whereas 33 of the 500 planks were scrapped under the new method.(You may find it useful to reference the appropriate table:z tableort table)

a.Construct the 95% confidence interval for the difference between the population scrap rates between the old and new methods, respectively.(Negative values should be indicated by a minus sign. Round intermediate calculations to at least 4 decimal places and final answers to 2 decimal places.)

b.Select the null and alternative hypotheses to test for differences in the population scrap rates between the old and new cutting methods, respectively.

• H₀:p₁p₂= 0;H_A:p₁p₂ 0
• H₀:p₁p₂ 0;H_A:p₁p₂> 0
• H₀:p₁p₂ 0;H_A:p₁p₂< 0

c.Using the part a results, can we conclude at the 5% significance level that the scrap rate of the new method is different than the old method?

We ______H0. At the 5% significance level, we________conclude the proportions are different between the old and new methods.