Health Medical
DDHA 8900 Walden University Health Care Administration Process Analysis Tools Paper

DDHA 8900

Walden University

DDHA

Question Description

Need help with my Health & Medical question - I’m studying for my class.

Assignment: Process Analysis Tools

How might health care administration leaders use process analysis tools to promote positive outcomes in health services organizations? As a current or future health care administration leader, your ability to apply process analysis tools within the right context will be useful for ensuring effective operations in your health services organization.

For this Assignment, review the resources for this week that are specific to supply, demand, equilibrium, break-even analysis, and quality improvement initiatives. Be sure to review the Pay for Performance and CMS Quality Initiative in your course text.

  • Using Microsoft Excel and Microsoft Word, complete problems 1 through 9 on pages 156–158 in the Ross textbook. Show all work. Submit both your Excel and Word files for grading.

DDHA 8900 Walden University Health Care Administration Process Analysis Tools  Paper
.jpeg
DDHA 8900 Walden University Health Care Administration Process Analysis Tools  Paper
.jpeg
DDHA 8900 Walden University Health Care Administration Process Analysis Tools  Paper
.jpeg

Unformatted Attachment Preview

Chapter 4 - Process Analysis Tools Problems 4.1 and 4.3 State AK - Alaska AL - Alabama AR - Arkansas AZ - Arizona CA - California CO - Colorado CT - Connecticut DE - Delaware FL - Florida GA - Georgia HI - Hawaii IA - Iowa ID - Idaho IL - Illinois IN - Indiana KS - Kansas KY - Kentucky LA - Louisiana MA - Massachusetts MD - Maryland ME - Maine MI - Michigan MN - Minnesota MO - Missouri MS - Mississippi MT - Montana NC - North Carolina ND - North Dakota NE - Nebraska NH - New Hampshire NJ - New Jersey NM - New Mexico NV - Nevada NY - New York OH - Ohio OK - Oklahoma OR - Oregon PA - Pennsylvania Number Staffed Total Hospitals Beds Discharges 12 998 34,421 99 15,859 653,176 57 8,137 325,221 64 11,394 664,559 351 75,854 3,156,632 45 8,082 375,654 32 7,966 377,905 6 2,070 96,563 175 52,773 2,267,578 109 23,140 891,250 17 2,918 95,417 44 7,869 286,034 16 2,425 99,720 141 32,815 1,453,444 87 17,254 693,741 56 6,754 283,031 71 13,842 562,712 108 15,967 562,050 67 15,401 757,916 47 11,470 702,481 24 3,276 129,906 113 24,202 1,093,710 64 11,550 525,184 88 19,284 725,433 74 11,766 376,368 19 2,670 82,996 99 23,392 928,894 14 2,250 64,722 27 4,516 177,817 14 2,198 96,554 75 22,301 1,053,635 35 3,716 161,836 23 4,781 247,738 186 63,363 2,173,516 139 30,550 1,333,974 93 10,705 430,490 34 5,659 307,663 166 38,290 1,707,901 Patient Days 219,344 3,532,253 1,736,664 2,843,523 18,647,141 1,930,955 2,289,142 585,331 12,215,719 5,914,639 791,991 1,703,829 500,164 7,900,032 3,781,941 1,457,913 3,180,976 3,318,793 4,180,428 3,290,955 760,624 5,978,419 2,947,089 4,267,698 2,429,873 656,832 5,896,242 534,923 1,114,833 523,305 6,067,494 794,549 1,270,605 18,484,358 7,288,632 2,359,551 1,398,592 9,834,645 Gross Patient Revenue ($000) $1,538,741 $24,307,131 $9,950,236 $23,717,971 $174,565,816 $16,965,279 $13,733,179 $2,580,914 $98,979,587 $32,451,158 $3,458,738 $8,529,520 $2,845,249 $57,062,840 $23,156,372 $10,513,845 $18,772,381 $20,203,715 $30,849,792 $11,243,922 $4,497,946 $41,863,279 $18,333,649 $28,765,864 $12,680,803 $2,524,508 $26,199,109 $2,339,404 $6,552,433 $4,399,165 $60,798,268 $6,083,838 $11,310,014 $87,747,679 $52,893,718 $13,659,598 $9,944,238 $89,092,136 LOS 6.37 5.41 5.34 4.28 5.91 5.14 6.06 6.06 5.39 6.64 8.30 5.96 5.02 5.44 5.45 5.15 5.65 5.90 5.52 4.68 5.86 5.47 5.61 5.88 6.46 7.91 6.35 8.26 6.27 5.42 5.76 4.91 5.13 8.50 5.46 5.48 4.55 5.76 RI - Rhode Island SC - South Carolina SD - South Dakota TN - Tennessee TX - Texas UT - Utah VA - Virginia VT - Vermont WA - Washington WI - Wisconsin WV - West Virginia WY - Wyoming Totals 11 2,566 54 11,350 27 2,793 113 20,447 324 53,189 35 4,106 79 19,449 8 960 51 9,332 71 11,963 37 6,523 12 1,247 3,772 772,181 http://www.ahd.com/states 129,882 506,392 83,542 789,359 2,459,345 189,831 736,358 41,941 493,731 511,240 251,559 38,716 32,710,762 715,096 3,065,675 680,351 4,544,512 12,462,942 977,317 4,886,474 222,706 2,244,821 2,701,680 1,512,623 245,976 189,961,449 $5,082,759 $19,824,701 $2,726,227 $28,829,509 $94,638,845 $5,430,364 $26,401,936 $1,783,631 $18,686,823 $18,484,512 $6,938,818 $1,052,014 $1,303,466,007 5.51 6.05 8.14 5.76 5.07 5.15 6.64 5.31 4.55 5.28 6.01 6.35 Chapter 4 - Process Analysis Tools Problems 4.2 and 4.4 DRG 143: Chest Pain 2005 Hospital Name Abington Memorial Albert Einstein Aliquippa Community Allegheny General Alle-Kiski Altoona Regional Armstrong County Memorial Ashland Regional Barnes Kasson County Berwick Bon Secours Bradford Regional Brandywine Brookville Butler Memorial Canonsburg General Carlisle Regional Central Montgomery Chambersburg Charles Cole Memorial Chester County Clarion Clearfield Community/Scranton Conemaugh Valley Memorial Corry Memorial Crozer-Chester Delaware County Memorial Doylestown DuBois Regional Easton Elk Regional Ellwood City Ephrata Community Evangelical Community Frankford Frick Fulton County Geisinger Wyoming Valley Geisinger/Danville Cases 1293 845 31 237 242 147 42 23 52 92 115 35 319 34 102 88 170 183 274 45 434 61 35 661 328 27 647 578 317 37 518 59 33 136 154 1717 128 57 110 86 Length Average of Stay Charge 1.5 $23,308 1.5 $20,960 1.9 $7,700 1.6 $11,481 1.7 $10,276 1.7 $8,943 1.7 $3,967 1.4 $5,369 1.7 $3,475 2.1 $9,430 1.7 $4,969 1.7 $4,828 1.6 $29,045 2.1 $4,168 1.6 $7,010 2.2 $11,914 1.7 $11,108 1.5 $18,349 1.8 $10,151 2 $5,884 1.7 $9,195 1.3 $4,110 2.3 $6,337 1.5 $9,945 1.9 $8,051 1.4 $3,452 1.5 $26,164 1.9 $29,423 1.4 $13,732 1.3 $7,624 1.5 $12,392 1.5 $6,957 2.2 $4,535 1.9 $7,659 1.3 $4,583 2.1 $14,417 1.8 $6,678 1.9 $5,205 1.6 $12,786 1.2 $11,327 Gettysburg Gnaden Huetten Memorial Good Samaritan Regional Good Samaritan/Lebanon Graduate Grand View Hahnemann University Hamot Hanover Hazleton General Heart of Lancaster Highlands Holy Redeemer Holy Spirit Hospital Fox Chase Cancer Hospital University PA Indiana Regional J C Blair Memorial Jameson Memorial Jeanes Jefferson Regional Jennersville Regional Jersey Shore Kane Community Lancaster General Lancaster Regional Latrobe Area Lehigh Valley Lehigh Valley/Muhlenberg Lewistown Main Line Bryn Mawr Main Line Lankenau Main Line Paoli Marian Community Meadville Medical Center Beaver Memorial York Memorial/Towanda Mercy Fitzgerald Mercy Jeannette Mercy Philadelphia Mercy Pittsburgh Mercy Suburban Mercy/Scranton Methodist Division/TJUH Mid-Valley Millcreek Community 94 61 177 223 251 384 476 349 41 80 59 33 407 312 5 750 164 70 269 415 186 264 34 31 541 193 227 995 398 348 474 818 304 141 111 286 133 40 728 70 647 386 389 445 616 11 26 1.5 1.5 1.9 1.6 1.3 1.7 2 1.6 2.2 2 1.5 1.6 1.3 1.7 1.5 1.3 2 1.9 1.4 1.7 1.9 1.7 1.6 1.7 1.8 1.7 1.5 1.6 1.6 1.8 1.7 1.5 1.3 1.9 1.6 1.9 1.7 1.6 1.4 1.8 1.4 1.6 1.6 1.6 2 1.2 2.1 $6,598 $4,151 $5,362 $7,703 $24,129 $18,579 $35,185 $10,772 $7,692 $10,661 $9,855 $4,299 $23,159 $10,138 $5,175 $15,813 $7,803 $5,157 $5,496 $30,362 $6,311 $17,917 $4,761 $4,117 $8,994 $10,898 $6,368 $12,827 $14,430 $5,964 $18,635 $16,053 $16,627 $6,157 $5,633 $6,849 $8,039 $6,060 $20,029 $8,584 $15,712 $11,259 $18,742 $9,975 $17,326 $6,624 $7,988 Milton S Hershey Miners Monongahela Valley Montgomery Montrose General Moses Taylor Mount Nittany Muncy Valley Nason Nazareth Ohio Valley General Palmerton Pennsylvania Phoenixville Pinnacle Health Pocono Pottstown Memorial Pottsville Warne Clinic Punxsutawney Area Reading Riddle Memorial Robert Packer Roxborough Memorial Sacred Heart/Allentown Saint Vincent Health Sewickley Valley Shamokin Area Community Sharon Regional Soldiers & Sailors Somerset Center Health Southwest Regional MC Springfield St Clair Memorial St Joseph/Reading St Joseph's/Philadelphia St Luke's Miners St Luke's Quakertown St Luke's/Bethlehem St Mary Sunbury Community Taylor Temple East Temple Lower Bucks Temple University Thomas Jefferson Univ Titusville Area Troy Community 57 9 107 483 45 165 168 17 56 558 163 39 290 282 466 656 281 197 44 132 484 150 292 90 235 113 68 331 7 64 25 158 182 97 142 107 50 1219 1169 154 395 694 355 1302 680 20 6 1.3 1.6 2.4 1.8 1.7 1.6 1.7 1.4 1.6 1.9 1.6 1.8 1.6 1.3 1.7 1.4 1.4 1.7 1.6 1.8 1.4 1.5 1.7 1.6 1.6 2 1.7 1.7 2 2.3 1.4 1.5 1.9 1.3 2.3 2.1 1.7 1.6 1.6 1.6 1.6 1.9 1.8 1.4 1.6 1.4 1.5 $7,618 $8,107 $8,859 $10,779 $2,611 $9,310 $6,474 $3,126 $3,360 $25,577 $6,722 $5,648 $18,237 $10,422 $10,191 $10,899 $10,935 $4,188 $3,480 $6,995 $19,821 $7,528 $8,646 $8,485 $18,413 $7,482 $3,542 $8,391 $6,769 $6,668 $3,993 $26,364 $8,207 $8,216 $9,574 $6,671 $9,739 $7,349 $12,035 $6,603 $30,295 $16,049 $24,255 $33,569 $19,559 $4,648 $2,956 Tyler Memorial Tyrone Uniontown United Community Univ PA/Presbyterian UPMC Bedford UPMC Braddock UPMC Horizon UPMC McKeesport UPMC Northwest UPMC Passavant UPMC Presby Shadyside UPMC South Side UPMC St Margaret Warren General Washington Wayne Memorial Waynesboro Western PA Hosp/Forbes Western Pennsylvania Westmoreland Regional Williamsport Windber WVHCS York 62 47 297 16 279 51 71 53 282 242 187 342 42 131 26 320 50 22 257 192 207 139 19 224 312 1.7 1.7 1.7 1.2 1.3 1.5 1.7 1.7 1.7 1.6 1.7 2 2.2 1.6 1.9 1.8 1.6 1.7 1.7 2 1.4 1.6 1.5 1.6 1.4 $5,832 $3,374 $4,372 $8,887 $13,526 $5,428 $8,816 $6,747 $9,286 $4,600 $11,164 $16,114 $13,054 $11,229 $6,914 $7,499 $6,193 $9,862 $9,026 $13,599 $6,823 $7,790 $9,275 $7,981 $6,009 Chapter 4 - Process Analysis Tools Problems 4.5 and 4.7 Day Week 1 1 1 2 2 3 3 4 4 4 4 5 5 5 6 6 7 8 8 9 9 9 9 10 10 11 12 14 14 15 15 15 15 16 16 18 19 19 19 20 20 21 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 Date Thursday, January 01, 2009 Thursday, January 01, 2009 Thursday, January 01, 2009 Friday, January 02, 2009 Friday, January 02, 2009 Saturday, January 03, 2009 Saturday, January 03, 2009 Sunday, January 04, 2009 Sunday, January 04, 2009 Sunday, January 04, 2009 Sunday, January 04, 2009 Monday, January 05, 2009 Monday, January 05, 2009 Monday, January 05, 2009 Tuesday, January 06, 2009 Tuesday, January 06, 2009 Wednesday, January 07, 2009 Thursday, January 08, 2009 Thursday, January 08, 2009 Friday, January 09, 2009 Friday, January 09, 2009 Friday, January 09, 2009 Friday, January 09, 2009 Saturday, January 10, 2009 Saturday, January 10, 2009 Sunday, January 11, 2009 Monday, January 12, 2009 Wednesday, January 14, 2009 Wednesday, January 14, 2009 Thursday, January 15, 2009 Thursday, January 15, 2009 Thursday, January 15, 2009 Thursday, January 15, 2009 Friday, January 16, 2009 Friday, January 16, 2009 Sunday, January 18, 2009 Monday, January 19, 2009 Monday, January 19, 2009 Monday, January 19, 2009 Tuesday, January 20, 2009 Tuesday, January 20, 2009 Wednesday, January 21, 2009 Patient Age 59 102 37 68 83 56 20 104 49 24 83 40 69 77 88 71 101 62 72 24 85 56 41 80 60 45 14 66 32 64 75 13 104 69 79 106 57 80 16 81 59 52 Medication Heavy Heavy Heavy Moderate Light Heavy Heavy Moderate Moderate Light Heavy Heavy Moderate Moderate Light Heavy Heavy Moderate Moderate Light Heavy Heavy Heavy Moderate Light Heavy Heavy Moderate Moderate Light Heavy Heavy Moderate Moderate Light Heavy Heavy Moderate Moderate Light Heavy Heavy Location Shift 2N-Med 1 2N-Med 2 3S-Surg 2 3N-Surg 3 2S-Med 1 Clinic 1 3N-Surg 2 ER 3 2N-Med 1 Clinic 2 2N-Med 2 2N-Med 3 3S-Surg 1 3N-Surg 2 2S-Med 2 2N-Med 3 2N-Med 1 3S-Surg 2 3N-Surg 2 2N-Med 3 2N-Med 1 3S-Surg 1 3N-Surg 2 2S-Med 3 Clinic 1 3N-Surg 2 Peds 2 2S-Med 3 2N-Med 1 Clinic 2 3S-Surg 2 Peds 3 2N-Med 1 2N-Med 2 3S-Surg 2 3N-Surg 3 2S-Med 2 2N-Med 1 2N-Med 2 3S-Surg 3 3N-Surg 1 2S-Med 2 21 21 22 23 24 26 27 27 28 28 29 30 30 30 31 32 32 33 34 35 36 37 38 40 41 41 42 43 44 44 44 45 45 46 46 47 48 49 52 53 54 55 55 56 57 58 60 3 3 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 7 7 7 7 7 7 7 7 7 7 7 8 8 8 8 8 8 9 9 9 Wednesday, January 21, 2009 Wednesday, January 21, 2009 Thursday, January 22, 2009 Friday, January 23, 2009 Saturday, January 24, 2009 Monday, January 26, 2009 Tuesday, January 27, 2009 Tuesday, January 27, 2009 Wednesday, January 28, 2009 Wednesday, January 28, 2009 Thursday, January 29, 2009 Friday, January 30, 2009 Friday, January 30, 2009 Friday, January 30, 2009 Saturday, January 31, 2009 Sunday, February 01, 2009 Sunday, February 01, 2009 Monday, February 02, 2009 Tuesday, February 03, 2009 Wednesday, February 04, 2009 Thursday, February 05, 2009 Friday, February 06, 2009 Saturday, February 07, 2009 Monday, February 09, 2009 Tuesday, February 10, 2009 Tuesday, February 10, 2009 Wednesday, February 11, 2009 Thursday, February 12, 2009 Friday, February 13, 2009 Friday, February 13, 2009 Friday, February 13, 2009 Saturday, February 14, 2009 Saturday, February 14, 2009 Sunday, February 15, 2009 Sunday, February 15, 2009 Monday, February 16, 2009 Tuesday, February 17, 2009 Wednesday, February 18, 2009 Saturday, February 21, 2009 Sunday, February 22, 2009 Monday, February 23, 2009 Tuesday, February 24, 2009 Tuesday, February 24, 2009 Wednesday, February 25, 2009 Thursday, February 26, 2009 Friday, February 27, 2009 Sunday, March 01, 2009 96 81 103 75 49 100 19 83 58 51 59 89 30 19 49 34 96 28 77 47 24 69 16 29 100 78 43 65 54 97 27 62 25 76 84 67 55 48 103 101 29 28 63 27 50 37 97 Heavy Moderate Light Heavy Heavy Moderate Moderate Light Heavy Heavy Moderate Moderate Light Heavy Heavy Moderate Moderate Light Heavy Heavy Heavy Moderate Light Heavy Heavy Moderate Moderate Light Moderate Heavy Moderate Moderate Light Heavy Heavy Moderate Moderate Light Moderate Moderate Light Heavy Heavy Heavy Moderate Light Heavy 2N-Med 3S-Surg 3N-Surg 2S-Med 2N-Med 2N-Med 3S-Surg 3N-Surg 2S-Med 2N-Med 3S-Surg 3N-Surg 2S-Med 2N-Med 2N-Med 3S-Surg 3N-Surg 2S-Med 3N-Surg 3S-Surg 2N-Med 2N-Med Peds 2S-Med 2S-Med 3N-Surg 2N-Med Clinic 2N-Med 3S-Surg 3N-Surg 2S-Med 2N-Med 2N-Med 3S-Surg 3N-Surg 2S-Med 3S-Surg 3N-Surg 2N-Med 3S-Surg 3N-Surg 2S-Med 2N-Med 2N-Med 3S-Surg 3N-Surg 2 3 1 2 2 3 1 2 2 3 1 1 2 3 1 2 2 3 1 2 2 3 1 2 2 3 1 1 2 3 1 2 2 3 1 2 2 3 1 2 2 3 1 1 2 3 1 61 62 63 63 64 66 67 69 70 71 72 72 73 75 76 77 78 79 81 82 83 84 84 85 86 87 88 89 90 9 9 9 9 10 10 10 10 10 11 11 11 11 11 11 11 12 12 12 12 12 12 12 13 13 13 13 13 13 Monday, March 02, 2009 Tuesday, March 03, 2009 Wednesday, March 04, 2009 Wednesday, March 04, 2009 Thursday, March 05, 2009 Saturday, March 07, 2009 Sunday, March 08, 2009 Tuesday, March 10, 2009 Wednesday, March 11, 2009 Thursday, March 12, 2009 Friday, March 13, 2009 Friday, March 13, 2009 Saturday, March 14, 2009 Monday, March 16, 2009 Tuesday, March 17, 2009 Wednesday, March 18, 2009 Thursday, March 19, 2009 Friday, March 20, 2009 Sunday, March 22, 2009 Monday, March 23, 2009 Tuesday, March 24, 2009 Wednesday, March 25, 2009 Wednesday, March 25, 2009 Thursday, March 26, 2009 Friday, March 27, 2009 Saturday, March 28, 2009 Sunday, March 29, 2009 Monday, March 30, 2009 Tuesday, March 31, 2009 20 16 79 31 74 16 38 83 77 77 87 74 92 39 64 94 49 22 42 104 23 73 89 76 89 18 14 25 65 Heavy Moderate Moderate Light Moderate Heavy Moderate Moderate Light Heavy Heavy Moderate Moderate Light Moderate Moderate Light Heavy Heavy Heavy Moderate Light Heavy Heavy Moderate Moderate Light Moderate Heavy 2S-Med 2N-Med 2S-Med Clinic 2N-Med Peds 2N-Med 3S-Surg 3N-Surg 2S-Med 2N-Med 2N-Med 3S-Surg 3N-Surg 2S-Med 2N-Med 3S-Surg 3N-Surg 2S-Med 2N-Med 2N-Med 3S-Surg 3N-Surg 2S-Med 2S-Med 2N-Med Peds 3N-Surg 3S-Surg 2 2 3 1 2 2 3 1 2 2 3 2 1 2 3 1 2 2 3 1 2 2 3 1 2 2 3 1 1 Chapter 4 - Process Analysis Tools Problem 4.6 Patient 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 Appt Time Arrival Time Transporter Unit 8:15 8:25 A Med 2S 10:00 10:00 A Psych 4:30 4:45 B Surg 3N 11:00 11:10 B Med 2N 8:45 8:45 C OB 8:15 8:15 C Med 2S 10:00 10:00 D Psych 4:30 4:30 D Surg 3N 1:45 1:45 E Peds 2:15 2:15 E Surg 3S 9:00 9:00 A Med 2N 11:55 11:55 A OB 8:00 8:00 B Peds 1:45 1:50 B Surg 3S 2:15 2:20 C Med 2S 9:00 9:00 C Med 2N 11:55 11:55 D OB 8:00 8:15 D OB 10:30 10:35 E Psych 3:00 3:00 E Psych 8:00 8:00 A Surg 3S 1:15 1:15 A Med 2S 2:15 2:30 B Psych 10:30 10:30 B Surg 3N 3:00 3:00 C Med 2N 8:00 8:00 C Surg 3S 1:15 1:15 D Med 2S 2:15 2:30 D Med 2S 11:45 11:45 E OB 4:30 4:30 E OB 8:30 8:30 A Surg 3N 3:00 3:00 A Med 2N 2:45 3:00 B OB 11:45 11:45 B Peds 4:30 4:30 C Surg 3S 8:30 8:30 C Surg 3N 3:00 3:05 D Med 2N 2:45 2:45 D Med 2N 8:00 8:00 E Med 2S 11:00 11:00 E Med 2S 9:15 9:15 A Peds 2:30 2:30 A Surg 3S 3:30 3:30 B Med 2S 8:00 8:00 B Psych 11:00 11:10 C Surg 3N 9:15 9:15 C Peds 2:30 2:30 D Surg 3S 3:30 3:30 D Surg 3S 11:00 11:00 E Surg 3N Day M M M M M M M M M M T T T T T T T T T T W W W W W W W W W W Th Th Th Th Th Th Th Th Th Th F F F F F F F F F 50 8:45 8:45 E Med 2N F ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

