Practice Machine 1 Machine 2 Machine 3 Machine 4 Machine 5 Machine 6 11.55 11.62 11.52 11.75 11.90 11.64 11.80 12.03 11.94 11.92 12.13 12.09 11.93 12.21 12.32 11.93 11.85 11.76 12.16 11.77 12.00 12.04 11.98 12.30 12.18 11.97 12.17 11.85 12.30 12.15 11.55 11.62 11.52 11.75 11.90 11.64 11.80 12.03 11.94 11.62 11.69 11.59 11.82 11.97 11.71 11.87 12.10 12.01 11.99 12.20 12.16 12.00 12.28 12.39 12.00 11.92 11.83 12.23 11.84 12.07 12.11 12.05 12.37 12.25 12.04 12.24 11.92 12.37 12.22 11.62 11.69 11.59 11.82 11.97 11.71 11.87 12.10 12.01 11.91 11.36 11.75 11.95 12.14 11.72 11.61 11.85 12.16 11.91 12.12 11.61 12.21 11.56 11.95 12.01 12.06 11.76 11.82 12.12 11.60 11.95 11.96 12.22 11.75 11.96 11.95 11.89 11.88 11.93 11.91 11.36 11.75 11.95 12.14 11.72 11.61 11.85 12.16 12.02 12.02 12.05 12.18 12.11 12.07 12.05 11.64 12.39 11.65 12.11 11.90 12.22 11.88 12.03 12.35 12.09 11.77 12.20 11.79 12.30 12.27 12.29 12.47 12.03 12.17 11.94 11.97 12.23 12.25 12.02 12.02 12.05 12.18 12.11 12.07 12.05 11.64 12.39 Page 1 11.80 12.03 11.94 11.92 12.13 12.09 11.93 12.21 12.32 11.93 11.85 11.76 12.16 11.77 12.00 12.04 11.98 12.30 12.18 11.97 12.17 11.85 12.30 12.15 11.77 12.00 12.04 11.98 12.30 12.18 11.97 12.17 11.85 12.30 11.80 12.03 11.94 11.92 12.13 11.87 12.10 12.01 11.99 12.20 12.16 12.00 12.28 12.39 12.00 11.92 11.83 12.23 11.84 12.07 12.11 12.05 12.37 12.25 12.04 12.24 11.92 12.37 12.22 11.84 12.07 12.11 12.05 12.37 12.25 12.04 12.24 11.92 12.37 11.87 12.10 12.01 11.99 12.20 Practice 11.92 12.13 12.09 11.93 12.21 12.32 11.93 11.85 11.76 12.16 11.77 12.00 12.04 11.98 12.30 12.18 11.97 12.17 11.85 12.30 12.15 11.55 11.62 11.52 11.75 11.90 11.64 11.80 12.03 11.94 11.92 12.13 12.09 11.93 12.21 12.32 11.93 11.85 11.76 12.16 11.99 12.20 12.16 12.00 12.28 12.39 12.00 11.92 11.83 12.23 11.84 12.07 12.11 12.05 12.37 12.25 12.04 12.24 11.92 12.37 12.22 11.62 11.69 11.59 11.82 11.97 11.71 11.87 12.10 12.01 11.99 12.20 12.16 12.00 12.28 12.39 12.00 11.92 11.83 12.23 11.91 12.12 11.61 12.21 11.56 11.95 12.01 12.06 11.76 11.82 12.12 11.60 11.95 11.96 12.22 11.75 11.96 11.95 11.89 11.88 11.93 11.91 11.36 11.75 11.95 12.14 11.72 11.61 11.85 12.16 11.91 12.12 11.61 12.21 11.56 11.95 12.01 12.06 11.76 11.82 11.65 12.11 11.90 12.22 11.88 12.03 12.35 12.09 11.77 12.20 11.79 12.30 12.27 12.29 12.47 12.03 12.17 11.94 11.97 12.23 12.25 12.02 12.02 12.05 12.18 12.11 12.07 12.05 11.64 12.39 11.65 12.11 11.90 12.22 11.88 12.03 12.35 12.09 11.77 12.20 Page 2 12.09 11.93 12.21 12.32 11.93 11.85 11.76 12.16 11.77 12.00 12.04 11.98 12.30 12.18 11.97 12.17 11.85 12.30 12.15 11.77 12.00 12.04 11.98 12.30 12.18 11.97 12.17 11.85 12.30 11.80 12.03 11.94 11.92 12.13 12.09 11.93 12.21 12.32 11.93 11.85 12.16 12.00 12.28 12.39 12.00 11.92 11.83 12.23 11.84 12.07 12.11 12.05 12.37 12.25 12.04 12.24 11.92 12.37 12.22 11.84 12.07 12.11 12.05 12.37 12.25 12.04 12.24 11.92 12.37 11.87 12.10 12.01 11.99 12.20 12.16 12.00 12.28 12.39 12.00 11.92 Practice 11.77 12.00 12.04 11.98 12.30 12.18 11.97 12.17 11.85 12.30 12.15 11.77 12.00 12.04 11.98 12.30 12.18 11.97 12.17 11.85 12.30 11.84 12.07 12.11 12.05 12.37 12.25 12.04 12.24 11.92 12.37 12.22 11.84 12.07 12.11 12.05 12.37 12.25 12.04 12.24 11.92 12.37 12.12 11.60 11.95 11.96 12.22 11.75 11.96 11.95 11.89 11.88 11.93 12.12 11.60 11.95 11.96 12.22 11.75 11.96 11.95 11.89 11.88 11.79 12.30 12.27 12.29 12.47 12.03 12.17 11.94 11.97 12.23 12.25 11.79 12.30 12.27 12.29 12.47 12.03 12.17 11.94 11.97 12.23 Page 3 11.76 12.16 11.77 12.00 12.04 11.98 12.30 12.18 11.97 12.17 11.85 12.30 12.15 11.77 12.00 12.04 11.98 12.30 12.18 11.97 12.17 11.83 12.23 11.84 12.07 12.11 12.05 12.37 12.25 12.04 12.24 11.92 12.37 12.22 11.84 12.07 12.11 12.05 12.37 12.25 12.04 12.24 Practice Machine 7 Machine 8 11.61 11.85 12.16 11.91 12.12 11.61 12.21 11.56 11.95 12.01 12.06 11.76 11.82 12.12 11.60 11.95 11.96 12.22 11.75 11.96 11.95 11.89 11.88 11.93 12.12 11.60 11.95 11.96 12.22 11.75 11.96 11.95 11.89 11.88 11.61 11.85 12.16 11.91 12.12 12.05 11.64 12.39 11.65 12.11 11.90 12.22 11.88 12.03 12.35 12.09 11.77 12.20 11.79 12.30 12.27 12.29 12.47 12.03 12.17 11.94 11.97 12.23 12.25 11.79 12.30 12.27 12.29 12.47 12.03 12.17 11.94 11.97 12.23 12.05 11.64 12.39 11.65 12.11 Page 4 Practice 11.61 12.21 11.56 11.95 12.01 12.06 11.76 11.82 12.12 11.60 11.95 11.96 12.22 11.75 11.96 11.95 11.89 11.88 11.93 12.12 11.60 11.95 11.96 12.22 11.75 11.96 11.95 11.89 11.88 11.61 11.85 12.16 11.91 12.12 11.61 12.21 11.56 11.95 12.01 12.06 11.90 12.22 11.88 12.03 12.35 12.09 11.77 12.20 11.79 12.30 12.27 12.29 12.47 12.03 12.17 11.94 11.97 12.23 12.25 11.79 12.30 12.27 12.29 12.47 12.03 12.17 11.94 11.97 12.23 12.05 11.64 12.39 11.65 12.11 11.90 12.22 11.88 12.03 12.35 12.09 Page 5 Practice 11.76 11.82 12.12 11.60 11.95 11.96 12.22 11.75 11.96 11.95 11.89 11.88 11.93 12.12 11.60 11.95 11.96 12.22 11.75 11.96 11.95 11.77 12.20 11.79 12.30 12.27 12.29 12.47 12.03 12.17 11.94 11.97 12.23 12.25 11.79 12.30 12.27 12.29 12.47 12.03 12.17 11.94 Page 6 Assignment Machine 1 Machine 2 Machine 3 Machine 4 Machine 5 Machine 6 11.85 11.95 11.77 12.05 12.23 11.89 12.10 12.36 12.19 12.22 12.46 12.34 12.23 12.54 12.57 12.23 12.18 12.01 12.46 12.10 12.25 12.34 12.31 12.55 12.48 12.30 12.42 12.15 12.63 12.40 11.85 11.95 11.77 12.05 12.23 11.89 12.10 12.36 12.19 11.92 12.02 11.84 12.12 12.30 11.96 12.17 12.43 12.26 12.29 12.53 12.41 12.30 12.61 12.64 12.30 12.25 12.08 12.53 12.17 12.32 12.41 12.38 12.62 12.55 12.37 12.49 12.22 12.70 12.47 11.92 12.02 11.84 12.12 12.30 11.96 12.17 12.43 12.26 12.21 11.69 12.00 12.25 12.47 11.97 11.91 12.18 12.41 12.21 12.45 11.86 12.51 11.89 12.20 12.31 12.39 12.01 12.12 12.45 11.85 12.25 12.29 12.47 12.05 12.29 12.20 12.19 12.21 12.18 12.21 11.69 12.00 12.25 12.47 11.97 11.91 12.18 12.41 12.32 12.35 12.30 12.48 12.44 12.32 12.35 11.97 12.64 11.95 12.44 12.15 12.52 12.21 12.28 12.65 12.42 12.02 12.50 12.12 12.55 12.57 12.62 12.72 12.33 12.50 12.19 12.27 12.56 12.50 12.32 12.35 12.30 12.48 12.44 12.32 12.35 11.97 12.64 Page 7 12.10 12.36 12.19 12.22 12.46 12.34 12.23 12.54 12.57 12.23 12.18 12.01 12.46 12.10 12.25 12.34 12.31 12.55 12.48 12.30 12.42 12.15 12.63 12.40 12.07 12.33 12.29 12.28 12.63 12.43 12.27 12.50 12.10 12.60 12.13 12.28 12.24 12.25 12.38 12.17 12.43 12.26 12.29 12.53 12.41 12.30 12.61 12.64 12.30 12.25 12.08 12.53 12.17 12.32 12.41 12.38 12.62 12.55 12.37 12.49 12.22 12.70 12.47 12.14 12.40 12.36 12.35 12.70 12.50 12.34 12.57 12.17 12.67 12.20 12.35 12.31 12.32 12.45 Assignment 12.22 12.46 12.34 12.23 12.51 12.65 12.18 12.15 12.09 12.41 12.07 12.33 12.29 12.28 12.63 12.43 12.27 12.50 12.10 12.60 12.48 11.80 11.92 11.85 12.00 12.20 11.97 12.05 12.33 12.27 12.17 12.43 12.42 12.18 12.51 12.65 12.18 12.15 12.09 12.41 12.29 12.53 12.41 12.30 12.58 12.72 12.25 12.22 12.16 12.48 12.14 12.40 12.36 12.35 12.70 12.50 12.34 12.57 12.17 12.67 12.55 11.87 11.99 11.92 12.07 12.27 12.04 12.12 12.40 12.34 12.24 12.50 12.49 12.25 12.58 12.72 12.25 12.22 12.16 12.48 12.21 12.45 11.86 12.51 11.86 12.28 12.26 12.36 12.09 12.07 12.42 11.93 12.20 12.26 12.55 12.00 12.26 12.28 12.14 12.18 12.26 12.16 11.66 12.08 12.20 12.44 12.05 11.86 12.15 12.49 12.16 12.42 11.94 12.46 11.86 12.28 12.26 12.36 12.09 12.07 11.95 12.44 12.15 12.52 12.18 12.36 12.60 12.39 12.10 12.45 12.09 12.63 12.52 12.59 12.80 12.28 12.47 12.27 12.22 12.53 12.58 12.27 12.32 12.38 12.43 12.41 12.40 12.30 11.94 12.72 11.90 12.41 12.23 12.47 12.18 12.36 12.60 12.39 12.10 12.45 Page 8 12.39 12.26 12.46 12.62 12.23 12.18 12.01 12.46 12.10 12.25 12.34 12.31 12.55 12.48 12.30 12.42 12.15 12.63 12.40 12.07 12.33 12.29 12.28 12.63 12.43 12.27 12.50 12.10 12.60 12.13 12.28 12.24 12.25 12.38 12.39 12.26 12.46 12.62 12.26 12.10 12.46 12.33 12.53 12.69 12.30 12.25 12.08 12.53 12.17 12.32 12.41 12.38 12.62 12.55 12.37 12.49 12.22 12.70 12.47 12.14 12.40 12.36 12.35 12.70 12.50 12.34 12.57 12.17 12.67 12.20 12.35 12.31 12.32 12.45 12.46 12.33 12.53 12.69 12.33 12.17 Assignment 12.07 12.33 12.29 12.28 12.63 12.43 12.27 12.47 12.18 12.55 12.45 12.10 12.25 12.34 12.31 12.55 12.48 12.30 12.42 12.15 12.60 12.14 12.40 12.36 12.35 12.70 12.50 12.34 12.54 12.25 12.62 12.52 12.17 12.32 12.41 12.38 12.62 12.55 12.37 12.49 12.22 12.67 12.42 11.93 12.20 12.26 12.55 12.00 12.26 12.25 12.22 12.13 12.23 12.45 11.85 12.25 12.29 12.47 12.05 12.29 12.20 12.19 12.18 12.09 12.63 12.52 12.59 12.80 12.28 12.47 12.24 12.30 12.48 12.55 12.12 12.55 12.57 12.62 12.72 12.33 12.50 12.19 12.27 12.53 Page 9 12.06 12.49 12.02 12.30 12.37 12.23 12.60 12.48 12.30 12.42 12.15 12.63 12.40 12.07 12.33 12.29 12.28 12.63 12.43 12.27 12.47 12.13 12.56 12.09 12.37 12.44 12.30 12.67 12.55 12.37 12.49 12.22 12.70 12.47 12.14 12.40 12.36 12.35 12.70 12.50 12.34 12.54 Assignment Machine 7 Machine 8 11.91 12.18 12.41 12.21 12.45 11.86 12.51 11.89 12.20 12.31 12.39 12.01 12.12 12.45 11.85 12.25 12.29 12.47 12.05 12.29 12.20 12.19 12.21 12.18 12.42 11.93 12.20 12.26 12.55 12.00 12.26 12.28 12.14 12.18 11.94 12.10 12.46 12.24 12.37 12.35 11.97 12.64 11.95 12.44 12.15 12.52 12.21 12.28 12.65 12.42 12.02 12.50 12.12 12.55 12.57 12.62 12.72 12.33 12.50 12.19 12.27 12.56 12.50 12.09 12.63 12.52 12.59 12.80 12.28 12.47 12.27 12.22 12.53 12.38 11.89 12.69 11.98 12.36 Page 10 Assignment 11.91 12.54 11.81 12.25 12.31 12.39 12.01 12.12 12.45 11.85 12.25 12.29 12.47 12.05 12.29 12.20 12.19 12.21 12.18 12.42 11.93 12.20 12.26 12.55 12.00 12.26 12.28 12.14 12.18 11.94 12.10 12.46 12.24 12.37 11.91 12.54 11.81 12.25 12.34 12.31 12.20 12.55 12.13 12.33 12.65 12.42 12.02 12.50 12.12 12.55 12.57 12.62 12.72 12.33 12.50 12.19 12.27 12.56 12.50 12.09 12.63 12.52 12.59 12.80 12.28 12.47 12.27 12.22 12.53 12.38 11.89 12.69 11.98 12.36 12.20 12.55 12.13 12.33 12.68 12.34 Page 11 Assignment 12.06 12.15 12.37 11.90 12.28 12.21 12.52 12.05 12.29 12.20 12.19 12.21 12.18 12.42 11.93 12.20 12.26 12.55 12.00 12.26 12.25 12.07 12.53 12.04 12.60 12.60 12.54 12.77 12.33 12.50 12.19 12.27 12.56 12.50 12.09 12.63 12.52 12.59 12.80 12.28 12.47 12.24 Page 12 Case Study 3: Dr. Pepper Bottling BUS 322 Dr. Pepper Bottling fills 12-ounce cans of soda during a normal production run. At various times, they will pull samples from the line and weigh them to make sure that the samples are filled correctly. This process, known as statistical process control, is done because overfilling costs the company money and under filling will upset loyal customers. During one particular run, Dr. Pepper management took 800 samples to test if the fill levels were accurate. Management also knows from past experience that the population mean = 12.02 and standard deviation = 0.19. The samples are presented in the spreadsheet named Case Study 3. By analyzing these samples, we can learn if our fill rates are correct. Otherwise, we will need to recalibrate the machinery. We know that the fill rate should be 12 ounces, thus the hypothesis is that the average is 12, as presented below. H0: 12 Ha: = 12 Using this information, prepare a one-page executive summary of your findings. This summary will answer the following questions: 1. Is the sample size large enough to assume a normal distribution? How do you know? 2. The hypotheses for each of the samples at the 0.01 level of significance 3. Descriptive Statistics for each sample 4. The p-value for each sample 5. The limits around each sample such that if the samples stays within those limits, it can be considered to be properly filled. (Upper and Lower Control Limits). 6. Recommendation for each sample. IE, should we recalibrate the machine based on the findings in each sample? When you are done, your finished product will have a Cover Page, Executive Summary, Charts and graphs to support your conclusion. You may use the spreadsheets used as an example to help guide you