Question: Please do this in Excel ( Please do 1-4 and break down each step) THANKS! 1. Cable Co. manufacturers cables for industrial customers. The industrial
Please do this in Excel ( Please do 1-4 and break down each step) THANKS!
1. Cable Co. manufacturers cables for industrial customers. The industrial customers set the minimum requirement for breaking strength of cables as 285kg. The breaking strength of cable produced by them is currently normally distributed with a mean of =298.32kg and a standard deviation of =5.14kg. 2. Compute the C index for the breaking strengths of cables (Round to 2 decimal places) Note: If there is no "upper" specification limit, then you can ignore it when calculating pk index. 3. Cable Co. recently made an investment in its manufacturing process for improving the breaking strength. Assuming that the process mean and standard deviation have not changed by the investment, what is the mean of the sampling distribution for the sample mean X of n=32 cables? (Round to 2 decimal places) Assuming that the process mean and standard deviation have not changed by the investment, what is the standard deviation of the sampling distribution (i.e., standard error) for the sample mean X of n=32 cables? (Round to 2 decimal places) 4. In order to evaluate whether the investment actually improved the breaking strength, Cable Co. randomly chose n=32 cables to measure the breaking strength and its sample mean was 300.37kg. Assuming that the process mean and standard deviation have not changed by the investment, what is the likelihood of observing the sample mean of 300.37kg ? (Round to 4 decimal places)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
