PLEASE USE EXCEL AND EXPLAIN EVERYTHING THOROUGHLY

The Money Pit Mortgage Company is interested in monitoring the performance of the mortgage process. Fifteen samples of five completed mortgage transactions each were taken during a period when the process was believed to be in control. The times to complete the transactions were measured. The Money Pit Mortgage Company made some changes to the process and undertook a process capability study. The following data were obtained for 15 samples of size 5. Based on the individual observations, management estimated the process standard deviation to be 4.63 (days) for use in the process capability analysis. The lower and upper specification limits (in days) for the mortgage process times were 8 and 27. D Sample Mean Range 1 12 12 2 14 15 3 10 6 4 18 13 5 15 12 6 14 10 7 19 10 8 18 17 9 15 16 10 16 13 11 20 7 12 11 8 13 17 14 14 16 12 15 11 13 a. Calculate the process capability index and the process capability ratio values. The process capability index Cpk = (Enter your response rounded to three decimal places.)