I need the Excel file with formulas. Can you get this back to me by Sunday morning? Are their any other issues with my request?

Here is the case problem:

Quality Associates, Inc, a consulting firm, advises its clients about sampling and statistical procedures that can be used to control their manufacturing processes. In one particular application, a client gave Quality Associates a sample of 800 observations taken during a time in which that client’s process was operating satisfactorily. The sample standard deviation was assumed to be .21; hence, with so much data, the population standard deviation assumed to be .21. Quality Associates then suggested that a random samples of size 30 to be taken periodically to monitor the process on an ongoing basis. By analyzing the new samples, the client could quickly learn whether the process was operating satisfactorily. When the process was not operating satisfactorily, corrective action could be taken to eliminate the problem. The design specification indicated the mean for the process should be 12. The hypothesis test suggested by Quality Associates follows.

Ho: u = 12

Ha: u ≠ 12

Corrective action will be taken any time Ho is rejected.

The data set attached in the excel format were collected at hourly intervals during the first day of operation of the new statistical process control procedure. These data are available in the data set quality.

Answer the falling questions.

1) Conduct a hypothesis test for each sample at the .01 level of significance and determine what action, if any, Should be taken. Provide the test statics and p-value of each test.

2) Compute the standard deviation for each of the four samples. Does the assumption of .21 for the population standard deviation appear reasonable?

3) Compute limits for the sample mean around u=12 such that, as long as a new sample mean is within those limits, the process will be considered to be operating satisfactorily. If the sample mean exceeds the upper limit or if the sample mean is below the lower limit, corrective action will be taken. These limits are referred to as upper and lower control limits for quality control purposes.