Data Patient IDLOSAgeSexAmtReimTotAccomChgTotDeptChgTotChgNumDxCodesadmsrcdischdestdrgcode 184110372196328144277769406291 2542103061227023259355299101291...

attached documents


Data Patient IDLOSAgeSexAmtReimTotAccomChgTotDeptChgTotChgNumDxCodesadmsrcdischdestdrgcode 184110372196328144277769406291 2542103061227023259355299101291 324210306490812834177429101291 42521037249085459103679701291 5232620049088893138017101293 654161861227025758380286701293 7762103721881614516333329706291 86727224147248105228294101293 94726200981622244320609106293 108716200196326506261388401293 116917328147249108238329106292 1273273071881617622364389162292 13831103722181615152369689706291 141742103065971839275989939406291 153716200736223293306559706293 1668273281472411008257329106292 175827328122707951202219106292 18351960481816400145819101291 193317307736215891232539101292 20188293484417244636888089162291 21841103062263216528391609462291 22392711173627642150049603291 233518352736221648290109401292 2465272241472413808285327106293 25331712573627051144139706292 263317307736213726210889701292 2779273281717811598287769501292 2869210372163629502258649703291 296617224147243841185659401293 30792103721717811772289509120291 313928096818112812209939503292 323927224736218325256879762293 33742103721717825524427029701291 342326186490820305252138701293 35361715681817851160329706292 361371103723190238027699299462291 37762103061717821988391669401291 38126173072944833959634079706292 3978210306171787653248319703291 40108293482727012287395579503291 41472722498166545163616462293 42103173282727051831791019106292 434817328100898197182869106292 44147293143629026885631759163291 455727328122707381196519101292 461161103722781329640574539620291 4734110306736216110234729101291 4848183521063516165268009106292 49482835298169050188669503292 5014611037252356540001063569463291 514627307981619578293949401292 52272507754547349128039706291 53672103721608914907309969203291 546716200147247592223169101293 551816200245412934153889701293 5678183521717820868380465706292 57282694649085275101837106293 58282829949086669115777101292 593727091736216887242499706291 604828352981619391292079701292 61841103062154334499560429106291 621231103722972136984667059706291 6359293481227014455267259701291 643428135736221724290869462291 655918352122709817220879706292 6698173282208612891349779101292 67451835298168099179157101292 68166293893926456077953419720291 69472829998166609164259706292 702725954490811836167449706293 71106273072727011076383469162292 726629348163628068244309103291 737728385171783737209159103292 7414173072454634387979101292 75491835298169802196189706292 762526200490817325222337101293 772717328490810749156579101292 78184283524908623614727009703292 7964193481472439146538707101291 804516186981614517243339101293 8158262001227010710229809106293 82113151762972413601433259707293 8343110104981617515273319706291 846319348147248024227489706291 85126273282944817512469609706292 861627307545413419188739720292 8718173072454725797119101292 8817722469181537926451741829520291 89194273075181322010738239706292 9085293481963228685483179762291 91852103721963212937325699662291 92108273282454020389449299103292 93362722473624845122078701293 94581103061227011413236839401291 95381711176357573152089106291 968817328196329014286469106292 9769293481472415619303439706291 982310545414680201349101291 9984171781963227023466558706293 10078162001717815861330399106293 1015328299122709417216879106292 102477119293115897403411562389450291 10368193481472416173308979703291 1046817307147247696224209106292 10586193482181611337331539106291 106371620073624854122166701293 107127262002944822170516189703293 10829150774908497598839706291 109139283523545122129575809762292 1104618299981620513303299701292 111146172244335631181745379762293 1125728352136357406210419406292 11395173072208615972380589706292 11467193481472414957296819706291 115137272523190215884477869706293 11653173281227015440277109101292 117552103721227012367246379406291 1186329314147249204239289101291 11964193481472414024287489106291 120116193142699417687446819406291 12125821328370350613361316869103291 122119282992699410189371839706292 123482829998165602154189403292 1244811037298166083158999701291 125158273283926742305815729706292 126177183524171856768984869665292 12787173281963221843414759706292 1283729314736211111184739701291 129451835298165931157479706292 13067293141305435895489499706291 131282934849087574124827101291 13294193892208638094601809101291 133108183522454014220387609762292 1345817224122709956222269662293 13587173072181618192400088762292 136772100581827021166394369503291 13767273281472419871345959703292 1386926200163629560259229106293 139481732898168393182099103292 14058293481227012906251769106291 14129250884908431792259106292 142118293482699437174641689101291 1432272103725972131004907259106291 144372722473628213155758706293 14577262001717821553387319706293 1466716186147248024227489706293 147482620098166995168116106293 14877293481717814906320849503291 14977183521717813895310739106292 15077193482317813867370459706291 151106102727019106463769706291 15244171781363513328269639706293 153941103722454316223407669706291 1541041103722727014859421299106291 15559173281363522619362549706292 156108283522481320491453049106292 157282722449087530124386101293 158362809673628240156029106292 159471938998168370181869701291 1607727328171788819259979106292 161672103722072419088398129720291 16277182991717823280404589763292 163361722473627926152889106293 164461914598167965177819106291 1651761104134171821486632049151291 166106283522645118721451729703292 1674526186981611391212078101293 1682429348490825068299769501291 16958273281227013065253359701292 1701928299545414773202279520292 1714828299981617999278159703292 172147293483435639941742979703291 1731572103723681035288720989503291 17457210306122706764190349703291 17527150774908445093589706291 17647110169981612498223149706291 17717162002454454670009720293 17896182992208624650467369106292 1791852104134908624523736099101291 1804817307981613703235199106292 1811081103722535927084524439620291 182472732898169117189339162292 1834827328981616523263399103292 1841091103722454020580451209703291 18559183521227014783270539706292 1864918352109089856207648706292 18729160624908481497229706291 1883617125736210933182959406292 1891661999681537488781304159620291 19066273071472414252289769406292 19143193481090822982338909701291 1921072103062454021039455799703291 193362808373627839152018706291 1948627328196329017286499106292 19589193481963211476311085103291 1963619348736213545209079101291 19763162001472420531352559106293 198261611249086006109149103292 199472618698168047178638706293 2001272103722944826315557639503291 201177193484171829424711429106291 202104282992454013549380899103292 2033428135736215985233479503291 204492914598165648154649706291 20554273071227013066253369101292 2064819348981614594244109701291 207104173072454021355458959703292 20859210306122707470197409706291 209992103062208620359424459706291 2101916200245411895143499701293 211116173282699412474394689750292 212166183523981049354891649762292 213361618673625371127339750293 2144626186981617176269929706293 215481829998165386152029503292 2164817224981620038298548706293 217482829988144159129735706292 21814172242454363160856101293 219104293142454045508700489162291 2205717328122705904181749101292 2212720490814757196657701293 222127173282944827402568509103292 223159293143681019218560289762291 2245928352122704125163959106292 2255927224122709425216959706293 2265926228122704807170779106293 22717821320364558627481273069720291 22868171781472413875285996701293 2294816200981618811286279706293 2301081103722454015363399039706291 2316619314130547594206489106291 2326716200163628481248439101293 233118148502999728589585869620291 23419230502454629187459706292 23512210306272718699214269401291 236252730749085110100189101292 237452732898169821196379101292 2381316186245412585150399101293 239582103721227023082353528706291 240992103062317812147353259501291 241381934873628456158189701291 2422515088490813418183269706292 2434921010498168225180419406291 244261694649087100120089106293 24566273281472410096248209706292 24658262001227011347236179706293 2474826186981610900207167706293 2481792103064171824289660079420291 249137273073190222532544349706292 250118162002999713888438859106293 2512716991490810297152059106293 2525827224128165951187679706293 25354293481363522709363449706291 25476262001908915749348389762293 255116293482699421738487329762291 25686182991963218865384979406292 257481722498169616194329106293 258105193142454042265668059703291 25958283521227012269245399106292 2601882103064908630427795139703291 2614728299981625656354729106292 2622341089445393961288419751291 263261835254547815132698701292 264362809673628185155479706292 265351717873628012153749706293 2666518299147245542202669706292 2672616200490816489213979701293 26856183521227012246245169101292 269348132788119436878202072569720291 27038171047362248498469106292 2715817178122706066183369106293 27296183522208622238443249106292 2733818135736215272226349763291 27438181491090820721316299706292 27568110306147249614243389703291 2764527328981614719245359101292 2771682104133926440591798559720291 2782042609054267481281023959706291 2799311030640086620251021119120291 28077271781717818664358429465293 281107152932699718455454529503291 282281618649089125140339101293 283961103062208616268383549101291 2845417328136358158217939720292 28514130562727445571829706292 2862429348490810009149179101291 287331104131036233567439299701291 288381620073629463168259206293 289272732851817370125519701292 29098293482208614179362659706291 291118283522699414936419309703292 2924829112981615547253639705291 29378283521717821798389769706292 294117273282999717736477339106292 29567201608914351304409106291 296107202727013234405049106292 2971261103062944841799712479406291 2981282103063163224625562579103291 29955261861227013170254409701293 30013138002727611888459406292 301383173201908902623834532739720291 302791103061717815214323929503291 30353193481227018549308199401291 3046827328147249972246969401292 305123173282944832845622939106292 306159193483681040286770969703291 3077617252171789586267649703293 3084619112981611703215199706291 3096928385160897453235429503292 31079273071827024993432639762292 3114517307981614962247789406292 312262103721090819015299239720291 31388272242154311179327229520293 314481722498165276150929406293 3155929348122709704219749706291 3165927224122707748200189706293 31737131736216668240309106292 31865293481472410998257229101291 3194627178109087304182129701293 320381622873625733130959701293 32158173281227022359346299101292 32287282991963224769444019603292 32357262001227013403256738101293 32478162001717813961311399406293 325471717898167718175347703293 32674183521717817080342589101292 3273319348736214889222519701291 32869193891472417634323589706291 3295518352122707398196689701292 33024273614908353084389101292 33163173281636223076394389101292 332472911298166107159239106291 33348173071157610013215899106292 334127183523272410951436759462292 3355817224122709561218319706293 33697183522208610719328059762292 337361711173626079134419106291 33895283522208626121482079701292 3394527328981613562233789101292 3404317328981612504223209701292 34167193141472414311290359106291 342186293484417244078882509703291 3435617328122708970212409101292 344217138442545341658522203869406291 34559210306109345263161979450291 346341732873628339157019101292 34786275551963211634312669703292 348105193142454023142476829101291 34986293891963223894435269706291 3501421037224548134105889701291 351442102091157618696302729706291 352991103062290516157390629106291 353471730798169596194129106292 35467171781472412643273679701293 35547273611063529103397389706292 35626222099270902940021649049150292 3578827328196327407270399707292 3585919314122707433197039103291 3594618385981627877376934101292 36057261861227014449267198401293 361372809679086675145839506292 362281595454547418128729106293 363207229308760801079101839909751291 364271730749087635125439101292 3651319314272712252149799707291 366143168344635924719710789101291 367112193142835942020703799706291 3683419389736217404247669701291 3697519314171789520266989101291 3703527104736236842442049706292 371282620049088601135099701293 372156193483681017515543259106291 37378193482917822667518459703291 37438110372736211432187949520291 3756927307147248867235919106292 3765929348122708019202899706291 37746293141090816195271039150291 378641103721472437746524709706291 3793418135736226073334359106291 3801882103724854050009985499450291 3814827328981614916247329706292 3822052103724908020857699379403291 383154293143681017626544369106291 38427159544908438692949706293 38524711153958896613421202389462291 3861541835248810514081002189406292 3872429348490832164370727750291 388127273612944829337587859703292 389232508849088346132548406292 390136193142978740885706729106291 Descriptive Statistics Two-Sampled T-Test Data Dictionary Data ElementDefinitionValuesDefinition Patient IDPatient ID Number LOSLength of Stay AgePatient Age Category SexPatient Gender0Unknown 1Male 2Female AmtReimAmount Paid by Medicare TotAccomChgTotal Accomodation Charges TotDeptChgTotal Departmental Charges NumDxCodesNumber of Diagnosis Codes on Claim admsrcAdmission Source dischdestDischarge Destination 01Discharged to home/self care (routine charge). 02Discharged/transferred to other short term general hospital for inpatient care. 03Discharged/transferred to skilled nursing facility (SNF) 04Discharged/transferred to intermediate care facility 05Discharged/transferred to another type of institution 06Discharged/transferred to home care 07Left against medical advice or discontinued care. 08Discharged/transferred to home under care of a home IV drug therapy 09Admitted as an inpatient to this hospital 20Expired 30Still patient. 40Expired at home (hospice claims only). 41Expired in a medical facility 42Expired - place unknown (Hospice claims only) 43Discharged/transferred to a federal hospital 50Hospice - home (eff. 10/96) 51Hospice - medical facility (eff. 10/96) 61Discharged/transferred within this institution 62Discharged/transferred to an inpatient rehabilitation facility 63Discharged/transferred to a long term care hospital 64Discharged/transferred to a nursing facility 65Discharged/transferred to a psychiatric hospital 66Discharged/transferred to a Critical Access Hospital (CAH) 71Discharged/transferred/referred to another institution 72Discharged/transferred/referred to this institution for outpatient services Answer the questions below considering the CHF Data.xlsx Excel File 1. Assume you have been asked to make sense of the Congestive Heart Failure data in the CHF Data Excel file. Describe two different data visualizations that could be created using the CHF data. For each report, i. Describe what data elements you would use in the visualization, ii. what type of chart you would create and iii. what attributes you would place on the chart (labels, color, etc.) Optionally, create the chart using Tableau and include a copy in this document. This part of the question is optional, and not required. It will give you a chance to play around with the tool. a. Visualization 1 Description b. Visualization 2 Description