UMUC Comparing Average between Acute Care and Not Acute Care Hospitals Paper For this assignment, students should choose data from the quantitative analysi
UMUC Comparing Average between Acute Care and Not Acute Care Hospitals Paper For this assignment, students should choose data from the quantitative analysis below and are asked to analyze it using Excel, RStuido (BONUS points)
Data set:
Minnesota Healthcare Database.xlsx
Medicare National Data by County
MN Hospital Report Data by Care Unit FY2013
MN HCCIS Imaging Procedures 2013
MEPS Dental Files
MEPS Inpatient Stay Database
Students will develop an analysis report, in five main sections, including introduction, research method (research questions/objective, data set, research method, and analysis), results, conclusion and health policy recommendations. This is a 5-6 page individual project report.
Here are the main steps for this assignment.
Step 1: Students require to submit the topic using topic selection discussion forum by the end of week 1 and wait for instructor approval.
Step 2: Develop the research question and
Step 3: Run the analysis using EXCEL (RStudio for BONUS points) and report the findings using the assignment instruction.
The Report Structure:
Start with the
1.Cover page (1 page, including running head).
Please look at the example http://www.apastyle.org/manual/related/sample-experiment-paper-1.pdf (you can download the file from the class) and http://www.umgc.edu/library/libhow/apa_tutorial.cfm to learn more about the APA style.
In the title page include:
Title, this is the approved topic by your instructor.
Student name
Class name
Instructor name
Date
2.Introduction
Introduce the problem or topic being investigated. Include relevant background information, for example;
Indicates why this is an issue or topic worth researching;
Highlight how others have researched this topic or issue (whether quantitatively or qualitatively), and
Specify how others have operationalized this concept and measured these phenomena
Note: Introduction should not be more than one or two paragraphs.
Literature Review
There is no need for a literature review in this assignment
3.Research Question or Research Hypothesis
What is the Research Question or Research Hypothesis?
***Just in time information: Here are a few points for Research Question or Research Hypothesis
There are basically two kinds of research questions: testable and non-testable. Neither is better than the other, and both have a place in applied research.
Examples of non-testable questions are:
How do managers feel about the reorganization?
What do residents feel are the most important problems facing the community?
Respondents’ answers to these questions could be summarized in descriptive tables and the results might be extremely valuable to administrators and planners. Business and social science researchers often ask non-testable research questions. The shortcoming with these types of questions is that they do not provide objective cut-off points for decision-makers.
In order to overcome this problem, researchers often seek to answer one or more testable research questions. Nearly all testable research questions begin with one of the following two phrases:
Is there a significant difference between …?
Is there a significant relationship between …?
For example:
Is there a significant relationship between the age of managers? and their attitudes towards the reorganization?
A research hypothesis is a testable statement of opinion. It is created from the research question by replacing the words “Is there” with the words “There is,” and also replacing the question mark with a period. The hypotheses for the two sample research questions would be:
There is a significant relationship between the age of managers and their attitudes towards the reorganization.
It is not possible to test a hypothesis directly. Instead, you must turn the hypothesis into a null hypothesis. The null hypothesis is created from the hypothesis by adding the words “no” or “not” to the statement. For example, the null hypotheses for the two examples would be:
There is no significant relationship between the age of managers
and their attitudes towards the reorganization.
There is no significant difference between white and minority residents
with respect to what they feel are the most important problems facing the community.
All statistical testing is done on the null hypothesis…never the hypothesis. The result of a statistical test will enable you to either:
1) reject the null hypothesis, or
2) fail to reject the null hypothesis. Never use the words “accept the null hypothesis.”
*Source: StatPac for Windows Tutorial. (2017). User’s Guide; Formulating Hypotheses from Research Questions. Retrieved May 17, 2019 from https://statpac.com/manual/index.htm?turl=formulatinghypothesesfromresearchquestions.htm
What does significance really mean?
“Significance is a statistical term that tells how sure you are that a difference or relationship exists. To say that a significant difference or relationship exists only tells half the story. We might be very sure that a relationship exists, but is it a strong, moderate, or weak relationship? After finding a significant relationship, it is important to evaluate its strength. Significant relationships can be strong or weak. Significant differences can be large or small. It just depends on your sample size.
To determine whether the observed difference is statistically significant, we look at two outputs of our statistical test:
P-value: The primary output of statistical tests is the p-value (probability value). It indicates the probability of observing the difference if no difference exists.
The p-value from above example, 0.9926, indicates that we DO NOT expect to see a meaningless (random) difference of 5% or more in ‘hospital beds’ only about 993 times in 1000 there is no difference (0.9926*1000=992.6 ~ 993).
Note: This is an example from the week1 exercise.
The p-value from above example, 0.0001, indicates that we’d expect to see a meaningless (random) ‘number of the employees on payer’ difference of 5% or more only about 0.1 times in 1000 (0.0001 * 1000=0.1).
CI around Difference: A confidence interval around a difference that does not cross zero also indicates statistical significance. The graph below shows the 95% confidence interval around the difference between hospital beds in 2011 and 2012 (CI: [-40.82 ; 40.44]):
CI around Difference: A confidence interval around a difference that does not cross zero also indicates statistical significance. The graph below shows the 95% confidence interval around the difference between hospital beds in 2011 and 2012 (CI: [-382.16 ; 125.53]):
The boundaries of this confidence interval around the difference also provide a way to see what the upper [40.44] and lower bounds [-40.82].
As a summary:
“Statistically significant means a result is unlikely due to chance.
The p-value is the probability of obtaining the difference we saw from a sample (or a larger one) if there really isn’t a difference for all users.
Statistical significance doesn’t mean practical significance. Only by considering context can we determine whether a difference is practically significant; that is, whether it requires action.
The confidence interval around the difference also indicates statistical significance if the interval does not cross zero. It also provides likely boundaries for any improvement to aide in determining if a difference really is noteworthy.
With large sample sizes, you’re virtually certain to see statistically significant results, in such situations, it’s important to interpret the size of the difference”(“Measuring U”, 2019).
*Resource
Measuring U. (2019). Statistically significant. Retrieved May 17, 2019 from: https://measuringu.com/statistically-significant/
Small sample sizes often do not yield statistical significance; when they do, the differences themselves tend also to be practically significant; that is, meaningful enough to warrant action.
4.Research Method
Discuss the Research Methodology (in general). Describe the variable or variables that are being analyzed. Identify the statistical test you will select to analyze these data and explain why you chose this test. Summarize your statistical alternative hypothesis. This section includes the following sub-sections:
a)Describe the Dataset
Example: The primary source of data will be HOSPITAL COMPARE MEDICARE DATA (citation). This dataset provides information on hospital characteristics, such as: Number of staffed beds, ownership, system membership, staffing by nurses and non-clinical staff, teaching status, percentage of discharge for Medicare and Medicaid patients, and information regarding the availability of specialty and high-tech services, as well as Electronic Medical Record (EMR) use (Describe dataset in 2-3 lines, Google the dataset and find the related website to find more information about the data).
Also, describe the sample size; for example, “The writer is using Medicare data-2013, this data includes 3000 obs. for all of the hospitals in the US.”
b)Describe Variables
Next, review the database you selected and select a variable or variables that are a “best-fit.” That is, choose a variable that quantitatively measures the concept or concepts articulated in your research question or hypothesis.
Return to your previously stated Research Question or Hypothesis and evaluate it considering the variables you have selected. (See the sample Table 1).
Table 1. List of variables used for the analysis
Variable
Definition
Description
of code
Source
Year
Total Hospital Beds
Total facility beds set up and staffed
at the end of the reporting period
Numeric
MN Data
2013
….
…..
Source: UMGC, 2019
***Just in time information:
To cite a dataset, you can go with two approaches:
First, look at the note in the dataset for example;
Medicare National Data by County. (2012). Dartmouth Atlas of Health Care, A
Second, use the online citation, for example:
Zare, H., (2019, May). MN Hospital Report Data. Data posted in University of Maryland University College HMGT 400 online classroom, archived at: http://campus.umgc.edu
See two examples describing the variables from Minnesota Data:
Table 2. Definition of variables used in the analysis
Variable
Definition
Description
of code
Source
Year
hospital_beds
Total facility beds set up and staffed
at the end of the reporting period
Numeric
MN data
2013
year
FY
Categorical
MN data
2013
Source: UMGC, 2019
c)Describe the Research Method for Analysis
First, describe the research method as a general (e.g., this is a quantitative method and then explain about this method in about one paragraph. If you have this part in the introduction, you do not need to add here).
Then, explain the statistical method you plan to use for your analysis (Refer to content in week 3 on Biostatistics for information on various statistical methods you can choose from).
Example:
Hypothesis: AZ hospitals are more likely to have lower readmission rates for PN compared to CA.
Research Method: To determine whether Arizona hospitals are more likely to have lower readmission rate than California, we will use a t-test, to determine whether differences across hospital types are statistically significant (You can change the test depends on your analysis).
d)Describe statistical package
Add one paragraph for the statistical package, e.g., Excel or RStudio.
5. Results
Discuss your findings considering the following tips:
▪ Why you needed to see the distribution of data before any analysis (e.g., check for outliers, finding the best fit test; for example, if the data had not a normal distribution, you can’t use the parametric test, etc., so just add 1 or 2 sentences).
▪ Did you eliminate outliers? (Please write 1 or 2 sentences, if applicable).
▪ How many observations do you have in your database and how many for selected variables, report % of missing.
▪ When you are finished with this, go for the next steps:
Present the results of your statistical analysis; include any relevant statistical information (summary tables, including N, mean, std. dev.). Make sure to completely and correctly name all your columns and rows, tables and variables. For this part you could have at least 1-2 tables and 1-2 figures (depending on your variables bar-chart, pi-chart, or scatter-plot), you can use a table like this:
Table 3. Descriptive analysis to compare % of BL in Medicare beneficiary, MD vs. VA- 2013
Variable
Obs.
Mean
SD
P-value
Per of Lipid in MD
24
83.20
2.32
0.4064
Per of Lipid in VA
124
82.69
4.41
Source: UMGC, 2019
When you have tables and plots ready, think about your finding and state the statistical conclusion. That is, do the results present evidence in favor or the null hypothesis or evidence that contradicts the null hypothesis?
6.Conclusion and Discussion
Review your research questions or hypothesis.
How has your analysis informed this question or hypothesis? Present your conclusion(s) from the results (presented above) and discuss the meaning of this conclusion(s) considering the research question or hypothesis presented in your introduction.
At the end of this section, add one or two sentences and discuss the limitations (including biases) associated with this analysis and any other statements you think are important in understanding the results of this analysis.
References
Include a reference page listing the bibliographic information for all sources cited in this report. This information should be consistent with the requirements specified in the American Psychological Association (APA) format and style guide. Minnesota Hospitals Admissions by Care Unit of the Hospital, Fiscal Year 2012
Data current as of 2-6-2014
Hospital Name
Affiliation
City
Tyler Healthcare Center, Inc.
Avera Health
Tyler
Abbott Northwestern Hospital
Allina Hospitals and Clinics
Minneapolis
Essentia Health Ada
Essentia Community Hospitals and
Ada
Clinics (ECHC)
Riverwood HealthCare Center
No Affiliation
Aitkin
Albany Area Hospital and Medical Center
Catholic Health Initiatives
Albany
Appleton Municipal Hospital and Nursing Home
No Affiliation
Appleton
Sibley Medical Center
No Affiliation
Arlington
Bethesda LTACH
HealthEast Care System
St. Paul
Buffalo Hospital
Allina Hospitals and Clinics
Buffalo
Cambridge Medical Center
Allina Hospitals and Clinics
Cambridge
Sanford Canby Medical Center
Sanford Health
Canby
Mayo Clinic Health System – Cannon Falls
Mayo Clinic
Cannon Falls
Chippewa County-Montevideo Hospital
No Affiliation
Montevideo
Sanford Bagley Medical Center
Sanford Health
Bagley
Sanford Hospital Luverne
Sanford Health
Luverne
River’s Edge Hospital & Clinic
No Affiliation
St. Peter
Cloquet Memorial Hospital Association
No Affiliation
Cloquet
Deer River HealthCare Center
No Affiliation
Deer River
Winona Health Services
No Affiliation
Winona
Mille Lacs Health System
No Affiliation
Onamia
Cook Hospital & C&NC
No Affiliation
Cook
Cook County North Shore Hospital
No Affiliation
Grand Marais
Cuyuna Regional Medical Center
No Affiliation
Crosby
Douglas County Hospital
No Affiliation
Alexandria
Sanford Westbrook Medical Center
Sanford Health
Westbrook
Ely-Bloomenson Community Hospital & Nursing Home
No Affiliation
Ely
Mayo Clinic Health System – Fairmont
Mayo Clinic
Fairmont
Fairview Northland Regional Hospital
Fairview Health Services
Princeton
Fairview Ridges Hospital
Fairview Health Services
Burnsville
Fairview Southdale Hospital
Fairview Health Services
Edina
Rainy Lake Medical Center
Quorum Health Resources
International Falls
First Care Medical Services
Essentia Community Hospitals and
Fosston
Clinics (ECHC)
Gillette Children’s Specialty Healthcare
No Affiliation
St. Paul
Glacial Ridge Health System
No Affiliation
Glenwood
Glencoe Regional Health Services
Park Nicollet Health Services
Glencoe
Granite Falls Municipal Hospital & Manor
No Affiliation
Granite Falls
Prairie Ridge Hospital & Health Services
No Affiliation
Elbow Lake
Owatonna Hospital
Allina Hospitals and Clinics
Owatonna
Hendricks Community Hospital Association
No Affiliation
Hendricks
Hennepin County Medical Center
No Affiliation
Minneapolis
Essentia Health Holy Trinity Hospital
Essentia Community Hospitals and
Graceville
Clinics (ECHC)
Hutchinson Area Health Care
Allina Hospitals and Clinics
Hutchinson
Mayo Clinic Health System – Mankato
Mayo Clinic
Mankato
Grand Itasca Clinic and Hospital
No Affiliation
Grand Rapids
Sanford Jackson Medical Center
Sanford Health
Jackson
Johnson Memorial Health Services
No Affiliation
Dawson
FirstLight Health System
No Affiliation
Mora
Kittson Memorial Healthcare Center
No Affiliation
Hallock
Mayo Clinic Health System – Lake City
Mayo Clinic
Lake City
Lake Region Healthcare Corporation
No Affiliation
Fergus Falls
Lake View Memorial Hospital
St. Luke’s Hospital, Duluth
Two Harbors
Lakeview Memorial Hospital
HealthPartners, Inc.
Stillwater
CentraCare Health System – Long Prairie
CentraCare Health System
Long Prairie
Madelia Community Hospital
No Affiliation
Madelia
Madison Hospital
No Affiliation
Madison
Mahnomen Health Center
Sanford Health
Mahnomen
Meeker Memorial Hospital
No Affiliation
Litchfield
Melrose Area Hospital – CentraCare
CentraCare Health System
Melrose
Mercy Hospital
No Affiliation
Moose Lake
Mercy Hospital
Allina Hospitals and Clinics
Coon Rapids
Fairview University Medical Center – Mesabi
Fairview Health Services
Hibbing
Park Nicollet Methodist Hospital
Park Nicollet Health Services
St. Louis Park
SMDC Medical Center
Essentia Community Hospitals and
Duluth
Clinics (ECHC)
Children’s Health Care dba Children’s Hospitals and Clinics
Children’s
of Minnesota
Hospitals and Clinics Minneapolis
Minnesota Valley Health Center
Essentia Community Hospitals and
LeClinics
Sueur(ECHC)
New River Medical Center
No Affiliation
Monticello
Redwood Area Hospital
No Affiliation
Redwood Falls
Murray County Memorial Hospital
Sanford Health
Slayton
Mayo Clinic Health System – Albert Lea
Mayo Clinic
Albert Lea
Sanford Bemidji Medical Center
Sanford Health
Bemidji
North Memorial Medical Center
North Memorial Health Care
Robbinsdale
Bigfork Valley Hospital
No Affiliation
Bigfork
Northfield Hospital & Clinics
No Affiliation
Northfield
Sanford Medical Center Thief River Falls
Sanford Health
Thief River Falls
Olmsted Medical Center
No Affiliation
Rochester
Ortonville Area Health Services
Sanford Health
Ortonville
Paynesville Area Health Care System
Paynesville Area Health Care System
Paynesville
Perham Health
Sanford Health
Perham
Pipestone County Medical Center
Avera Health
Pipestone
Mayo Clinic Health System – New Prague
Mayo Clinic
New Prague
Regina Medical Center
No Affiliation
Hastings
Renville County Hospital
No Affiliation
Olivia
District One Hospital
No Affiliation
Faribault
http://www.health.state.mn.us/divs/hpsc/dap/hccis/index.html
health.hccis@state.mn.us
Acute Care
County
Lincoln
Hennepin
Norman
Aitkin
Stearns
Swift
Sibley
Ramsey
Wright
Isanti
Yellow Medicine
Goodhue
Chippewa
Clearwater
Rock
Nicollet
Carlton
Itasca
Winona
Mille Lacs
St. Louis
Cook
Crow Wing
Douglas
Cottonwood
St. Louis
Martin
Sherburne
Dakota
Hennepin
Koochiching
Polk
Ramsey
Pope
Mcleod
Yellow Medicine
Grant
Steele
Lincoln
Hennepin
Big Stone
Mcleod
Blue Earth
Itasca
Jackson
Lac Qui Parle
Kanabec
Kittson
Goodhue
Otter Tail
Lake
Washington
Todd
Watonwan
Lac Qui Parle
Mahnomen
Meeker
Stearns
Carlton
Anoka
St. Louis
Hennepin
St. Louis
Hennepin
Le Sueur
Wright
Redwood
Murray
Freeborn
Beltrami
Hennepin
Itasca
Dakota
Pennington
Olmsted
Big Stone
Stearns
Otter Tail
Pipestone
Scott
Dakota
Renville
Rice
Report Year
End Date
2/29/2012
12/31/2012
6/30/2012
9/30/2012
6/30/2012
9/30/2012
9/30/2012
8/31/2012
12/31/2012
12/31/2012
6/30/2012
12/31/2012
12/31/2012
6/30/2012
6/30/2012
12/31/2012
9/30/2012
8/31/2012
9/30/2012
9/30/2012
12/31/2012
12/31/2012
3/31/2012
12/31/2012
6/30/2012
9/30/2012
12/31/2012
12/31/2012
12/31/2012
12/31/2012
12/31/2012
6/30/2012
12/31/2012
9/30/2012
12/31/2012
12/31/2012
12/31/2012
12/31/2012
6/30/2012
12/31/2012
6/30/2012
12/31/2012
12/31/2012
12/31/2012
6/30/2012
9/30/2012
12/31/2012
9/30/2012
12/31/2012
9/30/2012
12/31/2012
12/31/2012
6/30/2012
5/31/2012
9/30/2012
12/31/2012
12/31/2012
6/30/2012
9/30/2012
12/31/2012
12/31/2012
12/31/2012
6/30/2012
12/31/2012
6/30/2012
9/30/2012
12/31/2012
12/31/2012
12/31/2012
6/30/2012
12/31/2012
12/31/2012
12/31/2012
6/30/2012
12/31/2012
9/30/2012
9/30/2012
9/30/2012
6/30/2012
12/31/2012
9/30/2012
12/31/2012
12/31/2012
CAH
Yes
No
Yes
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
No
Yes
Yes
No
No
No
No
Yes
Yes
No
Yes
Yes
Yes
Yes
No
Yes
No
Yes
No
No
No
Yes
Yes
Yes
Yes
Yes
No
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
No
No
Yes
Yes
Yes
Yes
No
No
No
Yes
No
Yes
No
Yes
Yes
Yes
Yes
Yes
No
Yes
No
Licensed Licensed
Available
Beds
Bassinets Beds
20
1
20
952
36
644
14
0
14
25
6
25
17
2
17
15
1
15
20
0
14
254
0
126
65
18
44
86
15
86
25
4
25
21
4
21
30
6
25
25
4
25
28
5
25
17
0
17
36
6
25
20
6
20
99
14
50
28
3
28
14
2
14
16
2
16
42
7
25
127
14
91
8
0
8
25
3
22
57
16
56
54
10
40
150
48
143
390
45
305
49
11
25
43
7
22
60
0
60
34
4
19
49
8
25
30
3
25
20
2
20
43
16
43
24
0
19
894
65
442
15
0
15
66
6
57
272
26
184
64
10
64
20
0
14
20
4
20
49
8
25
15
0
15
18
5
18
108
10
108
25
1
17
97
15
68
34
10
25
25
7
25
12
2
12
18
0
10
35
4
35
28
6
25
31
7
25
271
38
255
175
16
81
426
50
365
165
0
148
279
171
279
24
0
14
39
12
35
25
6
25
25
2
25
77
12
67
118
12
118
518
42
398
20
4
20
37
12
37
99
10
35
61
16
37
25
4
25
30
6
30
25
3
25
44
12
44
49
6
25
57
12
39
35
6
25
99
16
42
Neonatal
(exclude
Med/Surg Cardiac
Chemical
Mental Health Neurology routine
Obstetrics Orthopedic Rehabilitatio
Admission Admission Dependency (Psychiatric) Admission nursery)
Admission Admission n
s
s
Admissions Admissions
s
Admissions
s
s
Admissions
10
8
1
8.906
7.018
195
3.224
2.433
2.023
4.516
6.855
701
33
6
3
2
408
135
12
6
24
14
62
87
28
80
16
6
1
28
5
42
12
6
1
9
82
5
5
1
6
13
165
161
1.093
315
34
22
78
176
560
328
1.386
337
417
558
141
144
541
267
121
13
1
12
4
15
23
146
44
1
3
15
56
377
118
7
6
43
22
98
100
134
59
4
3
17
15
5
144
37
7
2
12
14
62
7
43
157
45
2
20
1
16
100
377
60
8
2
24
2
69
101
252
78
4
14
12
91
42
33
944
294
51
237
89
43
269
117
320
61
3
7
24
8
49
40
174
82
2
36
27
54
83
17
2
2
5
5
8
199
71
3
6
11
10
60
46
1.496
257
25
13
124
220
644
1.033
18
6
2
3
158
36
8
5
17
3
25
31
9
973
340
6
3
66
35
302
242
1
823
247
13
7
67
96
551
248
4.030
862
60
23
308
486
2.737
1.663
5.352
2.750
112
872
1.041
533
3.242
2.910
292
80
7
2
23
13
85
23
70
33
8
12
35
20
301
7
1
33
584
7
1.049
96
303
93
5
2
30
1
48
24
593
100
7
3
38
45
204
91
260
63
2
3
33
5
43
35
125
49
5
3
14
14
997
234
19
415
59
138
562
341
28
17
5
8
13
12
7.737
1.668
404
2.243
1.599
1.197
2.720
1.654
257
34
8
2
2
844
199
27
678
63
99
359
233
3.556
1.467
114
495
523
394
1.676
1.515
496
150
10
2
66
48
183
74
42
56
11
12
5
7
112
25
7
7
17
558
105
10
7
51
30
104
107
45
8
2
9
111
35
1
1
10
5
61
48
837
278
22
260
97
39
259
248
130
106
30
14
19
9
2
656
117
20
3
68
89
535
1.391
108
9
1
1
3
14
67
21
52
22
7
7
15
3
142
56
1
8
12
9
9
54
13
1
2
2
1
338
135
14
45
160
19
157
57
114
32
2
13
2
41
10
329
61
4
3
33
19
99
95
17
6.748
3.476
303
1.305
1.356
831
2.203
2.091
1.285
273
89
1.036
152
93
380
109
7.684
3.103
185
96
1.194
1.053
3.809
2.870
248
375
47
22
1.251
15
11
18
106
161
3.884
433
5
69
569
793
4
192
21
7
1
2
6
517
86
11
7
33
142
437
89
85
231
81
11
3
23
19
95
10
7
179
56
1
5
13
54
12
1.083
283
23
16
78
94
552
444
1.372
359
22
61
234
287
845
423
205
8.730
3.512
222
1.197
1.956
583
1.820
3.356
184
137
38
3
1
12
117
4
750
204
5
7
45
113
506
274
1
298
75
7
217
25
39
161
54
684
110
10
4
21
208
992
317
164
59
1
27
3
48
16
141
26
1
3
15
7
69
39
227
88
2
3
27
4
67
16
1
194
41
4
2
19
6
75
84
232
62
6
2
27
15
100
64
1
588
117
42
8
35
57
259
212
15
233
120
5
5
30
3
19
28
9
748
180
11
11
58
107
445
207
1 of 5
Non-Acute Care
Other
Acute Care
Specialty
Admission
s
4
3.780
6
83
15
13
13
892
276
336
24
40
77
32
34
24
85
32
183
88
48
18
31
458
38
219
186
1.102
2.089
37
16
158
47
99
54
19
314
9
1.916
2
166
1.152
131
11
31
122
9
23
262
10
281
20
7
25
11
96
27
115
2.226
241
2.487
287
1.225
6
99
59
41
290
349
2.519
23
224
60
219
45
33
59
37
51
143
52
144
Total
Billing
Acute Care
Admission
s
23
39.651
50
859
151
83
125
1.218
2.882
4.127
213
305
848
269
362
365
728
558
2.227
600
423
140
437
4.270
29
330
2.187
2.238
11.271
18.901
562
194
2.236
553
1.180
498
229
3.079
92
21.395
48
2.668
10.892
1.202
102
199
1.094
73
295
2.432
190
3.160
244
113
262
84
1.021
241
775
20.539
3.658
22.729
2.293
7.174
43
1.506
539
361
2.863
4.157
24.079
335
2.129
936
2.565
363
334
494
462
560
1.476
504
1.911
balancing
account
(discharge
data to amt
provided by
hospital in
4320)
87
-1.521
25
231
86
30
-24
0
-120
-340
89
37
-55
-72
154
-116
220
-103
556
269
-129
14
1.676
-528
45
19
-212
-383
454
-360
-82
241
88
159
-383
-92
-64
-311
18
-813
25
-407
-222
998
10
3
37
84
-16
618
-58
559
130
-8
-43
34
3
227
20
701
-405
-903
1.864
5.411
26
-255
-40
-45
-598
1.508
-2.345
20
-426
1.308
-660
-26
77
331
2
196
233
-166
-68
Total Acute
Care
Admissions
(ties to 4320)
110
38.130
75
1.090
237
113
101
1.218
2.762
3.787
302
342
793
197
516
249
948
455
2.783
869
294
154
2.113
3.742
74
349
1.975
1.855
11.725
18.541
480
435
2.324
712
797
406
165
2.768
110
20.582
73
2.261
10.670
2.200
112
202
1.131
157
279
3.050
132
3.719
374
105
219
118
1.024
468
795
21.240
3.253
21.826
4.157
12.585
69
1.251
499
316
2.265
5.665
21.734
355
1.703
2.244
1.905
337
411
825
464
756
1.709
338
1.843
Routine
Nursery
Swing Bed
Admission Admissions
s (Births)
(ties to 4324)
20
4.264
20
63
32
45
42
52
32
893
459
37
113
113
61
87
347
52
9
278
590
30
235
524
2.360
2.860
57
72
65
201
38
105
123
105
23
89
118
42
32
71
52
66
16
86
68
Total
Total NonSubacute/
Acute and
Transitional Other Non- Nursery
Care
Acute Care Care
Admissions Admission Admission
(ties to 4327) s
s
4
24
4.264
20
95
9
96
7
59
8
40
893
459
142
123
233
23
202
131
103
123
347
126
52
75
278
590
16
120
338
524
2.360
2.860
107
218
15
13
4
3
4
35
50
146
164
75
123
29
1
8
51
11
229
277
169
29
525
62
2.357
20
259
1.275
329
28
95
165
18
232
319
83
509
171
74
81
42
183
182
209
2.038
336
3.068
525
2.357
20
259
1.275
329
10
125
71
319
509
94
7
5
131
90
122
2.038
336
3.068
192
84
28
80
23
18
97
5
17
64
76
7
56
67
71
31
51
89
87
21
47
32
58
77
3
48
21
7
5
11
1
3
414
987
1.173
511
293
822
73
78
125
66
157
325
32
360
73
62
37
54
105
11
88
5
1
1
50
224
142
77
414
987
1.173
55
532
293
822
146
141
163
120
273
325
125
360
Total Acute
and NonAcute Care
Hospital
Admissions
(4320+7180)
134
42.394
95
1.185
333
172
141
1.218
3.655
4.246
444
465
1.026
220
718
380
1.051
578
3.130
995
346
229
2.391
4.332
90
469
2.313
2.379
14.085
21.401
587
653
2.324
941
1.074
575
194
3.293
172
22.939
93
2.520
11.945
2.529
140
297
1.296
175
511
3.369
215
4.228
545
179
300
160
1.207
650
1.004
23.278
3.589
24.894
4.157
12.585
119
1.475
641
393
2.679
6.652
22.907
410
2.235
2.537
2.727
483
552
988
584
1.029
2.034
463
2.203
Health Care Cost Information System (HCCIS)
Minnesota Department of Health
Minnesota Hospitals Admissions by Care Unit of the Hospital, Fiscal Year 2012
Data current as of 2-6-2014
Report Year
Hospital Name
Affiliation
City
County
End Date
Rice Memorial Hospital
No Affiliation
Willmar
Kandiyohi
12/31/2012
Riverview Healthcare Association
No Affiliation
Crookston
Polk
9/30/2012
Mayo Clinic Methodist Hospital
Mayo Clinic
Rochester
Olmsted
12/31/2012
LifeCare Medical Center
No Affiliation
Roseau
Roseau
9/30/2012
Pine Medical Center
Essentia Community Hospitals and
Sandstone
Clinics (ECHC)
Pine
6/30/2012
New Ulm Medical Center
Allina Hospitals and Clinics
New Ulm
Brown
12/31/2012
Sleepy Eye Medical Center
No Affiliation
Sleepy Eye
Brown
12/31/2012
Mayo Clinic Health System – Springfield
Mayo Clinic
Springfield
Brown
12/31/2012
St. Cloud Hospital
CentraCare Health System
St. Cloud
Stearns
6/30/2012
Saint Elizabeth’s Medical Center
Ministry Health Care
Wabasha
Wabasha
9/30/2012
St. Francis Medical Center
Catholic Health Initiatives
Breckenridge
Wilkin
6/30/2012
St. Francis Regional Medical Center
Allina Hospitals and Clinics; Park Nicollet
Shakopee
Health Services Scott
12/31/2012
St. Gabriel’s Hospital
Catholic Health Initiatives
Little Falls
Morrison
6/30/2012
Mayo Clinic Health System – Red Wing
Mayo Clinic
Red Wing
Goodhue
12/31/2012
St. Joseph’s Area Health Services, Inc.
Catholic Health Initiatives
Park Rapids
Hubbard
6/30/2012
St. Joseph’s Hospital
HealthEast Care System
St. Paul
Ramsey
8/31/2012
St. Joseph’s Medical Center
Essentia Community Hospitals and
Brainerd
Clinics (ECHC)
Crow Wing
6/30/2012
St. Luke’s Hospital
St. Luke’s Hospital, Duluth
Duluth
St. Louis
12/31/2012
Saint Marys Hospital
Mayo Clinic
Rochester
Olmsted
12/31/2012
St. Mary’s Regional Health Center
Essentia Community Hospitals and
Detroit
Clinics
Lakes
(ECHC)
Becker
6/30/2012
St. Mary’s Medical Center
Essentia Community Hospitals and
Duluth
Clinics (ECHC)
St. Louis
6/30/2012
St. Michael’s Hospital & Nursing Home
No Affiliation
Sauk Centre
Stearns
12/31/2012
Mayo Clinic Health System-Austin
Mayo Clinic
Austin
Mower
12/31/2012
Regions Hospital
HealthPartners, Inc.
St. Paul
Ramsey
12/31/2012
Stevens Community Medical Center
No Affiliation
Morris
Stevens
12/31/2012
Swift County-Benson Hospital
Rice Memorial Hospital
Benson
Swift
12/31/2012
Sanford Tracy Medical Center
Sanford Health
Tracy
Lyon
6/30/2012
Tri-County Hospital
No Affiliation
Wadena
Wadena
12/31/2012
LakeWood Health Center
Catholic Health Initiatives
Baudette
Lake Of The Woods
6/30/2012
Lakewood Health System
No Affiliation
Staples
Wadena
12/31/2012
United Hospital District
No Affiliation
Blue Earth
Faribault
12/31/2012
United Hospital
Allina Hospitals and Clinics
St. Paul
Ramsey
12/31/2012
Unity Hospital
Allina Hospitals and Clinics
Fridley
Anoka
12/31/2012
Virginia Regional Medical Center
No Affiliation
Virginia
St. Louis
12/31/2012
Ridgeview Medical Center
No Affiliation
Waconia
Carver
12/31/2012
North Valley Health Center
No Affiliation
Warren
Marshall
12/31/2012
Mayo Clinic Health System – Waseca
Mayo Clinic
Waseca
Waseca
12/31/2012
Mayo Clinic Health System – St. James
Mayo Clinic
St. James
Watonwan
12/31/2012
Avera Marshall Regional Medical Center
Avera Health
Marshall
Lyon
6/30/2012
Sanford Medical Center Wheaton
Sanford Health
Wheaton
Traverse
6/30/2012
Northern Pines Medical Center
Essentia Community Hospitals and
Aurora
Clinics (ECHC)
St. Louis
6/30/2012
Windom Area Hospital
Sanford Health
Windom
Cottonwood
4/30/2012
Sanford Worthington Medical Center
Sanford Health
Worthington
Nobles
6/30/2012
St. John’s Hospital
HealthEast Care System
Maplewood
Ramsey
8/31/2012
Regency Hospital of Minneapolis
Select Medical Corporation
Golden Valley
Hennepin
12/31/2012
Phillips Eye Institute
Allina Hospitals and Clinics
Minneapolis
Hennepin
12/31/2012
University of Minnesota Medical Center – Fairview
Fairview Health Services
Minneapolis
Hennepin
12/31/2012
Fairview Lakes Regional Medical Center
Fairview Health Services
Wyoming
Chisago
12/31/2012
Woodwinds Health Campus
HealthEast Care System
Woodbury
Washington
8/31/2012
Maple Grove Hospital
Fairview Health Services; North Memorial
Maple Grove
Health Care
Hennepin
11/30/2012
Anoka Metro Regional Treatment Center
Dept of Human Services, State ofAnoka
MN
Anoka
6/30/2012
Shriners Hospitals for Children
Shriners Hospitals for Children Minneapolis
Hennepin
12/31/2012
Veterans Affairs Medical Center
U.S. Department of Veterans Affairs
Minneapolis
Hennepin
9/30/2012
Veterans Affairs Health Care System
U.S. Department of Veterans Affairs
St. Cloud
Stearns
9/30/2012
Community Behavioral Health Hospital-Alexandria Dept of Human Services, State ofAlexandria
MN
Douglas
6/30/2012
Community Behavioral Health Hospital – Annandale Dept of Human Services, State ofAnnandale
MN
Wright
6/30/2012
Community Behavioral Health Hospital – Fergus FallsDept of Human Services, State ofFergus
MN
Falls
Otter Tail
6/30/2012
Community Behavioral Health Hospital – Rochester Dept of Human Services, State ofRochester
MN
Olmsted
6/30/2012
Community Behavioral Health Hospital-St. Peter
Dept of Human Services, State ofSt.
MNPeter
Nicollet
6/30/2012
Community Behavioral Health Hospital – Baxter
Dept of Human Services, State ofBaxter
MN
Crow Wing
6/30/2012
Community Behavioral Health Hospital – Bemidji
Dept of Human Services, State ofBemidji
MN
Beltrami
6/30/2012
PrairieCare
No Affiliation
Maple Grove
Hennepin
12/31/2012
Acute Care
CAH
No
Yes
No
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
No
Yes
No
Yes
No
No
No
No
No
No
Yes
No
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
No
No
No
No
No
No
No
No
N
