HMGT 400 6382 Research And Data Analysis In Healthcare (2222) Reading homework help

 ASSIGNMENTS & ETC ATTACHED 

Dataset: HMGT400HOSPITAL.csv (may be downloaded below.)

Required analysis program: Analysis ToolPak – for all analyses in this class (RStudio or R Programming for BONUS point seekers only – 10 bonus points if used for analysis).

Author, Hossein Zare, PhD

Citation: Zare, H. (2017). HMGT 400 Research and Data Analysis in Health Care-Exercise. UMGC.EDU

Exercise # 1 Instructions:

1. You may download the dataset from the link below. This dataset provides information about hospitals in 2011 and 2012. Before you do that however consult the additional instructions that I provided to you in 4 PDF email attachments.  ([a]. Ex 1 – Additional Instructions [b] Ex 1 – Instructions t-Test to compare means [c] Ex 1 – Example t-Test Output. [d] Ex 1 – Example Output – Graphs).

2. Analyze the data, using these instructions. Your objective is to use the results of your analysis to create “summary statistics” (Count (N), Mean, and Standard Deviation) for each hospital characteristic and each year (2011 and 2012) and complete Table 1 (template below). You should then create any meaningful graphs (using Excel) to summarize your findings and to write a short paragraph summary report describing your findings.

3. Your report may be in WORD format, with the tables you create in Excel copied and pasted in WORD. Submit your report to the appropriate folder. 

Table 1. Descriptive statistics between hospitals in 2011 & 2012

Exercise 1 Findings: Based on your findings, in which years did the hospitals have better performance? Please write a short paragraph and describe your findings. Make sure to attach plot(s) or graph(s) of the information to your report.

Instructions:

Use Analysis ToolPak for all analyses (mandatory).

(for BONUS points: Use RStudio. The R script is available below for this exercise, but you need to modify the script for this analysis).

Download data from here: HMGT400HOSPITAL

Download RStudio script from here:E1-Codes

Download RStudio script from here (If you were not able to load the DPLYR package use this scrip):E1-Codes-No-Dplyr

