I'm working on a business case study and need an explanation to help me learn.

1. Create and interpret a P Chart for each of the outcomes analyzed in the case (an Excel file with the data is provided). Interpret each P chart based on the Shewhart interpretation rules. Use the Excel Control Chart template.

2.

• For processes that are stable, compare Laralexs performance with external benchmarks. Use the Excel Control Chart template. Assume that a very large group of peer hospitals had the following average proportions:
• Discrepant X-rays - 1.11%
• Unscheduled Readmissions - 4.6%
• Hospital-Acquired Infections - 0.30%
• Cesarean Sections - 19.2%
• Patients who Leave the ED Prior to Treatment 3.3%

Month Patient-Days No. Births No. Patients No. Patients No. Patients No. 1 5225 22 119 32 488 8 310 6 604 6 2 5515 20 111 27 573 3 294 5 575 10 3 5872 15 111 32 489 6 337 14 593 7 4 5398 22 125 28 420 4 253 10 641 6 5 5017 26 99 27 503 6 293 10 601 11 6 5273 17 127 27 580 7 300 4 649 9 7 5616 16 121 25 419 8 319 10 658 11 8 5061 11 117 32 442 4 199 7 552 11 9 5262 20 133 30 407 3 263 11 536 9 10 4808 26 106 23 553 9 259 5 554 11 11 5280 20 120 27 466 3 285 14 708 11 12 5491 24 123 33 551 4 275 11 547 12 13 4824 20 114 29 485 10 320 13 589 16 14 5340 21 128 19 427 7 329 12 596 12 15 5307 14 117 19 540 9 243 11 685 18 16 5507 20 115 21 568 3 278 8 640 15 17 4189 22 104 22 531 9 365 6 659 17 18 4378 17 128 20 558 5 348 11 609 16 19 4620 20 120 24 474 4 290 8 438 14 20 5869 27 121 25 594 9 321 7 522 13 21 4975 21 102 21 540 2 253 9 574 16 22 4969 19 107 18 553 9 266 10 539 18 23 5792 17 118 24 556 11 301 11 634 21 24 4939 22 116 22 541 7 348 9 610 22 Month Patient-Days No. Births No. Patients No. Patients No. Patients No. 1 5225 22 119 32 488 8 310 6 604 6 2 5515 20 111 27 573 3 294 5 575 10 3 5872 15 111 32 489 6 337 14 593 7 4 5398 22 125 28 420 4 253 10 641 6 5 5017 26 99 27 503 6 293 10 601 11 6 5273 17 127 27 580 7 300 4 649 9 7 5616 16 121 25 419 8 319 10 658 11 8 5061 11 117 32 442 4 199 7 552 11 9 5262 20 133 30 407 3 263 11 536 9 10 4808 26 106 23 553 9 259 5 554 11 11 5280 20 120 27 466 3 285 14 708 11 12 5491 24 123 33 551 4 275 11 547 12 13 4824 20 114 29 485 10 320 13 589 16 14 5340 21 128 19 427 7 329 12 596 12 15 5307 14 117 19 540 9 243 11 685 18 16 5507 20 115 21 568 3 278 8 640 15 17 4189 22 104 22 531 9 365 6 659 17 18 4378 17 128 20 558 5 348 11 609 16 19 4620 20 120 24 474 4 290 8 438 14 20 5869 27 121 25 594 9 321 7 522 13 21 4975 21 102 21 540 2 253 9 574 16 22 4969 19 107 18 553 9 266 10 539 18 23 5792 17 118 24 556 11 301 11 634 21 24 4939 22 116 22 541 7 348 9 610 22