Question: use a statistical test to confirm that there is a decrease in the defect rate between the old and new machines and creates a confidence interval that shows the range of decrease or increase of the defect rate.

Note: I just need to know what data I need to use and solve for in excel. for example, n, SD, Kurt, average, difference, etc. and the excel formulas.

You are a production manager for Apple responsible for the manufacture of MacBook circuit boards. You have 6 machines that assemble the boards every day. It costs $50 to make each board. If good, the board is sold in the laptop, and you are given credit for $200 of the sale. If defective, it costs Apple another $15 to properly dispose of the board as e-waste. You are commonly asked to track your daily defect rate, which is the number of defective boards made that day divided by all boards made that day. At a manufacturing conference, you meet representatives from a new firm that claim they can reduce your manufacturing defect rate and improve the overall profit of your manufacturing with new machines. As a test, you replace two of your six machines for $12 million then record the production and defect data of all six machines for 30 days. Apple expects that any purchase cost of manufacturing equipment be made back in 30 months ( 21/2 years). Ready (t)Accessibility: Good to go 5 Does the defect rate decrease? 1. Use a statistical test to confirm that there is a decrease in the defect rate between the old 6 machines and the new ones. 7 2. Create a confidence interval that shows the range of decrease or increase of the defect rate. 8 9 Does profit increase enough to cover the cost of the machines? 3. Use a statistical test to confirm that the increase in expected profit from your manufacturing division can cover the cost of replacing your other four machines in the 30 months Apple 10 requires. 4. Create a confidence interval for the expected increase or decrease in annual profit per 11 machine. 12 13 What do you tell your boss? 5. Summarize your results to your boss. Provide a recommendation on whether to buy the 14 additional four machines and why, backed by data