The service manager for a bicycle sales and service shop wants to study the length of time required to replace the gears on road bikes. The manager has implemented a quality improvement program to standardize the process for replacing bike gears. As a part of the improvement program, four bikes needing gear replacements are randomly selected each day for 20 days. The time required, in minutes, to replace the gears for each bike is measured. The results are as follows:

Use Excel to develop an R chart to determine if the range of the process is stable or not.

Transcribed Image Text:

Day Bike BikeBikeBike 16.26 22.95 26.12 10.92 33.97 18.8020.6720.04 17.74 28.60 9.96 10.98 27.22 22.02 25.3221.93 30.67 14.65 18.2921.70 20.44 9.48 32.8717.69 19.88 16.961.7927.61 18.1322.06 21.2220.33 21.82 32.2516.5020.11 1025.18 23.24 19.97 17.83 1118.49 13.66 27.44 20.87 12 23.22 17.36 22.25 24.19 13 23.97 21.79 23.14 35.88 14 18.53 25.38 13.31 29.83 15 20.66 26.50 20.42 18.76 16 2132 28.41 29.75 19.91 17 22.92 18.58 18.16 15.60 18 20.5 20.85 23.50 22.74 19 22.15 21.73 21.28 24.94 20 20.17 19.15 22.87 25.89