Hey,Kindly find the attached solution and let me know in case of any question.Thank you

Running Head: PROCESS CONTROL ANALYSIS

Process Control Analysis
Name
Institution

1

PROCESS CONTROL ANALYSIS

2
1. Pareto Chart

Pareto charts are graphical techniques used to rank business processes from the most to
the least frequent with an objective of directing resources on the aspects that produce the greatest
overall implication. In the data provided the Pareto chart is as shown below.

Pareto Chart
Frequency

25

120.00%
100.00%
80.00%
60.00%
40.00%
20.00%
0.00%

20
15
10
5

18647141

18484358

12462942

12215719

9834645

7900032

7288632

6067494

5978419

5914639

2052403.725

0

Frequency

Cumulative %

Bins

The common thing among states with longer lengths of stay is that they have comparatively
higher number of hospitals, and staffed beds. The total revenue among these states is also high.
2. Histogram
A histogram is a graphical representation of the distribution of data. It can also be used to
test the normality of data by observing the height of the bars. The histogram produced by the
Ch04Problems.xls file shows the distribution of the lengths of stay in different hospitals. It can
be observed that the data is approximately normal. The mean and standard deviation of the
length of stay is 1.6730 and 0.2469. The interval (1.179, 2.1668) represents 2 standard deviations
of the mean. If the 2-standard deviation of the mean criterion id used to determine hospitals with
extremely high or low lengths of stay, then all the hospitals whose stay is less than 1.179 or

