The data given in worksheet Problem 5 in the Data file provi
The data given in worksheet “Problem 5” in the “Data” file provides the percent of filler content (goal is 80%) of a sample of five products from every hour of production.
Construct an x-bar chart (from r-bar) and determine if the process is in control.
Construct an R chart and determine if the process is in control.
Please show all work to justify final answer. Thanks for your help!
| 81.00723 | 77.03878 | 81.85476 | 80.27623 | 81.23954 |
| 79.54581 | 80.60283 | 79.34569 | 82.92094 | 80.22074 |
| 80.82137 | 79.91315 | 80.24533 | 79.536 | 80.23379 |
| 79.29158 | 80.82779 | 79.54811 | 79.60216 | 80.08431 |
| 79.70844 | 81.49417 | 78.93753 | 81.82998 | 80.6328 |
| 79.91069 | 78.44053 | 80.80405 | 79.41471 | 80.35606 |
| 80.43723 | 80.92447 | 79.8458 | 78.89374 | 80.92117 |
| 80.45816 | 80.05822 | 81.67864 | 79.26124 | 80.6647 |
| 79.88834 | 80.48395 | 79.37382 | 79.13302 | 79.67993 |
| 78.98997 | 79.60508 | 80.10278 | 79.44508 | 80.99117 |
| 79.39251 | 80.75748 | 78.83079 | 78.13403 | 79.02514 |
| 79.75347 | 79.74277 | 80.99551 | 79.30465 | 80.89872 |
| 81.0686 | 79.39373 | 79.07347 | 81.74935 | 80.66001 |
| 83.06247 | 79.6861 | 79.64866 | 80.0078 | 78.95507 |
| 78.87021 | 80.60881 | 80.63461 | 80.04691 | 82.2561 |
| 78.44555 | 80.19987 | 79.26999 | 80.07874 | 81.901 |
| 80.34999 | 80.36991 | 80.3093 | 79.55362 | 78.17107 |
| 78.78812 | 79.07327 | 80.94504 | 80.24552 | 79.70863 |
| 81.38124 | 79.62537 | 79.41536 | 81.58749 | 79.65933 |
| 78.14163 | 80.26264 | 81.93059 | 79.81587 | 80.43696 |
| 79.26902 | 79.26234 | 78.70634 | 79.37205 | 80.19153 |
| 80.90007 | 81.06959 | 80.65747 | 79.03542 | 81.49782 |
| 80.29836 | 81.16623 | 78.07575 | 79.06095 | 79.99587 |
| 80.73734 | 79.90808 | 79.39514 | 79.88385 | 80.3094 |
| 78.50421 | 82.09064 | 80.66322 | 78.33674 | 78.75697 |
| 78.71651 | 79.80031 | 78.48098 | 81.70523 | 80.77155 |
| 79.11175 | 81.56421 | 77.46743 | 79.3084 | 80.25007 |
| 79.69441 | 79.918 | 79.40455 | 79.37944 | 79.14391 |
| 80.88553 | 79.13499 | 80.29434 | 81.6707 | 79.54132 |
| 79.19156 | 79.46006 | 80.68171 | 80.16727 | 79.50641 |
| 80.29816 | 80.19583 | 79.04855 | 81.48714 | 79.49065 |
| 79.5572 | 79.66271 | 80.8422 | 79.80535 | 79.72268 |
| 79.54911 | 79.45037 | 80.20636 | 80.8625 | 81.70578 |
| 79.18462 | 79.89887 | 79.39126 | 78.0959 | 80.41516 |
| 80.29519 | 81.43194 | 79.74782 | 80.71062 | 80.95125 |
| 81.23733 | 79.71549 | 80.01253 | 78.82301 | 79.78858 |
| 80.94872 | 78.9642 | 79.71216 | 80.48625 | 80.25118 |
| 79.60191 | 79.02063 | 80.79916 | 81.2396 | 79.94562 |
| 80.2591 | 81.01766 | 81.41501 | 80.32611 | 79.29066 |
| 80.8232 | 81.95024 | 80.07498 | 80.33086 | 80.0039 |
| 79.10968 | 79.35423 | 79.99268 | 80.82475 | 80.49881 |
| 79.48927 | 78.93264 | 80.76624 | 80.41523 | 79.93103 |
| 80.65756 | 79.31229 | 80.73396 | 78.63179 | 81.56784 |
| 79.94778 | 79.35439 | 80.91014 | 80.20014 | 79.63002 |
| 81.02985 | 79.26187 | 79.24967 | 78.11515 | 78.39871 |
| 78.25166 | 79.26432 | 80.67908 | 80.22933 | 79.63962 |
| 80.78151 | 78.91219 | 81.13191 | 80.71656 | 79.93768 |
| 81.35845 | 81.32226 | 80.27676 | 79.66755 | 80.0028 |
| 81.06982 | 78.99237 | 79.00789 | 80.00373 | 78.12466 |
| 78.67644 | 81.52782 | 79.71197 | 80.89642 | 82.04126 |
| 81.21982 | 80.06273 | 79.35468 | 79.8576 | 80.30357 |
| 80.04308 | 79.24983 | 81.57101 | 80.6022 | 80.70667 |
| 79.89241 | 78.99719 | 80.51841 | 80.95257 | 79.68919 |
| 79.14175 | 80.65255 | 80.61607 | 80.23828 | 81.22249 |
| 78.03701 | 79.28205 | 79.85702 | 80.80594 | 79.2607 |
| 80.05133 | 80.1529 | 79.1703 | 79.72529 | 80.26472 |
| 78.72332 | 80.51378 | 79.4236 | 81.93146 | 79.23825 |
| 79.22138 | 79.24969 | 80.35647 | 78.80612 | 81.00445 |
| 80.04101 | 79.11309 | 81.6158 | 80.04591 | 79.97285 |
| 79.47744 | 80.96819 | 78.35714 | 80.15336 | 79.72683 |
| 79.2816 | 81.72757 | 79.5271 | 78.81648 | 79.61297 |
| 80.04125 | 79.32648 | 81.4066 | 79.62362 | 81.49577 |
| 80.20438 | 79.96788 | 79.35196 | 79.38986 | 80.24523 |
| 79.46773 | 78.55383 | 81.53166 | 79.9135 | 79.21056 |
| 79.16538 | 78.85367 | 80.31548 | 80.14363 | 80.14485 |
| 81.89228 | 80.68655 | 78.82176 | 80.81271 | 81.11759 |
| 78.90531 | 78.54013 | 79.32425 | 78.34177 | 78.42449 |
| 79.96116 | 81.86363 | 81.10152 | 80.36966 | 80.1499 |
| 79.62182 | 80.89876 | 79.1011 | 79.61204 | 80.217 |
| 78.91541 | 80.05567 | 81.31731 | 79.67983 | 80.52275 |
| 81.62315 | 81.73204 | 81.22439 | 79.78078 | 81.16304 |
| 79.64757 | 79.95443 | 77.3144 | 79.85235 | 80.12112 |
Solution

