- X File View 202 Hwk 05 F22 (1) - Protected View . Saved to this PC v X Tools Enable Editing i PROTECTED VIEW This file has been verified by Microsoft Defender Advanced Threat Protection and it hasn't detected any threats. If you need to edit this file, click enable editing. Determine the trial central line and control limits for the X-bar and s charts. Assume that the out-of-control points have assignable causes. Calculate the revised limits and central line. Out-of-Control Points Subgroup X-bar X-bar St Dev Subgroup Size 1 557.57 34.42 573.57 23.06 544.29 26.32 547.14 13.38 St Dev 557.57 12.51 X-bar 561.00 29.78 UCL trial 554.00 22.96 CL tria 536.43 23.16 LCL trial 540.86 34.51 532.14 26.44 551.86 21.96 UCL revised 559.71 34.10 CL revised 611.29 65.49 LCL revised 548.71 21.51 548.71 32.22 sigma_0= 571.86 28.60 556.43 27.81 557.86 16.08 542.86 40.43 529.29 23.53 530.86 24.55 563.29 17.64 23 547.43 25.71 24 541.43 29.62 25 550.71 24.80 sum 13816.86 680.60 average 552.67 27.22 range 82.00 52.98 stdev 16.83 10.40 8/7/2022 " Focus + 120% 5:27 PM Page 1 of 1 " WM X W 9/16/2022 1 EX A Stanton, Asia SA Search (Alt+Q) Comments Share X AutoSave Off 202 Hwk 05 F22 Data - Protected View v Home Insert Page Layout Formulas Data Review View Help Enable Editing File PROTECTED VIEW This file has been verified by Microsoft Defender Advanced Threat Protection and it hasn't detected any threats. If you need to edit this file, click enable editing. AD Z AA AB AC Y 552 R S T U V W X V23 vixfx M N O P Q K x6 X7 x4 x5 x1 B E G H x2 *5 x6 x7 x8 575 530 510 601 Out-of-Control Points X2 x3 x4 528 585 574 x1 569 571 593 588 X-bar S X-bar 533 590 527 528 601 545 579 553 595 Subgroup 596 555 535 567 533 582 539 510 512 Subgroup 557 583 559 557.57 34.42 545 558 568 579 537 545 589 550 583 488 531 560 551 548 539 Size 23.06 543 557 534 573.57 561 570 566 567 555 563 557 544.29 26.32 531 544 543 532 540 589 571 537 572 553 535 538 552 553 543 558 548 623 568 556 555 543 547.14 13.38 X-bar StDev 582 562 539 554 550 569 563 567 530 552 556 552 532 520 567 561 557.57 12.51 550 579 543 UCL trial 551 590 510 550 520 561.00 29.78 556 567 551 553 562 515 524 529 CL trial 561 555 567 585 545 579 550 529 527 564 479 589 554.00 22.96 547 541 538 563 548 LCL tria 578 551 553 525 547 568 511 496 572 524 529 533 560 536.43 23 .16 570 588 543 519 541 558 562 541 538 550 539 540.86 34.51 586 576 513 564 599 539 557 576 541 504 532.14 26.44 489 487 552 570 586 539 544 557 592 UCL revised 539 548 615 523 555 604 630 653 726 601 551.86 21.96 566 575 523 581 610 611 570 653 586 541 542 540 547 568 526 559.71 34 .10 CL revised 625 544 635 LCL revised 514 550 561 541 583 582 523 555 515 508 589 591 546 547 611.29 65.49 555 568 554 580 554 581 578 623 545 551 594 613 534 586 578 548.71 21.51 525 590 sigma_0 = 535 557 567 539 541 582 508 522 547 596 559 571 580 520 537 548.71 32.22 552 536 593 537 532 515 547 561 567 539 571.86 28.60 557 567 575 565 539 540 556 582 564 536 596 27.81 569 547 566 532 560 480 524 520 556 537 556.43 587 16.08 582 522 538 529 58 8 561 548 561 535 558 530 546 536 48 8 552 507 546 557.86 563 40.43 556 575 565 523 512 584 513 521 498 542.86 519 567 538 525 578 552 552 517 565 567 607 564 537 569 594 563 550 562 568 529.29 23.53 510 558 547 536 579 530.86 24.55 560 545 571 509 527 536 549 580 517 542 579 520 559 549 579 511 563 563 585 547 526 563.29 17.64 553 551 611 569 513 544 584 501 524 578 547.43 503 522 527 528 574 25.71 594 615 582 537 551 558 553 573 29.62 536 558 541.43 515 550.71 24.80 A for 7 = sum 13816.86 680.60 A3 for 7 = B4 for 7= B6 for 7= average 552.67 27.22 B3 for 7 = B5 for 7 = range 82.00 52.98 16.83 10.40 c4 for 7 = stdev Revised X-bar sum average range stdev + 76% Sheet1 + 5:28 PM x WE 9/16/2022 1 Ready W. M E