PLEASE SHOW HOW TO DO IT AND THE EXCEL SHEET WORK FOR IT

The following table contains the measurements of the key length dimension from a fuel injector. These samples of size five were taken at one-hour intervals. Use three-sigma control limits. Use Exhibit 13.7. SAMPLE NUMBER 1 2 3 4 5 6 7 8 9 10 11 12 13 1 0.475 0.488 0.485 0.484 0.461 0.462 0.486 0.529 0.492 0.491 0.485 0.483 0.528 0.481 0.487 0.462 0.471 0.499 0.507 0.503 OBSERVATIONS 2 3 4 0.487 0.486 0.514 0.507 0.516 0.495 0.486 0.511 0.486 0.507 0.486 0.487 0.504 0.518 0.467 0.492 0.506 0.490 0.506 0.487 0.478 0.505 0.483 0.479 0.507 0.514 0.508 0.506 0.516 0.514 0.486 0.468 0.489 0.458 0.520 0.508 0.506 0.490 0.528 0.528 0.506 0.498 0.516 0.482 0.514 0.507 0.479 0.479 0.491 0.513 0.476 0.486 0.490 0.477 0.534 0.487 0.491 0.487 0.480 0.508 5 0.477 0.519 0.523 0.487 0.481 0.509 0.508 0.482 0.498 0.491 0.495 0.524 0.508 0.504 0.507 0.518 0.495 0.479 0.488 0.506 14 15 16 17 18 19 20 a. Calculate the mean and range for the above samples. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Mean Range Sample Number 1 2 ) 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 b. Determine X and R. (Do not round intermediate calculations. Round your answers to 3 decimal places.) X R c. Determine the UCL and LCL for a X-chart. (Do not round intermediate calculations. Round your answers to 3 decimal places.) UCL LCL d. Determine the UCL and LCL for R-chart. (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 3 decimal places.) UCL LCL e. What comments can you make about the process? The process is in statistical control. The process is out of statistical control