Problem 9-06 Instructor Reserve
WeightBgone Container Weights
Frequency Distribution and Histogram
This template is designed to handle up to 150 observations. Enter data only in yellow cells.
Data Minimum 372.400
DATA 12345678910 11 12 13 14 15 Data Maximum 430.200
1398.2 388.5 403.9 393.9 405.0 401.8 402.1 383.5 376.2 406.1 415.0 381.1 413.4 390.7 407.4
2406.0 392.6 409.9 412.7 410.3 430.2 401.1 419.8 396.0 404.8 409.5 389.1 404.5 391.8 400.6 Enter number of cells (10 or less)
3406.1 379.4 397.1 414.7 390.4 409.0 407.3 406.8 394.1 411.4 405.5 388.1 378.6 409.5 398.1 Number of Cells 8
Cell From
To (inclusive)
Frequency
-Infinity 372.00 0
1372.00 379.88 6
2379.88 387.75 7
3387.75 395.63 24
4395.63 403.50 32
Original data
398.2 388.5 403.9 393.9 405.0 401.8 402.1 383.5 376.2 415.0 425.0 381.1 413.4 390.7 407.4 397.6 403.2 409.5 403.0 379.3 394.9 396.7 427.1 408.4 397.4 399.3 410.6 407.2 412.5 384.5
35
40
Histogram
6410.3 394.2 394.2 408.9 389.5 390.7 400.7 406.0 389.8 387.5 393.0 389.9 393.6 414.0 407.7
8406.6 396.8 393.1 397.9 380.8 404.1 400.6 410.9 399.2 401.7 400.1 392.1 389.8 415.5 403.6 Upper limit 435.000 The upper limit should be slightly larger than the data maximum.
This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells.
Enter the number of samples in cell E6 and the sample size in cell E7. Then enter your data in the grid below.
Click on sheet tabs for a display of the control charts. Specification limits may be entered in cells N7 and N8 for process capability.
Number of samples (<= 50) 30 Process Capability Calculations Six sigma 63.45
DATA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
1398.2 388.5 403.9 393.9 405.0 401.8 402.1 383.5 376.2 406.1 415.0 381.1 413.4 390.7 407.4 397.6 403.2 409.5 403.0 379.3 394.9 396.7 427.1 408.4 397.4 399.3 410.6 407.2 412.5 384.5
2406.0 392.6 409.9 412.7 410.3 430.2 401.1 419.8 396.0 404.8 409.5 389.1 404.5 391.8 400.6 410.3 394.2 394.2 408.9 389.5 390.7 400.7 406.0 389.8 387.5 393.0 389.9 393.6 414.0 407.7
5
6
7
8
9
10
Average 400.1 387.1 402 404.8 401 410.7 404.5 404.3 389 404.7 409 385.8 399.1 396 403.3 406.2 403 400.5 403 380.5 396.7 401.4 411 398.8 391 401.4 402 399.9 412 398.9 ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
LCLx-bar
387.1 387.1 387 387.1 387 387.1 387.1 387.1 387 387.1 387 387.1 387.1 387 387.1 387.1 387.1 387.1 387 387.1 387.1 387.1 387 387.1 387.1 387.1 387 387.1 387 387.1 387 387 387 387 387 387 387 387 387 387 387 387 387 387 387 387 387 387 387 387
Center 400.2 400.2 400 400.2 400 400.2 400.2 400.2 400 400.2 400 400.2 400.2 400 400.2 400.2 400.2 400.2 400 400.2 400.2 400.2 400 400.2 400.2 400.2 400 400.2 400 400.2 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400
UCLx-bar
LCLrange
UCLrange
413.3 413.3 413 413.3 413 413.3 413.3 413.3 413 413.3 413 413.3 413.3 413 413.3 413.3 413.3 413.3 413 413.3 413.3 413.3 413 413.3 413.3 413.3 413 413.3 413 413.3 413 413 413 413 413 413 413 413 413 413 413 413 413 413 413 413 413 413 413 413
DO NOT MODIFY THIS TABLE
nA2 D3 D4 d2 A3 B3 B4
2 1.88 0 3.27 1.128 2.66 0 3.267
3 1.023 0 2.57 1.693 1.95 0 2.568
Control Chart Factors
405
410
415
420
X-bar Chart Averages
Lower control limit
Upper control limit
Center line
35
40
45
R-Chart Ranges
Lower control limit
Upper control limit
Center line