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?

 

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted:

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


SampleFractionStandard



Average Sample Size Calculations
SampleValueSizeNonconformingDeviationLCLpCLUCLp
LCLpCLUCLp

184920.01630.005100.0130.0280
00.01280.0275

294240.02120.005500.0130.0292
00.01280.0275

345080.00790.005000.0130.0278
00.01280.0275

456140.00810.004500.0130.0264
00.01280.0275

5115660.01940.004700.0130.0270
00.01280.0275

666160.00970.004500.0130.0264
00.01280.0275

755280.00950.004900.0130.0275
00.01280.0275

883820.02090.005800.0130.0301
00.01280.0275

986080.01320.004600.0130.0265
00.01280.0275

1055060.00990.005000.0130.0278
00.01280.0275

1135960.00500.004600.0130.0266
00.01280.0275

1295100.01760.005000.0130.0278
00.01280.0275

13114280.02570.005400.0130.0291
00.01280.0275

1485240.01530.004900.0130.0276
00.01280.0275

1534100.00730.005600.0130.0295
00.01280.0275

1695860.01540.004600.0130.0268
00.01280.0275

1784880.01640.005100.0130.0281
00.01280.0275

1836180.00490.004500.0130.0264
00.01280.0275

1995520.01630.004800.0130.0272
00.01280.0275

20104660.02150.005200.0130.0285
00.01280.0275

2164720.01270.005200.0130.0284
00.01280.0275

2224840.00410.005100.0130.0282
00.01280.0275

2384680.01710.005200.0130.0284
00.01280.0275

2485740.01390.004700.0130.0269
00.01280.0275

2576060.01160.004600.0130.0265
00.01280.0275

2676200.01130.004500.0130.0264
00.01280.0275

2755750.00870.004700.0130.0269
00.01280.0275

2886000.01330.004600.0130.0266
00.01280.0275

2955410.00920.004800.0130.0273
00.01280.0275

3043930.01020.005700.0130.0298
00.01280.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