SpeedyNetService.com, an Internet service provider (ISP), is concerned that the level of access for customers is decreasing,
Question:
SpeedyNetService.com, an Internet service provider (ISP), is concerned that the level of access for customers is decreasing, as a result of heavier use. The proportion of peak period time when a customer’s download speed drops by 20 percent or more below the average time is considered a good measure of service level. The percentage of time a customer experiences such drops during peak periods varies. Using a sampling process, the ISP set up control charts to monitor the service level, based on proportion of below average download speed during peak periods. Construct the p-chart using the sample data in the table in the worksheet Prob07-07 in the Ch07Data.xlsx file on the Student Companion Site for this chapter. What does the chart show? Is the service level based on the p-chart data good or bad, in your opinion?
SpeedyNetService.com | |||||||||||||
Fraction Nonconforming (p) Chart | |||||||||||||
This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. | |||||||||||||
Click on the sheet tab to display the control chart (some rescaling may be needed). | |||||||||||||
Average (p-bar) | 0.0128 | ||||||||||||
Avg. sample size | 525.167 | ||||||||||||
Approximate Control Limits Using | |||||||||||||
Sample | Fraction | Standard | Average Sample Size Calculations | ||||||||||
Sample | Value | Size | Nonconforming | Deviation | LCLp | CL | UCLp | LCLp | CL | UCLp | |||
1 | 8 | 492 | 0.0163 | 0.0051 | 0 | 0.013 | 0.0280 | 0 | 0.0128 | 0.0275 | |||
2 | 9 | 424 | 0.0212 | 0.0055 | 0 | 0.013 | 0.0292 | 0 | 0.0128 | 0.0275 | |||
3 | 4 | 508 | 0.0079 | 0.0050 | 0 | 0.013 | 0.0278 | 0 | 0.0128 | 0.0275 | |||
4 | 5 | 614 | 0.0081 | 0.0045 | 0 | 0.013 | 0.0264 | 0 | 0.0128 | 0.0275 | |||
5 | 11 | 566 | 0.0194 | 0.0047 | 0 | 0.013 | 0.0270 | 0 | 0.0128 | 0.0275 | |||
6 | 6 | 616 | 0.0097 | 0.0045 | 0 | 0.013 | 0.0264 | 0 | 0.0128 | 0.0275 | |||
7 | 5 | 528 | 0.0095 | 0.0049 | 0 | 0.013 | 0.0275 | 0 | 0.0128 | 0.0275 | |||
8 | 8 | 382 | 0.0209 | 0.0058 | 0 | 0.013 | 0.0301 | 0 | 0.0128 | 0.0275 | |||
9 | 8 | 608 | 0.0132 | 0.0046 | 0 | 0.013 | 0.0265 | 0 | 0.0128 | 0.0275 | |||
10 | 5 | 506 | 0.0099 | 0.0050 | 0 | 0.013 | 0.0278 | 0 | 0.0128 | 0.0275 | |||
11 | 3 | 596 | 0.0050 | 0.0046 | 0 | 0.013 | 0.0266 | 0 | 0.0128 | 0.0275 | |||
12 | 9 | 510 | 0.0176 | 0.0050 | 0 | 0.013 | 0.0278 | 0 | 0.0128 | 0.0275 | |||
13 | 11 | 428 | 0.0257 | 0.0054 | 0 | 0.013 | 0.0291 | 0 | 0.0128 | 0.0275 | |||
14 | 8 | 524 | 0.0153 | 0.0049 | 0 | 0.013 | 0.0276 | 0 | 0.0128 | 0.0275 | |||
15 | 3 | 410 | 0.0073 | 0.0056 | 0 | 0.013 | 0.0295 | 0 | 0.0128 | 0.0275 | |||
16 | 9 | 586 | 0.0154 | 0.0046 | 0 | 0.013 | 0.0268 | 0 | 0.0128 | 0.0275 | |||
17 | 8 | 488 | 0.0164 | 0.0051 | 0 | 0.013 | 0.0281 | 0 | 0.0128 | 0.0275 | |||
18 | 3 | 618 | 0.0049 | 0.0045 | 0 | 0.013 | 0.0264 | 0 | 0.0128 | 0.0275 | |||
19 | 9 | 552 | 0.0163 | 0.0048 | 0 | 0.013 | 0.0272 | 0 | 0.0128 | 0.0275 | |||
20 | 10 | 466 | 0.0215 | 0.0052 | 0 | 0.013 | 0.0285 | 0 | 0.0128 | 0.0275 | |||
21 | 6 | 472 | 0.0127 | 0.0052 | 0 | 0.013 | 0.0284 | 0 | 0.0128 | 0.0275 | |||
22 | 2 | 484 | 0.0041 | 0.0051 | 0 | 0.013 | 0.0282 | 0 | 0.0128 | 0.0275 | |||
23 | 8 | 468 | 0.0171 | 0.0052 | 0 | 0.013 | 0.0284 | 0 | 0.0128 | 0.0275 | |||
24 | 8 | 574 | 0.0139 | 0.0047 | 0 | 0.013 | 0.0269 | 0 | 0.0128 | 0.0275 | |||
25 | 7 | 606 | 0.0116 | 0.0046 | 0 | 0.013 | 0.0265 | 0 | 0.0128 | 0.0275 | |||
26 | 7 | 620 | 0.0113 | 0.0045 | 0 | 0.013 | 0.0264 | 0 | 0.0128 | 0.0275 | |||
27 | 5 | 575 | 0.0087 | 0.0047 | 0 | 0.013 | 0.0269 | 0 | 0.0128 | 0.0275 | |||
28 | 8 | 600 | 0.0133 | 0.0046 | 0 | 0.013 | 0.0266 | 0 | 0.0128 | 0.0275 | |||
29 | 5 | 541 | 0.0092 | 0.0048 | 0 | 0.013 | 0.0273 | 0 | 0.0128 | 0.0275 | |||
30 | 4 | 393 | 0.0102 | 0.0057 | 0 | 0.013 | 0.0298 | 0 | 0.0128 | 0.0275 | |||
31 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||||
32 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||||
33 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||||
34 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||||
35 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||||
36 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||||
37 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||||
38 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||||
39 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||||
40 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||||
41 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||||
42 | #N/A | #N/A |