AutoSave OFF り × Assignment 4 Tell me Home Insert Draw Page Layout Formulas Data Review View Automate Share Comments Calibri (Body) ✓ 11 ✓ Aˆ A Wrap Text General Insert ✓ Σ ✓ ✓ ✓ Delete ▼ Paste B I U ✓ ✓ Merge & Center $ ✓ %9 .00 →0 Conditional Format Formatting as Table Cell Styles Format ✓ ✓ Sort & Filter Find & Select Analyze Data Sensitivity A1 fx A B C D E F G H J K L M N ○ P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH ΑΙ AJ AK AL AM AN AO AP AQ AR 1 3 2 This problem has two questions: Q1 & Q2. The BrightSpark Electronics plant monitors the temperature of a critical process to ensure product quality. The plant manager has randomly selected 16 temperature readings each day during the production hours and recorded them for quality control purposes. The following table shows the sample data collected during 4 weeks of observation (i.e., 20 production days). Q1: The manager wants to investigate whether the critical process is in statistical control, using the average of temperature readings from the sample. Prepare the control chart (with 99.73% control limits) for the manager. You must show your calculations for making the charts. Your chart should be made by linking to the data on the worksheet, not a picture copied from another source. 4 56 7 8 9 10 11 12 Day 13 1 14 2 15 3 16 4 17 5 18 6 19 7 20 8 21 9 22 10 23 11 24 12 25 13 26 14 27 15 28 16 29 17 30 18 31 19 32 20 1 2 3 4 5 6 16 105.5 104.3 107.9 106.6 104.4 105.2 104.0 103.0 105.7 106.0 107.2 105.6 102.8 103.4 104.6 105.6 106.6 104.1 102.0 104.0 106.5 105.3 104.4 105.5 105.6 102.8 106.4 101.9 103.2 103.7 106.1 108.8 104.2 103.4 106.3 104.0 103.1 105.5 104.3 108.5 104.1 104.6 104.5 105.1 103.3 105.9 107.8 105.0 106.3 103.1 104.9 105.5 106.4 103.8 104.2 103.2 104.8 103.9 105.5 107.1 104.5 104.8 105.8 103.8 104.9 105.2 107.1 106.9 103.9 105.3 103.8 102.6 104.7 104.2 103.7 105.7 104.1 104.5 104.4 106.7 106.5 106.4 105.4 106.4 102.7 106.3 104.8 106.8 104.8 105.8 104.3 104.4 103.5 104.8 104.4 104.8 105.9 108.2 104.6 106.7 104.2 103.2 104.1 104.3 107.3 103.2 104.2 104.1 103.9 102.3 106.2 104.0 103.3 103.3 103.5 103.8 102.4 104.4 102.1 104.9 105.5 103.9 103.0 106.4 103.9 102.1 102.9 104.2 104.8 103.5 104.1 103.7 104.0 107.0 104.9 106.4 102.5 107.6 103.9 103.9 103.4 104.8 105.9 105.2 104.9 106.2 104.6 106.2 104.2 105.6 104.2 105.7 105.3 105.2 107.2 105.8 102.2 103.4 105.6 103.5 106.3 105.6 103.4 104.0 103.7 106.6 106.0 106.5 103.9 105.6 105.5 105.2 104.3 102.8 105.4 104.7 106.8 106.4 105.9 103.4 106.9 104.2 106.9 107.5 103.2 104.6 105.3 102.8 106.2 105.3 106.0 109.0 107.6 107.3 108.8 108.1 106.4 105.9 106.0 102.3 105.9 105.8 106.6 106.1 109.0 104.5 105.2 103.6 103.9 104.9 104.5 105.6 106.7 105.3 106.2 104.0 105.8 104.2 106.5 106.7 104.8 104.0 107.6 106.1 106.7 105.7 105.7 103.8 105.8 103.3 104.2 106.9 106.9 104.2 105.2 102.6 107.5 105.1 106.1 103.5 106.6 104.9 107.2 103.8 103.5 102.9 106.2 104.2 104.7 102.4 106.1 106.3 106.8 103.4 107.2 106.5 105.1 103.5 105.1 102.2 102.8 104.5 106.7 106.1 106.2 105.2 105.7 106.8 104.7 102.2 105.7 106.8 107.0 103.2 104.6 102.5 108.2 104.2 105.4 107.5 105.1 104.7 107.3 106.0 102.8 104.9 105.3 105.2 102.3 103.5 101.8 104.3 103.0 104.6 103.1 103.8 103.1 102.2 104.2 105.4 107.4 104.3 104.4 102.5 107.6 105.3 103.5 103.3 105.9 104.7 105.7 103.9 104.3 105.2 107.1 104.8 104.3 106.8 106.0 105.3 7 Temperature readings (F) 8 9 10 11 12 13 14 15 33 34 35 36 37 38 Q2: The engineers have worked to incorporate newer technology into the above process so the temperature between 102 F and 107 F is expected to be maintained during the process. A new sample of 200 temperature readings were taken at different times/days (see the table below). After the incorporation of new technology, does the process (not the sample) meet the 6-sigma standard for temperature control? Explain your answer. 39 40 41 Temperature Met 6-sigma standard, Yes or No? Explain the reasoning behind your answer 42 (F) 43 104.5 44 104.1 45 104.3 46 104.2 47 103.9 48 103.7 49 104.2 50 104.6 51 105.1 52 104.8 53 102.9 54 55 103.8 103.8 56 103.0 57 103.1 58 103.9 59 104.5 60 105.7 1025 Problem 1 Problem 2 Problem 3 + Ready Accessibility: Investigate A + 70%