Control charts are being used to monitor a process that takes a certain amount of time. The control limits for an chart and an R chart have already been calculated. For the chart, the upper control limit is 12.2 seconds and the lower control limit is 11.8 seconds. For the R chart, the upper control limit is 0.7 seconds and the lower control limit is 0 seconds.

a)Use Excel to plot both the chart and the R chart. On each chart, show the specified control limits and plot the following 7 new samples (#30 - #36). Use copy and paste to include the chart and the R chart in your exam.

Sample Length in Seconds

30 12.05 11.9 12.05

31 12.05 11.9 12.1

32 12.05 11.85 11.8

33 12.1 12 11.9 34 12.3 12 11.4

35 12.1 12.25 11.9

36 12 12.15 11.85

b)According to the charts, is this process most likely in-control or out-of-control?