PROCESS CONTROL ANALYSIS

3

higher than 2.1668 should be reviewed. Clearly the hospitals that should be reviewed in DRG143
case are Monongahela Valley, Clearfield, Somerset Center Health, St Joseph's/Philadelphia,
Canonsburg General, Ellwood City, Hanover, and UPMC South Side. The histogram is as shown
below;

Histogram
60

Frequency

50
40
30
Frequency

20
10
0
1.2-1.4

1.4-1.6

1.6-1.8

1.8-2

2-2.2

2.2-2.4

2.4+

Bin

3. Scatter Plot
A scatter plot is used to represent individual numerical values. It is useful in assessing the
relationship between two variables. The scatter plot below displays the relationship between total
discharges and total patient days.
20,000,000
15,000,000
10,000,000
5,000,000
0

0

500,000 1,000,0001,500,0002,000,0002,500,0003,000,0003,500,000

PROCESS CONTROL ANALYSIS

4

The relationship can be described as positive linear because as the total number of patient days
increases the number of discharges increase. It is linear because the points approximately follow
a straight line.
4. Scatter Plot
The scatter plot shown below shows the relationship between the number of cases and the
length of stay.

3
2.5
2
1.5
1

0.5
0
0

200

400

600

800

1000

1200

1400

1600

1800

