Officials at Mountain Airlines are interested in monitoring the length of time customers must wait in line to check in at their airport counter in Reno, Nevada. To develop a control chart, five customers were sampled each day for 20 days. The data, in minutes are presented in CHECKN.xlsx. Conduct a capability analysis for the process. Management has specified a USL of 5 minutes. Is the process capable? Justify your answer. Why didn't management provide a LSL? Construct the X-bar chart for the waiting process.

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question
This image shows a spreadsheet containing data related to different "Sample" entries, numbered from 1 to 20. Each sample entry has associated values under five different "Wait" columns labeled Wait1, Wait2, Wait3, Wait4, and Wait5. Here's a detailed transcription of the data:

| Sample | Wait1 | Wait2 | Wait3 | Wait4 | Wait5 |
|--------|-------|-------|-------|-------|-------|
| 1      | 3.2   | 6.7   | 1.3   | 8.4   | 2.2   |
| 2      | 5     | 4.1   | 7.9   | 8.1   | 0.4   |
| 3      | 7.1   | 3.2   | 2.1   | 6.5   | 3.7   |
| 4      | 4.2   | 1.6   | 2.7   | 10.2  | 2.7   |
| 5      | 3.1   | 5.6   | 5.1   | 7.3   | 4.4   |
| 6      | 4.7   | 5.5   | 1.6   | 0.9   | 4.7   |
| 7      | 6     | 2.1   | 2.3   | 3.4   | 1.9   |
| 8      | 1.2   | 2.7   | 3.8   | 4.6   | 3.8   |
| 9      | 4.4   | 6.7   | 3.2   | 9.2   | 4.4   |
| 10     | 5.3   | 4.1   | 9.8   | 2.9   | 2.7   |
| 11     | 8     | 2.6   | 5.1   | 3.0   | 1.6   |
| 12     | 2.4   | 4.3   | 6.7   | 1.9   |
Transcribed Image Text:This image shows a spreadsheet containing data related to different "Sample" entries, numbered from 1 to 20. Each sample entry has associated values under five different "Wait" columns labeled Wait1, Wait2, Wait3, Wait4, and Wait5. Here's a detailed transcription of the data: | Sample | Wait1 | Wait2 | Wait3 | Wait4 | Wait5 | |--------|-------|-------|-------|-------|-------| | 1 | 3.2 | 6.7 | 1.3 | 8.4 | 2.2 | | 2 | 5 | 4.1 | 7.9 | 8.1 | 0.4 | | 3 | 7.1 | 3.2 | 2.1 | 6.5 | 3.7 | | 4 | 4.2 | 1.6 | 2.7 | 10.2 | 2.7 | | 5 | 3.1 | 5.6 | 5.1 | 7.3 | 4.4 | | 6 | 4.7 | 5.5 | 1.6 | 0.9 | 4.7 | | 7 | 6 | 2.1 | 2.3 | 3.4 | 1.9 | | 8 | 1.2 | 2.7 | 3.8 | 4.6 | 3.8 | | 9 | 4.4 | 6.7 | 3.2 | 9.2 | 4.4 | | 10 | 5.3 | 4.1 | 9.8 | 2.9 | 2.7 | | 11 | 8 | 2.6 | 5.1 | 3.0 | 1.6 | | 12 | 2.4 | 4.3 | 6.7 | 1.9 |
Officials at Mountain Airlines are interested in monitoring the length of time customers must wait in line to check in at their airport counter in Reno, Nevada. To develop a control chart, five customers were sampled each day for 20 days. The data, in minutes, are presented in CHECKN.xlsx. Conduct a capability analysis for the process. Management has specified a USL of 5 minutes. Is the process capable? Justify your answer. Why didn’t management provide a LSL? Construct the X-bar chart for the waiting process.
Transcribed Image Text:Officials at Mountain Airlines are interested in monitoring the length of time customers must wait in line to check in at their airport counter in Reno, Nevada. To develop a control chart, five customers were sampled each day for 20 days. The data, in minutes, are presented in CHECKN.xlsx. Conduct a capability analysis for the process. Management has specified a USL of 5 minutes. Is the process capable? Justify your answer. Why didn’t management provide a LSL? Construct the X-bar chart for the waiting process.
Expert Solution
Step 1

Cp = (USL -LSL)/(6*standard deviation) = (5-0)/(6*2.189756) = 0.380555

Cp is less than 1.0, so process is not capable.

Standard deviation is calculated using stdev function in excel.

Since the data is about wait time for a customer, the company would target to achieve 0.0 wait time. So, LSL is not given.

X-bar chart:

G K 3.867 5 3.867 Nm 3.867 2 9 A B с D E F H | J 1 Sample Wait 1 Wait 2 Wait 3 Wait 4 Wait 5 X-bar (Ave Range UCL LCL CL 2 1

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Similar questions
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON