Question: Instructions: Using Microsoft Excel to solve the following problems. Create a new tab for each of the three problems. Use referencing and formulas; no referencing

Instructions: Using Microsoft Excel to solve the following problems. Create a new tab for each of the three problems. Use referencing and formulas; no referencing or formulas will result in a grade of 0 for that question (note: exception being the MRP worksheet - specifics are noted within the problem statement below) Problems / Cases 1. SPC Problem (7 marks) Part 1: Handles must have a 3 inch or 76.2mm centers. Since first developing these handles, we tested the center measurements of our handles to ensure a proper installation onto the drawers and doors. The following four sets of data are the initial measurements in millimeters. Calculate both the X-bar and R chart control limits to three decimal places rounded (4 marks). Is the process in control? ( 1 mark) Why do you say so? Give your reasoning. (2 mark) Samples
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
