CHOOSEN TOPIC:
Comparing the number of MRI Procedures between Clinics and Hospitals (all states)
Assignment # 2: Quantitative Analysis
Target:
· Analyze health care data using statistics to increase operational effectiveness and efficiency.
For this assignment, students will be given data from quantitative analysis and will be asked to analyze it using Excel, RStuido (BONUS points)
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).
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.
3.Research Question or Research Hypothesis
What is the Research Question or Research Hypothesis?
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
Also, describe the sample size
)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.
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
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 co
ectly 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),
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.
HCCIS Diagnostic Imaging Data
Data
HCCIS ID Facility Type Name City State MRI Procedures PET Procedures PET/CT Procedures CT Procedures SPECT/CT Procedures SPECT Procedures
1 Hospital Tyler Healthcare Center, Inc. Tyler MN 128 393
2 Hospital A
ott Northwestern Hospital Minneapolis MN 19,791 800 1,463 35,517 2,949
3 Hospital Essentia Health Ada Ada MN 44 240
4 Hospital Riverwood HealthCare Center Aitkin MN 958 2,832 56
5 Hospital Albany Area Hospital and Medical Center Albany MN 368 636 59
6 Hospital Appleton Municipal Hospital and Nursing Home Appleton MN 82 273
7 Hospital Sibley Medical Center Arlington MN 153 776 24
10 Hospital Bethesda LTACH St. Paul MN 169 940
11 Hospital Buffalo Hospital Buffalo MN 3,133 53 7,347
13 Hospital Cam
idge Medical Center Cam
idge MN 3,535 296 7,301
14 Hospital Sanford Canby Medical Center Canby MN 198 599 99
15 Hospital Mayo Clinic Health System - Cannon Falls Cannon Falls MN 232 1,012
17 Hospital Chippewa County-Montevideo Hospital Montevideo MN 466 2,057
19 Hospital Sanford Bagley Medical Center Bagley MN 285 843 206
21 Hospital Sanford Hospital Luverne Luverne MN 295 946 133
22 Hospital River's Edge Hospital & Clinic St. Peter MN 173 1,245
24 Hospital Cloquet Memorial Hospital Association Cloquet MN 1,013 3,549 14
25 Hospital Deer River HealthCare Center Deer River MN 557 1,131 136
27 Hospital Winona Health Services Winona MN 1,274 4,672 558
28 Hospital Mille Lacs Health System Onamia MN 661 1,829 47
29 Hospital Cook Hospital & C&NC Cook MN 101 925 11
30 Hospital Cook County North Shore Hospital Grand Marais MN 128 399
31 Hospital Cuyuna Regional Medical Center Crosby MN 1,715 105 4,571
34 Hospital Douglas County Hospital Alexandria MN 666 90 6,016 34
35 Hospital Sanford West
ook Medical Center West
ook MN 97 221 14
37 Hospital Ely-Bloomenson Community Hospital & Nursing Home Ely MN 275 1,025 107
39 Hospital Mayo Clinic Health System - Fairmont Fairmont MN 1,360 4,651
41 Hospital Fairview Northland Regional Hospital Princeton MN 2,316 131 5,195 527
42 Hospital Fairview Ridges Hospital Burnsville MN 7,368 29,460 2,284
44 Hospital Fairview Southdale Hospital Edina MN 7,110 253 27,517 967 3,668
45 Hospital Rainy Lake Medical Center International Falls MN 567 1,702 88
46 Hospital First Care Medical Services Fosston MN 299 660 184
49 Hospital Gillette Children's Specialty Healthcare St. Paul MN 3,089 1,101
50 Hospital Glacial Ridge Health System Glenwood MN 410 5 1,179
51 Hospital Glencoe Regional Health Services Glencoe MN 858 1,592 263
53 Hospital Granite Falls Municipal Hospital & Manor Granite Falls MN 335 914 110
54 Hospital Prairie Ridge Hospital & Health Services Elbow Lake MN 250 467 109
57 Hospital Owatonna Hospital Owatonna MN 4,766
58 Hospital Hendricks Community Hospital Association Hendricks MN 75 342
59 Hospital Hennepin County Medical Center Minneapolis MN 7,857 421 27,903 383
61 Hospital Essentia Health - Graceville Graceville MN 72 265 11
62 Hospital Hutchinson Health Hutchinson MN 1,982 168 3,979 391
63 Hospital Mayo Clinic Health System - Mankato Mankato MN 3,472 15,306
64 Hospital Grand Itasca Clinic and Hospital Grand Rapids MN 2,296 176 4,400 463
65 Hospital Sanford Jackson Medical Center Jackson MN 91 575 65
66 Hospital Johnson Memorial Health Services Dawson MN 136 380
67 Hospital FirstLight Health System Mora MN 1,170 3 3,172 316
69 Hospital Kittson Memorial Healthcare Center Hallock MN 174 181
70 Hospital Mayo Clinic Health System - Lake City Lake City MN 270 1,039
71 Hospital Lake Region Healthcare Corporation Fergus Falls MN 1,665 220 3,834 296
72 Hospital Lake View Memorial Hospital Two Ha
ors MN 133 901
74 Hospital Lakeview Memorial Hospital Stillwater MN 2,975 183 6,215
76 Hospital CentraCare Health System - Long Prairie Long Prairie MN 548 1,338
77 Hospital Madelia Community Hospital Madelia MN 59 292
78 Hospital Madison Hospital Madison MN 133 500
79 Hospital Mahnomen Health Center Mahnomen MN 177 1,010
80 Hospital Meeker Memorial Hospital Litchfield MN 671 8 1,536 114
81 Hospital Melrose Area Hospital - CentraCare Melrose MN 513 1,320
83 Hospital Mercy Hospital Moose Lake MN 586 1,528 67
84 Hospital Mercy Hospital Coon Rapids MN 7,160 26,046 3,334
85 Hospital Fairview University Medical Center - Mesabi Hi
ing MN 2,543 330 6,365 700
86 Hospital Park Nicollet Methodist Hospital St. Louis Park MN 16,692 1,988 36,385 3,449
90 Hospital SMDC Medical Center Duluth MN 4,833 585 7,004
91 Hospital Children's Health Care dba Children's Hospitals and Clinics of Minnesota Minneapolis MN 7,257 6,149 5
92 Hospital Minnesota Valley Health Center Le Sueur MN 123 471 16
94 Hospital New River Medical Center Monticello MN 1,008 42 3,056 90
98 Hospital Redwood Area Hospital Redwood Falls MN 512 1,465
99 Hospital Mu
ay County Memorial Hospital Slayton MN 350 1,177 240
100 Hospital Mayo Clinic Health System - Albert Lea Albert Lea MN 1,821 7,492 25
102 Hospital Sanford Bemidji Medical Center Bemidji MN 3,491 190 10,299 2,045
103 Hospital North Memorial Medical Center Ro
insdale MN 9,202 1,053 30,732
104 Hospital Bigfork Valley Hospital Bigfork MN 271 484 81
105 Hospital Northfield Hospital & Clinics Northfield MN 1,406 50 4,830 1,371
106 Hospital Sanford Medical Center Thief River Falls Thief River Falls MN 1,092 2,621 542
107 Hospital Olmsted Medical Center Rochester MN 4,615 7,442
108 Hospital Ortonville Area Health Services Ortonville MN 390 7 734
110 Hospital Paynesville Area Health Care System Paynesville MN 561 37 1,732 137
112 Hospital Perham Health Perham MN 885 2,053
113 Hospital Pipestone County Medical Center Pipestone MN 582 1,457
114 Hospital Mayo Clinic Health System - New Prague New Prague MN 748 26 2,109 100
115 Hospital Regina Medical Center Hastings MN 1,660 4,881 385
116 Hospital Renville County Hospital Olivia MN 259 765
117 Hospital District One Hospital Faribault MN 2,142 49 5,032 2
118 Hospital Rice Memorial Hospital Willmar MN 1,167 130 4,033 712
119 Hospital Riverview Healthcare Association Crookston MN 1,089 2,037 450
120 Hospital Mayo Clinic Methodist Hospital Rochester MN 940 388 11,394 3,980 2,209
121 Hospital LifeCare Medical Center Roseau MN 682 20 1,803 339
124 Hospital Essentia Health - Sandstone Sandstone MN 296 1,275
127 Hospital New Ulm Medical Center New Ulm MN 1,749 161 3,612 410
129 Hospital Sleepy Eye Medical Center Sleepy Eye MN 132 703 14
130 Hospital Mayo Clinic Health System - Springfield Springfield MN 226 764
132 Hospital St. Cloud Hospital St. Cloud MN 9,636 1,507 34,574 123 2,808
133 Hospital Saint Elizabeth's Medical Center Wabasha MN 290 1,032
134 Hospital St. Francis Medical Center Breckenridge MN 660 1,584 39
135 Hospital St. Francis Regional Medical Center Shakopee MN 4,569 178 10,493 16,675
136 Hospital St. Ga
iel's Hospital Little Falls MN 2,131 3,271 244
138 Hospital Mayo Clinic Health System - Red Wing Red Wing MN 1,928 100 5,269 114
140 Hospital St. Joseph's Area Health Services, Inc. Park Rapids MN 1,146 2,775 357
141 Hospital St. Joseph's Hospital St. Paul MN 4,228 12,276 3,412
142 Hospital St. Joseph's Medical Center Brainerd MN 4,280 388 9,650 590
143 Hospital St. Luke's Hospital Duluth MN 259 14,996 948
145 Hospital Saint Marys Hospital Rochester MN 6,856 42,718 97 1,060
147 Hospital St. Mary's Regional Health Center Detroit Lakes MN 1,314 4,167
148 Hospital St. Mary's Medical Center Duluth MN 6,599 16,708
149 Hospital Centracare Health System - Sauk Centre Sauk Centre MN 463 929 100
150 Hospital Mayo Clinic Health System-Austin Austin MN 1,504 4,704 419
151 Hospital Regions Hospital St. Paul MN 16,916 781 35,024 4,152
152 Hospital Stevens Community Medical Center Mo
is MN 742 26 1,954 50
153 Hospital Swift County-Benson Hospital Benson MN 199 744
156 Hospital Sanford Tracy Medical Center Tracy MN 160 512 59
157 Hospital Tri-County Hospital Wadena MN 1,074 2,479 269
159 Hospital LakeWood Health Center Baudette MN 177 488 89
161 Hospital Lakewood Health System Staples MN 1,335 4,133 225
162 Hospital United Hospital District Blue Earth MN 315 1,746 61
163 Hospital United Hospital St. Paul MN 12,344 23,042 250 146
164 Hospital Unity Hospital Fridley MN 4,077 17,199 1,289
167 Hospital Essentia Health Virginia Virginia MN 2,353 6,330 499
168 Hospital Ridgeview Medical Center Waconia MN 4,686 366 11,250 435
169 Hospital North Valley Health Center Wa
en MN 73 388
170 Hospital Mayo Clinic Health System - Waseca Waseca MN 470 1,937
171 Hospital Mayo Clinic Health System - St. James St. James MN 385 1,226
172 Hospital Avera Marshall Regional Medical Center Marshall MN 1,195 1,937 13
174 Hospital Sanford Medical Center Wheaton Wheaton MN 407 322 10
175 Hospital Essentia Health - Aurora Aurora MN 1,026
176 Hospital Windom Area Hospital Windom MN 210 1,000 130
177 Hospital Sanford Worthington Medical Center Worthington MN 773 11 2,470 353
180 Hospital St. John's Hospital Maplewood MN 7,780 1,002 17,805 7,175
183 Hospital Regency Hospital of Minneapolis Golden Valley MN 394
184 Hospital Phillips Eye Institute Minneapolis MN
185 Hospital University of Minnesota Medical Center - Fairview Minneapolis MN 15,722 2,293 38,362 948 3,544
186 Hospital Fairview Lakes Regional Medical Center Wyoming MN 5,633 348 10,321 1,123
187 Hospital Woodwinds Health Campus Woodbury MN 4,905 12,728 3,045
191 Hospital Maple Grove Hospital Maple Grove MN 2,397 7,852 101
210 Hospital Shriners Hospitals for Children Minneapolis MN
211 Federal VA Hospital Veterans Affairs Medical Center Minneapolis MN 6,585 1,255 18,732 1,884
212 Federal VA Hospital Veterans Affairs Health Care System St. Cloud MN 69 3,715
300 Surgical Center Children's Healthcare Services Inc. DBA Children's - Minnetonka Minnetonka MN 1,106 240
304 Surgical Center WestHealth Inc. Plymouth MN 350 314
500 Clinic TRIA Orthopaedic Center Bloomington MN 13,041
504 Imaging Facility St. Paul Radiology Roseville/Arden Hills Arden Hills MN 2,404 1,088
505 Clinic St. Luke's Duluth Clinic System - Denfeld Medical Center Duluth MN 377
507 Clinic Minneapolis Orthopaedics, Ltd. - Minneapolis Minneapolis MN 813
509 Imaging Facility Lakes Imaging Center Brainerd MN 1,541
511 Imaging Facility Center for Diagnostic Imaging - Burnsville Burnsville MN 4,524 1,696
515 Clinic Park Nicollet Clinic Burnsville Burnsville MN 2,372 4,016
516 Imaging Facility Subu
an Imaging Burnsville Burnsville MN 1,870 1,490
517 Imaging Facility Center for Diagnostic Imaging - Coon Rapids Coon Rapids MN 3,132 1,507
519 Clinic Center for Specialty Care Fairmont MN 942
520 Imaging Facility Subu
an Imaging Coon Rapids Coon Rapids MN 10,986 1,871 12,858 1
523 Imaging Facility Community MRI Services, LLC Detroit Lakes MN 773
524 Imaging Facility St. Luke's Center for Diagnostic Imaging Duluth MN 6,357
525 Imaging Facility OpenUpright MRI of Duluth Duluth MN 1,808
526 Imaging Facility Mobile Imaging Services @ Regina Medical Center (Minneapolis Heart Institute) Hastings MN
527 Imaging Facility Mobile Imaging Services @ New Ulm Medical Center (Minneapolis Heart Institute) New Ulm MN
528 Imaging Facility Mobile Imaging Services @ Allina Medical Clinic - Northfield (Minneapolis Heart Institute) Northfield MN
529 Imaging Facility St. Paul Radiology Eagan Eagan MN 1,482 1,113
531 Imaging Facility Consulting Radiologists, Ltd. Edina MN 1,603 1,527
538 Clinic Urgency Room - Woodbury Woodbury MN 952
540 Imaging Facility Minnesota Radiology Edina MN 1,720 76
542 Imaging Facility Central Minnesota Diagnostic, Inc @ Minnesota Valley Health Center Le Sueur MN
544 Imaging Facility Center for Clinical Imaging Research Minneapolis MN 34 351
545 Clinic Twin Cities Orthopedics MRI Edina MN 6,018
546 Imaging Facility Open Sided MRI Golden Valley MN 778
549 Imaging Facility MN Diagnostic Imaging Partners dba Mpls Radiology Assoc. Maple Grove Maple Grove MN 3,616 3,423
550 Clinic Park Nicollet Clinic Maple Grove Maple Grove MN 1,271 2,052
551 Imaging Facility Subu
an Imaging Maple Grove Maple Grove MN 2,132 1,449
552 Imaging Facility Center for Diagnostic Imaging - Maplewood Maplewood MN 4,217 2,231
553 Imaging Facility Central Minnesota Diagnostic, Inc @ Hutchinson Area Health Care Hutchinson MN
554 Imaging Facility St. Paul Radiology Maplewood Maplewood MN 2,772 80 2,275
555 Imaging Facility Center for Diagnostic Imaging - Mendota Heights St. Paul MN 2,868 47 1,341
558 Mobile Unit Minnetonka Imaging MRI Woodbury MN
558 Mobile Unit Location see HCCIS ID 922 230
559 Mobile Unit Location Active Life Chiro Bloomington MN 1
559 Mobile Unit Location Advance Chiro Rochester MN 1
559 Mobile Unit Location Arndt Chiro Preston WI 2
559 Mobile Unit Location Bloom Chiro MN 1
559 Mobile Unit Location Boulevard Chiro St.Louis Park MN 11
559 Mobile Unit Location Burnsville Family Chiro Burnsville MN 3
559 Mobile Unit Location Cannon Point Chiro Northfield MN 2
559 Mobile Unit Location Cedar Chiro Owatonna MN 3
559 Mobile Unit Location Center Of Hwy 8 St. Croix Falls WI 1
559 Mobile Unit Location Chaska Lakes Chiro Chaska MN 2
559 Mobile Unit Location Co
et Chiro Northfield MN 6
559 Mobile Unit Location Ellsworth Chiro Ellsworth WI 5
559 Mobile Unit Location Family Friendly Chiro Coon Rapids MN 3
559 Mobile Unit Location First Chiro Shoreview MN 2
559 Mobile Unit Location Four Seasons Chiro Plymouth MN 1
559 Mobile Unit Location Four Seasons Chiro Plymouth MN 7
559 Mobile Unit Location Harel Chiro Hudson WI 20
559 Mobile Unit Location Heather Chiro Eden Prairie MN 2
559 Mobile Unit Location Hillside Chiro Elk River MN 2
559 Mobile Unit Location Kinni Valley Chiro River Falls WI 1
559 Mobile Unit Location Mcclelland Chiro River Falls WI 1
559 Mobile Unit Location Metro Center Chiro Minneapolis MN 1
559 Mobile Unit Mobile Diagnostic Imaging, Inc. MRI-1 Golden Valley MN
559 Mobile Unit Location Moseng Chiro Montevideo MN 7
559 Mobile Unit