2000

Since the points do not follow any definite pattern, the two variables (number of cases and the
length of stay) are uncorrelated and are both independent. It implies that one variable cannot be
used to predict the value of the other variable.
6. Process Distribution Check Sheet / Defect Factor Check Sheet
A process Distribution Check sheet is used to represent the distribution of data. The
check sheet below displays the distribution of late arrivals. The total number of times

PROCESS CONTROL ANALYSIS

5

transporters arrived between 1 to 5, 6 to 10, 11-15 minutes late was 4, 3, 5 respectively. None of
the transporters arrived later than 15 minutes.

The defect factor sheet is used to determine whether the distribution of the data was due to any
specific factor. In the sheet below, the total number of times transporter A, B, C, D, and E were
late are 1, 5, 2, 3, 1 respectively. Late arrivals cannot be blamed on one transporter but
transporter B and D with 5 and 3 late arrivals respectively should be reviewed because they are
responsible for most late arrivals.

7. Multi-voting Process
Multi-voting is a process of decision making that aims at taking into considerations all the
opinions of different individuals and then narrows down to a smaller list of possibilities. This method
ensures that an opinion or project favored by every team member is selected. If the 3 votes of each
member were considered then to total rankings for projects A, B, C, D, E, F, G, H, and I are

PROCESS CONTROL ANALYSIS

6

4,4,2,6,2,1,4,3, and 4 respectively. The project with the highest total rank is Project D and should be
selected.

Project Jacob Isabella Ethan Emma Olivia Totals
A
B

3
1

C
D

4

3

4

2

2

3

E

3
1

6

1

F

2
1

G

2

H

3

I

1

2

1
2

4
3

2

4

PROCESS CONTRO...

achiaovintel (7931)
Boston College

Anonymous
The tutor was pretty knowledgeable, efficient and polite. Great service!

Anonymous
Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful.

Anonymous
Just what I needed… fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4