stata_namestcdyeartotal_hosp_costtotal_hosp_revenuehospital_bedsbedsize_catteaching_hospitalsystem_memberlevel_traumawhiterural_areaherf_catherf_indexnon_whitelog_hosp_costlog_hosp_revenuetotal_hospital_bedstotal_hospital_medicare_daystotal_hospital_medicaid_daysinterns_and_residentstotal_hospital_employees_on_payrtotal_hospital_non_paid_workerstotal_hospital_medicare_dischargtotal_hospital_medicaid_dischargtotal_hospital_dischargesown
Arizona8620121.89E+071.73E+0719100058.701041.316.7543516.66785168.9211551.58206.92855.0482695.488286788790
Arizona8620128.01E+077.94E+0788300058.501241.518.1987518.19138.0214629.862423.521209.0244117.73669769981
Arizona8620121.47E+081.33E+081344000820121818.8046818.7026574.163784.24354.38490.4641305.488125343200
Arizona8620127.74E+078.81E+07723000820121818.1642418.2943925.75306225.42132.8474.504662570
Arizona8620121.53E+081.41E+08187400058.701241.318.8458818.7625719.571545.398.94139.608259.096184292
Arizona8620121.60E+071.70E+0721100020.410279.616.5873816.6504420.61042.44235.62185.148160.128773662
Arizona8620127.02E+087.55E+08460700155.301244.720.3694720.4425493.3728329.4846840.44356.344570.985216.3929139263412
Arizona8620122.07E+072.29E+0714100358.501241.516.8436116.94799237.935724.2411063.9495.391073.821195.4148168360
Arizona8620121.67E+081.72E+08163400355.301244.718.9344618.9601614.42961.86255154.62151.232983561
Arizona8620122.32E+072.06E+07563010160128416.9596516.8425561.83816.841180.14307.21159.81631227380
Arizona8620129.60E+071.20E+083550401058.701041.318.3793618.5989637.081138.322433.72315.804433.6866024260
Arizona8620121.31E+081.49E+081104010820121818.6894118.82107101.978494.563713.828882.9242048.30493443321
Arizona8620121.81E+081.99E+08460501058.701041.319.0166719.10902360.512812.229098.411103155.8562109109251
Arizona8620125.37E+073.92E+073550201058.701241.317.7986217.48499210.1210312.29235.081303.4642696.62715122350
Arizona8620122.28E+082.45E+083550601058.701041.319.2445719.31838354.3227260.529731.821711.2847236.8962559184131
Arizona8620123.15E+083.79E+08267501155.202244.819.5689919.7525252.3516108.8615733.51894.1883968.7283487128952
Arizona8620122.64E+082.81E+08460501158.701041.319.3909919.45325273.9817960.1616340.41704.8164232.2723447162982
Arizona8620124.70E+085.17E+083550801158.701041.319.9689920.06368273.9817960.1616340.41704.8164232.2723447162981
Arizona8620123.94E+084.35E+083550701158.701041.319.7919119.89182273.9817960.1616340.41704.8164232.2723447162981
Arizona8620123.48E+073.67E+0725201365.901234.117.3639517.418570
Arizona8620125.24E+075.62E+0749210052.302247.717.7736617.8452507.7929487.1840869.3644.663096.067225.7768762296441
Arizona8620124.28E+084.54E+08553810055.301244.719.875619.932950.472233.82249.1500.772563.78465420950
Arizona8620121.22E+081.23E+0889310343.911256.118.6197718.6299391.674144.265121.42788.2561223.2154437120
Arizona8620122.23E+082.16E+083550411058.701041.319.2243619.19189244.1129369.882147.189.715149.5366878.832264123152
Arizona8620122.27E+082.68E+083550611058.701041.319.2405819.40528397.5838496.844977.61.882182.0569723.3281340220691
Arizona8620129.23E+089.84E+08244511058.701041.320.6434120.70665327.5432268.7211889.121869.1088493.4562780204642
Arizona8620122.72E+082.95E+083550711058.701041.319.4201419.50291169.958433.36127501059.3242466.4164690136540
Arizona8620126.06E+086.80E+083550811158.701041.320.2217920.33736585.0437101.4853716.26129.34415.167460.40810624362750
Arizona8620121.98E+082.41E+083550511258.701041.319.103119.30064220.4212159.4224371.881554.483299.3045620187962
Arkansas71201281250457994666492000840121615.9104615.89429111.248150.821690.14717.7682257.3680346342
Arkansas7120127.38E+077.72E+07125400095.20224.80000318.1163518.16157120.5111514.781907.4704.8082766.65656149251
Arkansas7120127.12E+077.71E+071244000890121118.0807218.1607313.391.02112
Arkansas7120122.28E+072.36E+0733200068.210231.816.943716.9751325.75178557.12103.896394.76265021
Arkansas7120121.05E+071.03E+07853000711022916.1690716.14325.751164.8444.88178.392306.912223951
Arkansas7120121.62E+071.88E+0725200040.310259.716.6015516.7500825.751051.62194.82117.936259.096624142
Arkansas7120129525674823361725200092.21027.80000316.069515.9237425.752970.24762.96180.468760.60842912432
Arkansas7120122.08E+072.22E+0772300084.110215.916.8508316.9146325.753277.26839.46177.708684.99214411362
Arkansas7120121.90E+071.95E+07352000581024216.7586916.784325.751048.56140.76108.792253.536473801
Arkansas7120127280002612433126200095102515.8006415.6277825.752063.461147.5203.184529.31242712132
Arkansas7120128981868877991425200046.810253.216.0107215.9879825.752063.461147.5203.184529.31242712132
Arkansas7120121.80E+081.80E+08333600241.402258.619.0079619.00953226.621352.683790.3216.251445.75354.281043114441
Arkansas7120121.61E+081.64E+08266500396012418.8999318.91253284.2839680.0410245.916.761947.2648560.1762906170860
Arkansas7120125.86E+075.84E+07125400395.40124.59999817.8869717.88236117.4210665.122298.06700.382274.0486349282
Arkansas7120121.34E+081.34E+08146400382.401217.618.7102318.71331172.0120803.922783.581168.8725972.55293996662
Arkansas7120122.37E+082.55E+08375600379.602220.419.2827719.35728172.0120803.922783.581168.8725972.55293996662
Arkansas7120123.19E+073.25E+0780300383.510216.517.277517.2959759.743112.021345.38344.82821.76855026322
Arkansas7120122.39E+073.39E+07143400394.11025.90000216.9904417.3400630.91881.9263.16171.948603.816738151
Arkansas7120121.65E+071.69E+0746200395.91024.09999816.6206716.6434525.752254.2130.56210.636449.248356000
Arkansas7120121.85E+071.91E+0741200476.701223.316.7333416.764922
Arkansas7120121.34E+071.19E+0725200446.810253.216.4119916.2922125.751712.58548.76140.916385.8642278341
Arkansas7120129563577825876625201093.80126.19999716.0734715.92679220.4229111.824643.041369.1166231.6481279108790
Arkansas7120121.78E+081.75E+082825010840121618.996918.9805164.810821.182282.76973.4643209.23291386821
Arkansas7120121.58E+081.78E+08141401076.601223.418.8809718.9970425.751110.7880.5870.944224.624183071
Arkansas7120121.02E+07757494224101085.310214.716.1375215.8403624.721094.4660.1853.4264.656173771
Arkansas7120121.51E+081.56E+08171401289.801210.218.8305418.86587442.947683.9810017.4251928.3769634.3682162205432
Arkansas7120123.57E+083.23E+08409701255.301144.719.6944819.59453142.1421330.243384.361202.7964393.512118280001
Arkansas7120124.74E+084.73E+08703801255.301144.719.9766119.97376691.1370966.512676.565.53352.53613084.9043029323772
Arkansas7120122.22E+081.99E+08374601372.801227.219.2183619.11002302.8226373.124982.71558.85163.0161518121470
Arkansas7120121.25E+071.36E+0720101367.400232.616.3428216.4240725.752405.16158.1142.2444.8496682
Arkansas7120121.63E+071.99E+07252013841021616.6068616.8079125.751399.44181.56169.704384.752627272
Arkansas7120127635363687206316101492.21027.80000315.848315.7429816.48861.917.3451.816140.11271742
Arkansas7120126.05E+075.55E+07142410045.201254.817.918117.83119126.698201.822879.469572.8681688.016103936572
California9320128.37E+078.64E+071064000380226218.2423918.27405215.2719378.988950.51236.4083642.9121993100692
California9320122.31E+072.02E+0745200075.202224.816.9538116.82317354.3241602.742518.383142.89791.16522177750
California9320122.42E+082.25E+08354600046.701253.319.3045119.23256161.7114347.323139.561226.2922643.22446671480
California9320129.66E+071.11E+0854300041.901258.118.3858218.52615342.9917475.6633372.361618.8243384.9288768161951
California9320122.58E+082.94E+08279500033.301166.719.3695419.49981109.187997.8210123.5798.781407.792315049191
California9320122.63E+083.03E+08345600048.701251.319.3859719.5282155.624399.26989.4345.492840.67217419170
California9320123.85E+084.66E+08235500032.902267.119.7683219.96018249.2615628.447954.9811809.63620.6721685129060
California9320124.86E+085.21E+08377600027.801072.220.0023620.07216321.3626351.77998.842909.4965955.8722082234352
California9320125.25E+084.99E+08540800039.701260.320.0781420.02845287.3716533.184152.421958.6643880.88864152731
California9320123.09E+083.20E+08843600227.801072.219.5488519.58282322.3923063.2224211.748.11622.8084431.324284136601
California9320122.88E+083.17E+08212500358.802241.219.4786319.5740630927895.9816155.781423.4166154.923730130040
California9320123.22E+083.34E+08157400340.802259.219.5889519.62522185.413104.962485.741695.2883135.8455181980
California9320125.57E+075.67E+0725200479.511220.517.8362317.8536625.752215.441472.88434.592718.35238415370
California9320123.74E+074.62E+0725

Looking for this or a Similar Assignment? Click below to Place your Order