i am not able to solve this case in excel .can u please help me out by providing solution

Case 7: Tiresome Tire I When a tire is constructed of more than one ply, the interply shear strength is an important property to check. The specification for a particular type of tire calls for a strength of 2,800 pounds per square inch (psi). The tire manufacturer tests the tires using the null hypothesis H0 : >= 2,800 psi is the mean strength of a large batch of tires. From past experience, it is known that the population standard deviation is 10 psi. Testing the shear strength requires a costly destructive test and therefore the sample size needs to be kept at a minimum. A type I error will result in the rejection of a large number of good tires and is therefore costly. A type II error of passing a faulty batch of tires can result in fatal accidents on the roads, and therefore is extremely costly. (For purposes of this case, the probability of type II error, 3, is always calculated at =2,790 psi.) It is believed that should be at most 1%. Currently, the company conducts the test with a sample size of 40 and an of 5% To help the manufacturer get a clear picture of type I and type II error probabilities, draw a versus chart for sample sizes of 30, 40, 60, and 80. If is to be at most 1 % with = 5% which sample size among these four values is suitable? 1. Calculate the exact sample size required for = 5% and = 1%. Construct a sensitivity analysis table for the required sample size for u(mew) ranging from 2,788 to 2,794 psi and ranging from 1% to 5%. (power n prob) 2. For the current practice of n = 40 and = 5% plot the power curve of the test. Can this chart be used to convince the manufacturer about the high probability of passing batches that have strength of less than 2,800 psi? 3. To present the manufacturer with a comparison of a sample size of 80 versus 40, plot the OC curve for those two sample sizes. Keep an of 5%. 4. The manufacturer is hesitant to increase the sample size beyond 40 due to the concomitant increase in testing costs and, more important, due to the increased time required for the tests. The production process needs to wait until the tests are completed, and that means loss of production time. A suggestion is made by the production manager to increase to 10% as a means of reducing . Give an account of the benefits and the drawbacks of that move. Provide supporting numerical results wherever possible. 5. Identify the issues involved in quality checks of products like tires