Generate Shewhart mean and range control charts for the six months of quality control data provided in the spreadsheet. You will need to group the raw data by date and calculate both means and ranges for each day. The Shewhart plots record only daily means or ranges, not individual data points. You must use the first 30 days of baseline quality control test data to establish initial Shewhart control chart warning and control limits for this recently developed method; plot all six months of data using these limits..
For the mean control chart
Use the first 30 days of data to establish the target reading and to determine warning and control limits for the six month period.
Use the data to calculate warning and control limits showing work on a separate excel worksheeet
For the range control chart
Use the average daily range from the first 30 days of data to determine the target range
Use the range standard deviation from the first 30 days of ranges to establish warning and control limits for the range
Calculate warning and control limits showing work on a separate excel worksheet.