Process Capability Analysis Using Cp and Cpk Indices Assignment

Assignment Task

1. See 'Weight loss campaign' tab in Excel file. His weekly weigh-in is charted in the data set. What is the intercept of the data?

2. See 'Correlation & regression' data tab in Excel file.

Adam started a health and fitness programme on Valentine's Day 2022, determined to lose 10kg over 1 year? His weekly weigh-in is charted in the data set. Is there a correlation between calories consumed and weight loss? Give reasons for your answer.

3. Regarding the 'Document data' tab in Excel, and assuming either form A or B can be used following minor modicications, which application form is the best model for timely processing of the applications? Give reasons for your answer

4. See 'Document data' tab in the Excel file. A green belt has recently undertaken to lead a project to reduce the time taken to prepare and review a document. The data refers to the Measure phase of her project only.

You are required to draw the control chart in Excel. Is the process in control? Give reasons for your answer.

5. Referring to the control chart data you have drawn in Excel answer the following question.

An upper specification limit of 60 minutes applied before the project was undertaken. The lower specification limit is 20 minutes. Is the process capable? Give reasons for your answer.

6. Referring to the control chart data you have drawn in Excel answer the following question. In the project Control phase, the green belt succeeded in bring the average processing time down to 30.7 minutes. By how many minutes has the average processing time been reduced?

7. The following data refers to an escrow account managed by a brokering agency. The USL is $250,000 and the LSL is $5,500,000.

The agency is reviewing the months end balances over the past 4 years. In the 48 months the average month-end $value is $2,758,924, with a standard deviation of $268,342. The process capability index Cpk is

a. 0.98
b. 1.33
c. 3.4
d. -1.33

This Data Analysis