90.2K

Verified Solution

Link Copied!

the second and third pictures are directly from the excel sheet.

the excel sheet has been provided here

3. Create a histogram of average charges (must be calculated from data provided) in North Carolina hospitals using the 3570Hw01.20.xls data file, Tab: Scatter+. Is average charge normally distributed? Histograms and Scatter Charts 723 North Carolina Staffed Total City Beds Hospital Name Discharges Moore Regional Hospitals Hoke Campus Huntersville 751 6,581 122 9,395 Johnston Health Matthews 8 Betsylehnson Regional Hospital Fayetteville 586 31,060 Annie Penn Hospital Durham 887 38,958 10 Carteret General Hospital Cary 156 9,837 11 ...IVAS Chapel Hill 824 44,272 12 Onslow Memorial Hospital Charlotte 94 7,525 13 Carolina East Medical Center Asheville 36,964 14 SORIOS ESPECIEL.CENESS Winston-Salem 866) 44,978 15 Mission Hospital Saint Joseph Campus Charlotte 235 16.109 16 Asheville VA Medical Center Winston-Salem 828 36, 363 17 Caldwe Memorial Hospital Greenville 909 41.741 18 Nash General Hospital Bolivia 661 4,441 19 Cape Fear Valley Medical Center Raleigh 664 31,086 20 Cape Fear Valley. Hoke Hospital Charlotte 1.178 53,807 21 High Point Regional Hospital Gastonia 370 22.080 22 Central Prison Hospital Morehead City 104 5.523 23 Fayetteville VA Medical Center Morganton 154 8.461 24 Cleveland Regional Medical Center Raleigh 148 7.7671 25 Campinas Medical Center Pinevile Wilmington 755 35,817 26 Stanly Regional Medical Center Durham 18 1.684 27 Control Carolina Hospital Greensboro 896 43.326 28 Caro Mont Regional Medical Center Raleigh 553 25,216 29 Central Hamett. Hospital Henderson 102 4.936 30 Blue Ridge Regional Hospital Charlotte 652 25.1881 31 First Health Moore Regional Hospital Pinehurst 453 22.972 32 Carolinas Medical Center New Bern 284 11,934 33 Carolinas Health Care System Anson Salisbury 211 8,611 34 Duke Regional Hospital High Point 326 15.664 35 Erst Health Richmond Memorial Hospital Concord 457 22,112 36 Cherokee Indian Hostal Smithfield 175 7.852 37 Northam Hospits of Sury. County Jacksonville 162 8.943 38 Catawba Valley Medical Conter Lumberton 349 14.905 39 Durham VA Medical Center Burlington 218 9.889 40 Carolinas Medical Center Union Durham 355 14.076 41 Carolinas Medical Center North East Goldsboro 261 10.123 Alamance Regional Medical Center Wilmington 44 711 43 Hamis Regional Hospital Dunn 151 6,765 Halifax Regional Medical Center Lincolnton 101 4,465 Carolinas Medical Center Lincoln CORBEEGOLAR Statesville 203 7.377 Rocky Mount 353 12.291 47 Erve Regional Medical Center Wilmington 94 3.813 Brenner Children's Hospital Lenoir 110 3.373 Novent Health Mattews Medical Center Sylva 82 3.874 50 Martin General Hospital Clinton 75 51 3.144 Duke University Hospital Elizabeth City 142 52 Mission Hospital. Memorial Campus 5.233 Boone 94 3,856 53 Novant Health Rowan Medical Center Marion 49 2.169 S4 Morehead. Memorial Hospital Sanford 127 SS 5.105 Haywood Regional Medical Center Roanoke Rapids 128 S6 4.680 Fredell Memorial Hospital Hendersonville 98 57 3,653 Mooresville 123 5,302 Run Pivot+ Scatter+ Pareto Bariatric Patient Gross Patient Days Revenue (5000) 24.696 $398,801 37,249 $504,090 178.2891 $2,390.184 262.135 $5,811,833 45,226 $640 150 220.337 $2.952,566 24,926 $706,753 190.711 $2.474.223 223,652 $2.561,061 50,499 $1,167.900 0.936 $3.344.166 226,940 $2.862384 16,469 $275,789 164 729 $2.704,555 292.167 $6,115,716 89,826 51.226.956 24,582 $312.939 35,412 $761.369 33,759 $1,077.507 171,424 $2,187,529 4.065 $105.783 194,171 $2.358,148 119.593 $2.117.625 22.027 $311.637 138.786 $1.990.793 95.4631 $1.393,162 58.896 $839,762 43 557 $583.994 66,0991 $707.671 91.663 $1.663,005 34,9441 $634.933 32.140 $401,421 67 348 $857.962 41,450 $468.739 672270 $880.874 48.975 $490,613 8.115 $19,011 27.631 $382.869 18,291 $434,857 35,883 $487.672 60.922 $710.673 15.7751 $20.996 18.377 $281.665 13.522 $244,374 11.928 $160,066 22.057 $269,441 14,530 $316.422 7383 $132.663 18.992 $347.245 19,076 $248,6318 14,510 $420,696 18,050 $544,242 + C D E F G A B 58 Novant Health Huntersville Medical Center Asheboro 59 Maria Parham Medical Center Hickory 60 Lenoir Memorial Hospital Monroe 61 North Carolina Specialty Hospital Winston-Salem 62 Davie Medical Center Bermuda Run 63 Carolinas Medical Center - Mercy Kinston 64 Duke Raleigh Hospital Hamlet 65 Novant Health Medical Park Hospital Lexington 66 Hugh Chatham Memorial Hospital Rutherfordton 67 Lexington Medical Center Hendersonville 68 Laurinburg 69 Johnston Health Clayton Whiteville 70 Carolinas Medical Center - University Wilson 71 Murphy Medical Center Tarboro 72 Rutherford Hospital Albemarle 73 Sentara Albemarle Medical Center Charlotte 74 Pardee Hospital Williamston 75 Granville Medical Center Kings Mountain 76 Davis Regional Medical Center Reidsville 77 Columbus Regional Healthcare System Hickory 78 Ahoskie 79 Randolph Hospital Kenansville 80 New Hanover Regional Medical Center Washington 81 Person Memorial Hospital Clyde 82 McDowell Hospital Shelby 83 Someron Regional Medical Center Mount Airy 84 Rockingham 85 Scotland Memorial Hospital Statesville 86 Novant Health komersville Medical Center Elkin 87 Southeastom Regional Medical Center Spruce Pine 88 Sandhills Regional Medical Center Thomasville 89 Novant Health Bounswick Medical Center Oxford 90 Lake Norman Regional Medical Center 91 Valdese Naval Hospital Camp Lccune 92 Novant Health Forsyth Medical Center Roxboro 93 Park Ridge Health Eden Murphy 145 258 220 22 111 181 64 80 143 216 154 154 274 117 109 80 481 59 1521 355 1141 741 100 138 353 1331 141 130 180 49 146 122 131 102 229 187 22.461 6,005 21,015 $302,216 9,502 36,629 $631,105 7,989 31.038 $623.933 847 3,087) $139,656 3,523 15,124 $254,311 5.080 24,591 $238,684 2,039 8,692 $144,575 3,098 10.788 $195,334 4,558 18.517 $243,201 7,068 27,299 $420.938 5,5101 19,139 $393.750 4,683 18.553 $234,310 6,918 32,825 $454,028 3.659 13,586 $221,014 4.245 12.614 $338,313 3,449 8.860 $299,094 1.608 5.307 $126.652 1,538 6,308 $173,092 3,661 15.686 $86,584 8,490 36,569 $1.012.303 3,1831 11,621 $188.216 2.275 7,253 $120,311 2.611 9.613 $174,219 4,022 13,008 $316.485 8,599 32.528 $724,300 4,067 12.036 $193,768 3.427 12.1.50 $116.192 3,663 10.637 $268.258 4.142 14.493 $265.995 1.495 3.756 $102,313 3.567 10.545 $221,589 2.348 8.425 $137.771 2.076 8.071 $259.581 1.569 5.783 $98,915 3.554 12.512 1.779 $227.678 5.779 $171.306 961.859 4.529.910 $71.474,113 94 TOTAL 95 96 97 99 100 101 102 103 104 105 106 107 3. Create a histogram of average charges (must be calculated from data provided) in North Carolina hospitals using the 3570Hw01.20.xls data file, Tab: Scatter+. Is average charge normally distributed? Histograms and Scatter Charts 723 North Carolina Staffed Total City Beds Hospital Name Discharges Moore Regional Hospitals Hoke Campus Huntersville 751 6,581 122 9,395 Johnston Health Matthews 8 Betsylehnson Regional Hospital Fayetteville 586 31,060 Annie Penn Hospital Durham 887 38,958 10 Carteret General Hospital Cary 156 9,837 11 ...IVAS Chapel Hill 824 44,272 12 Onslow Memorial Hospital Charlotte 94 7,525 13 Carolina East Medical Center Asheville 36,964 14 SORIOS ESPECIEL.CENESS Winston-Salem 866) 44,978 15 Mission Hospital Saint Joseph Campus Charlotte 235 16.109 16 Asheville VA Medical Center Winston-Salem 828 36, 363 17 Caldwe Memorial Hospital Greenville 909 41.741 18 Nash General Hospital Bolivia 661 4,441 19 Cape Fear Valley Medical Center Raleigh 664 31,086 20 Cape Fear Valley. Hoke Hospital Charlotte 1.178 53,807 21 High Point Regional Hospital Gastonia 370 22.080 22 Central Prison Hospital Morehead City 104 5.523 23 Fayetteville VA Medical Center Morganton 154 8.461 24 Cleveland Regional Medical Center Raleigh 148 7.7671 25 Campinas Medical Center Pinevile Wilmington 755 35,817 26 Stanly Regional Medical Center Durham 18 1.684 27 Control Carolina Hospital Greensboro 896 43.326 28 Caro Mont Regional Medical Center Raleigh 553 25,216 29 Central Hamett. Hospital Henderson 102 4.936 30 Blue Ridge Regional Hospital Charlotte 652 25.1881 31 First Health Moore Regional Hospital Pinehurst 453 22.972 32 Carolinas Medical Center New Bern 284 11,934 33 Carolinas Health Care System Anson Salisbury 211 8,611 34 Duke Regional Hospital High Point 326 15.664 35 Erst Health Richmond Memorial Hospital Concord 457 22,112 36 Cherokee Indian Hostal Smithfield 175 7.852 37 Northam Hospits of Sury. County Jacksonville 162 8.943 38 Catawba Valley Medical Conter Lumberton 349 14.905 39 Durham VA Medical Center Burlington 218 9.889 40 Carolinas Medical Center Union Durham 355 14.076 41 Carolinas Medical Center North East Goldsboro 261 10.123 Alamance Regional Medical Center Wilmington 44 711 43 Hamis Regional Hospital Dunn 151 6,765 Halifax Regional Medical Center Lincolnton 101 4,465 Carolinas Medical Center Lincoln CORBEEGOLAR Statesville 203 7.377 Rocky Mount 353 12.291 47 Erve Regional Medical Center Wilmington 94 3.813 Brenner Children's Hospital Lenoir 110 3.373 Novent Health Mattews Medical Center Sylva 82 3.874 50 Martin General Hospital Clinton 75 51 3.144 Duke University Hospital Elizabeth City 142 52 Mission Hospital. Memorial Campus 5.233 Boone 94 3,856 53 Novant Health Rowan Medical Center Marion 49 2.169 S4 Morehead. Memorial Hospital Sanford 127 SS 5.105 Haywood Regional Medical Center Roanoke Rapids 128 S6 4.680 Fredell Memorial Hospital Hendersonville 98 57 3,653 Mooresville 123 5,302 Run Pivot+ Scatter+ Pareto Bariatric Patient Gross Patient Days Revenue (5000) 24.696 $398,801 37,249 $504,090 178.2891 $2,390.184 262.135 $5,811,833 45,226 $640 150 220.337 $2.952,566 24,926 $706,753 190.711 $2.474.223 223,652 $2.561,061 50,499 $1,167.900 0.936 $3.344.166 226,940 $2.862384 16,469 $275,789 164 729 $2.704,555 292.167 $6,115,716 89,826 51.226.956 24,582 $312.939 35,412 $761.369 33,759 $1,077.507 171,424 $2,187,529 4.065 $105.783 194,171 $2.358,148 119.593 $2.117.625 22.027 $311.637 138.786 $1.990.793 95.4631 $1.393,162 58.896 $839,762 43 557 $583.994 66,0991 $707.671 91.663 $1.663,005 34,9441 $634.933 32.140 $401,421 67 348 $857.962 41,450 $468.739 672270 $880.874 48.975 $490,613 8.115 $19,011 27.631 $382.869 18,291 $434,857 35,883 $487.672 60.922 $710.673 15.7751 $20.996 18.377 $281.665 13.522 $244,374 11.928 $160,066 22.057 $269,441 14,530 $316.422 7383 $132.663 18.992 $347.245 19,076 $248,6318 14,510 $420,696 18,050 $544,242 + C D E F G A B 58 Novant Health Huntersville Medical Center Asheboro 59 Maria Parham Medical Center Hickory 60 Lenoir Memorial Hospital Monroe 61 North Carolina Specialty Hospital Winston-Salem 62 Davie Medical Center Bermuda Run 63 Carolinas Medical Center - Mercy Kinston 64 Duke Raleigh Hospital Hamlet 65 Novant Health Medical Park Hospital Lexington 66 Hugh Chatham Memorial Hospital Rutherfordton 67 Lexington Medical Center Hendersonville 68 Laurinburg 69 Johnston Health Clayton Whiteville 70 Carolinas Medical Center - University Wilson 71 Murphy Medical Center Tarboro 72 Rutherford Hospital Albemarle 73 Sentara Albemarle Medical Center Charlotte 74 Pardee Hospital Williamston 75 Granville Medical Center Kings Mountain 76 Davis Regional Medical Center Reidsville 77 Columbus Regional Healthcare System Hickory 78 Ahoskie 79 Randolph Hospital Kenansville 80 New Hanover Regional Medical Center Washington 81 Person Memorial Hospital Clyde 82 McDowell Hospital Shelby 83 Someron Regional Medical Center Mount Airy 84 Rockingham 85 Scotland Memorial Hospital Statesville 86 Novant Health komersville Medical Center Elkin 87 Southeastom Regional Medical Center Spruce Pine 88 Sandhills Regional Medical Center Thomasville 89 Novant Health Bounswick Medical Center Oxford 90 Lake Norman Regional Medical Center 91 Valdese Naval Hospital Camp Lccune 92 Novant Health Forsyth Medical Center Roxboro 93 Park Ridge Health Eden Murphy 145 258 220 22 111 181 64 80 143 216 154 154 274 117 109 80 481 59 1521 355 1141 741 100 138 353 1331 141 130 180 49 146 122 131 102 229 187 22.461 6,005 21,015 $302,216 9,502 36,629 $631,105 7,989 31.038 $623.933 847 3,087) $139,656 3,523 15,124 $254,311 5.080 24,591 $238,684 2,039 8,692 $144,575 3,098 10.788 $195,334 4,558 18.517 $243,201 7,068 27,299 $420.938 5,5101 19,139 $393.750 4,683 18.553 $234,310 6,918 32,825 $454,028 3.659 13,586 $221,014 4.245 12.614 $338,313 3,449 8.860 $299,094 1.608 5.307 $126.652 1,538 6,308 $173,092 3,661 15.686 $86,584 8,490 36,569 $1.012.303 3,1831 11,621 $188.216 2.275 7,253 $120,311 2.611 9.613 $174,219 4,022 13,008 $316.485 8,599 32.528 $724,300 4,067 12.036 $193,768 3.427 12.1.50 $116.192 3,663 10.637 $268.258 4.142 14.493 $265.995 1.495 3.756 $102,313 3.567 10.545 $221,589 2.348 8.425 $137.771 2.076 8.071 $259.581 1.569 5.783 $98,915 3.554 12.512 1.779 $227.678 5.779 $171.306 961.859 4.529.910 $71.474,113 94 TOTAL 95 96 97 99 100 101 102 103 104 105 106 107

Answer & Explanation Solved by verified expert

See Answer