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...

1 answer below »
Please create 5 pages without the cover page. I can do the cover. Provide the appropriate charts needed. If possible, can you please use RStudio instead of excel to complete the project?


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 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. 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 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), 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 IDFacility TypeNameCityStateMRI ProceduresPET ProceduresPET/CT ProceduresCT ProceduresSPECT/CT ProceduresSPECT Procedures 1HospitalTyler Healthcare Center, Inc.TylerMN128393 2HospitalAbbott Northwestern HospitalMinneapolisMN19,7918001,46335,5172,949 3HospitalEssentia Health AdaAdaMN44240 4HospitalRiverwood HealthCare CenterAitkinMN9582,83256 5HospitalAlbany Area Hospital and Medical CenterAlbanyMN36863659 6HospitalAppleton Municipal Hospital and Nursing HomeAppletonMN82273 7HospitalSibley Medical CenterArlingtonMN15377624 10HospitalBethesda LTACHSt. PaulMN169940 11HospitalBuffalo HospitalBuffaloMN3,133537,347 13HospitalCambridge Medical CenterCambridgeMN3,5352967,301 14HospitalSanford Canby Medical CenterCanbyMN19859999 15HospitalMayo Clinic Health System - Cannon FallsCannon FallsMN2321,012 17HospitalChippewa County-Montevideo HospitalMontevideoMN4662,057 19HospitalSanford Bagley Medical CenterBagleyMN285843206 21HospitalSanford Hospital LuverneLuverneMN295946133 22HospitalRiver's Edge Hospital & ClinicSt. PeterMN1731,245 24HospitalCloquet Memorial Hospital AssociationCloquetMN1,0133,54914 25HospitalDeer River HealthCare CenterDeer RiverMN5571,131136 27HospitalWinona Health ServicesWinonaMN1,2744,672558 28HospitalMille Lacs Health SystemOnamiaMN6611,82947 29HospitalCook Hospital & C&NCCookMN10192511 30HospitalCook County North Shore HospitalGrand MaraisMN128399 31HospitalCuyuna Regional Medical CenterCrosbyMN1,7151054,571 34HospitalDouglas County HospitalAlexandriaMN666906,01634 35HospitalSanford Westbrook Medical CenterWestbrookMN9722114 37HospitalEly-Bloomenson Community Hospital & Nursing HomeElyMN2751,025107 39HospitalMayo Clinic Health System - FairmontFairmontMN1,3604,651 41HospitalFairview Northland Regional HospitalPrincetonMN2,3161315,195527 42HospitalFairview Ridges HospitalBurnsvilleMN7,36829,4602,284 44HospitalFairview Southdale HospitalEdinaMN7,11025327,5179673,668 45HospitalRainy Lake Medical CenterInternational FallsMN5671,70288 46HospitalFirst Care Medical ServicesFosstonMN299660184 49HospitalGillette Children's Specialty HealthcareSt. PaulMN3,0891,101 50HospitalGlacial Ridge Health SystemGlenwoodMN41051,179 51HospitalGlencoe Regional Health ServicesGlencoeMN8581,592263 53HospitalGranite Falls Municipal Hospital & ManorGranite FallsMN335914110 54HospitalPrairie Ridge Hospital & Health ServicesElbow LakeMN250467109 57HospitalOwatonna HospitalOwatonnaMN4,766 58HospitalHendricks Community Hospital AssociationHendricksMN75342 59HospitalHennepin County Medical CenterMinneapolisMN7,85742127,903383 61HospitalEssentia Health - GracevilleGracevilleMN7226511 62HospitalHutchinson HealthHutchinsonMN1,9821683,979391 63HospitalMayo Clinic Health System - MankatoMankatoMN3,47215,306 64HospitalGrand Itasca Clinic and HospitalGrand RapidsMN2,2961764,400463 65HospitalSanford Jackson Medical CenterJacksonMN9157565 66HospitalJohnson Memorial Health ServicesDawsonMN136380 67HospitalFirstLight Health SystemMoraMN1,17033,172316 69HospitalKittson Memorial Healthcare CenterHallockMN174181 70HospitalMayo Clinic Health System - Lake CityLake CityMN2701,039 71HospitalLake Region Healthcare CorporationFergus FallsMN1,6652203,834296 72HospitalLake View Memorial HospitalTwo HarborsMN133901 74HospitalLakeview Memorial HospitalStillwaterMN2,9751836,215 76HospitalCentraCare Health System - Long PrairieLong PrairieMN5481,338 77HospitalMadelia Community HospitalMadeliaMN59292 78HospitalMadison HospitalMadisonMN133500 79HospitalMahnomen Health CenterMahnomenMN1771,010 80HospitalMeeker Memorial HospitalLitchfieldMN67181,536114 81HospitalMelrose Area Hospital - CentraCareMelroseMN5131,320 83HospitalMercy HospitalMoose LakeMN5861,52867 84HospitalMercy HospitalCoon RapidsMN7,16026,0463,334 85HospitalFairview University Medical Center - MesabiHibbingMN2,5433306,365700 86HospitalPark Nicollet Methodist HospitalSt. Louis ParkMN16,6921,98836,3853,449 90HospitalSMDC Medical CenterDuluthMN4,8335857,004 91HospitalChildren's Health Care dba Children's Hospitals and Clinics of MinnesotaMinneapolisMN7,2576,1495 92HospitalMinnesota Valley Health CenterLe SueurMN12347116 94HospitalNew River Medical CenterMonticelloMN1,008423,05690 98HospitalRedwood Area HospitalRedwood FallsMN5121,465 99HospitalMurray County Memorial HospitalSlaytonMN3501,177240 100HospitalMayo Clinic Health System - Albert LeaAlbert LeaMN1,8217,49225 102HospitalSanford Bemidji Medical CenterBemidjiMN3,49119010,2992,045 103HospitalNorth Memorial Medical CenterRobbinsdaleMN9,2021,05330,732 104HospitalBigfork Valley HospitalBigforkMN27148481 105HospitalNorthfield Hospital & ClinicsNorthfieldMN1,406504,8301,371 106HospitalSanford Medical Center Thief River FallsThief River FallsMN1,0922,621542 107HospitalOlmsted Medical CenterRochesterMN4,6157,442 108HospitalOrtonville Area Health ServicesOrtonvilleMN3907734 110HospitalPaynesville Area Health Care SystemPaynesvilleMN561371,732137 112HospitalPerham HealthPerhamMN8852,053 113HospitalPipestone County Medical CenterPipestoneMN5821,457 114HospitalMayo Clinic Health System - New PragueNew PragueMN748262,109100 115HospitalRegina Medical CenterHastingsMN1,6604,881385 116HospitalRenville County HospitalOliviaMN259765 117HospitalDistrict One HospitalFaribaultMN2,142495,0322 118HospitalRice Memorial HospitalWillmarMN1,1671304,033712 119HospitalRiverview Healthcare AssociationCrookstonMN1,0892,037450 120HospitalMayo Clinic Methodist HospitalRochesterMN94038811,3943,9802,209 121HospitalLifeCare Medical CenterRoseauMN682201,803339 124HospitalEssentia Health - SandstoneSandstoneMN2961,275 127HospitalNew Ulm Medical CenterNew UlmMN1,7491613,612410 129HospitalSleepy Eye Medical CenterSleepy EyeMN13270314 130HospitalMayo Clinic Health System - SpringfieldSpringfieldMN226764 132HospitalSt. Cloud HospitalSt. CloudMN9,6361,50734,5741232,808 133HospitalSaint Elizabeth's Medical CenterWabashaMN2901,032 134HospitalSt. Francis Medical CenterBreckenridgeMN6601,58439 135HospitalSt. Francis Regional Medical CenterShakopeeMN4,56917810,49316,675 136HospitalSt. Gabriel's HospitalLittle FallsMN2,1313,271244 138HospitalMayo Clinic Health System - Red WingRed WingMN1,9281005,269114 140HospitalSt. Joseph's Area Health Services, Inc.Park RapidsMN1,1462,775357 141HospitalSt. Joseph's HospitalSt. PaulMN4,22812,2763,412 142HospitalSt. Joseph's Medical CenterBrainerdMN4,2803889,650590 143HospitalSt. Luke's HospitalDuluthMN25914,996948 145HospitalSaint Marys HospitalRochesterMN6,85642,718971,060 147HospitalSt. Mary's Regional Health CenterDetroit LakesMN1,3144,167 148HospitalSt. Mary's Medical CenterDuluthMN6,59916,708 149HospitalCentracare Health System - Sauk CentreSauk CentreMN463929100 150HospitalMayo Clinic Health System-AustinAustinMN1,5044,704419 151HospitalRegions HospitalSt. PaulMN16,91678135,0244,152 152HospitalStevens Community Medical CenterMorrisMN742261,95450 153HospitalSwift County-Benson HospitalBensonMN199744 156HospitalSanford Tracy Medical CenterTracyMN16051259 157HospitalTri-County HospitalWadenaMN1,0742,479269 159HospitalLakeWood Health CenterBaudetteMN17748889 161HospitalLakewood Health SystemStaplesMN1,3354,133225 162HospitalUnited Hospital DistrictBlue EarthMN3151,74661 163HospitalUnited HospitalSt. PaulMN12,34423,042250146 164HospitalUnity HospitalFridleyMN4,07717,1991,289 167HospitalEssentia Health VirginiaVirginiaMN2,3536,330499 168HospitalRidgeview Medical CenterWaconiaMN4,68636611,250435 169HospitalNorth Valley Health CenterWarrenMN73388 170HospitalMayo Clinic Health System - WasecaWasecaMN4701,937 171HospitalMayo Clinic Health System - St. JamesSt. JamesMN3851,226 172HospitalAvera Marshall Regional Medical CenterMarshallMN1,1951,93713 174HospitalSanford Medical Center WheatonWheatonMN40732210 175HospitalEssentia Health - AuroraAuroraMN1,026 176HospitalWindom Area HospitalWindomMN2101,000130 177HospitalSanford Worthington Medical CenterWorthingtonMN773112,470353 180HospitalSt. John's HospitalMaplewoodMN7,7801,00217,8057,175 183HospitalRegency Hospital of MinneapolisGolden ValleyMN394 184HospitalPhillips Eye InstituteMinneapolisMN 185HospitalUniversity of Minnesota Medical Center - FairviewMinneapolisMN15,7222,29338,3629483,544 186HospitalFairview Lakes Regional Medical CenterWyomingMN5,63334810,3211,123 187HospitalWoodwinds Health CampusWoodburyMN4,90512,7283,045 191HospitalMaple Grove HospitalMaple GroveMN2,3977,852101 210HospitalShriners Hospitals for ChildrenMinneapolisMN 211Federal VA HospitalVeterans Affairs Medical CenterMinneapolisMN6,5851,25518,7321,884 212Federal VA HospitalVeterans Affairs Health Care SystemSt. CloudMN693,715 300Surgical CenterChildren's Healthcare Services Inc. DBA Children's - MinnetonkaMinnetonkaMN1,106240 304Surgical CenterWestHealth Inc.PlymouthMN350314 500ClinicTRIA Orthopaedic CenterBloomingtonMN13,041 504Imaging FacilitySt. Paul Radiology Roseville/Arden HillsArden HillsMN2,4041,088 505ClinicSt. Luke's Duluth Clinic System - Denfeld Medical CenterDuluthMN377 507ClinicMinneapolis Orthopaedics, Ltd. - MinneapolisMinneapolisMN813 509Imaging FacilityLakes Imaging CenterBrainerdMN1,541 511Imaging FacilityCenter for Diagnostic Imaging - BurnsvilleBurnsvilleMN4,5241,696 515ClinicPark Nicollet Clinic BurnsvilleBurnsvilleMN2,3724,016 516Imaging FacilitySuburban Imaging BurnsvilleBurnsvilleMN1,8701,490 517Imaging FacilityCenter for Diagnostic Imaging - Coon RapidsCoon RapidsMN3,1321,507 519ClinicCenter for Specialty CareFairmontMN942 520Imaging FacilitySuburban Imaging Coon RapidsCoon RapidsMN10,9861,87112,8581 523Imaging FacilityCommunity MRI Services, LLCDetroit LakesMN773 524Imaging FacilitySt. Luke's Center for Diagnostic ImagingDuluthMN6,357 525Imaging FacilityOpenUpright MRI of DuluthDuluthMN1,808 526Imaging FacilityMobile Imaging Services @ Regina Medical Center (Minneapolis Heart Institute)HastingsMN 527Imaging FacilityMobile Imaging Services @ New Ulm Medical Center (Minneapolis Heart Institute)New UlmMN 528Imaging FacilityMobile Imaging Services @ Allina Medical Clinic - Northfield (Minneapolis Heart Institute)NorthfieldMN 529Imaging FacilitySt. Paul Radiology EaganEaganMN1,4821,113 531Imaging FacilityConsulting Radiologists, Ltd.EdinaMN1,6031,527 538ClinicUrgency Room - WoodburyWoodburyMN952 540Imaging FacilityMinnesota RadiologyEdinaMN1,72076 542Imaging FacilityCentral Minnesota Diagnostic, Inc @ Minnesota Valley Health CenterLe SueurMN 544Imaging FacilityCenter for Clinical Imaging ResearchMinneapolisMN34351 545ClinicTwin Cities Orthopedics MRIEdinaMN6,018 546Imaging FacilityOpen Sided MRIGolden ValleyMN778 549Imaging FacilityMN Diagnostic Imaging Partners dba Mpls Radiology Assoc. Maple GroveMaple GroveMN3,6163,423 550ClinicPark Nicollet Clinic Maple GroveMaple GroveMN1,2712,052 551Imaging FacilitySuburban Imaging Maple GroveMaple GroveMN2,1321,449 552Imaging FacilityCenter for Diagnostic Imaging - MaplewoodMaplewoodMN4,2172,231 553Imaging FacilityCentral Minnesota Diagnostic, Inc @ Hutchinson Area Health CareHutchinsonMN 554Imaging FacilitySt. Paul Radiology MaplewoodMaplewoodMN2,772802,275 555Imaging FacilityCenter for Diagnostic Imaging - Mendota HeightsSt. PaulMN2,868471,341 558Mobile UnitMinnetonka Imaging MRIWoodburyMN 558Mobile Unit Locationsee HCCIS ID 922230 559Mobile Unit LocationActive Life ChiroBloomingtonMN1 559Mobile Unit LocationAdvance ChiroRochesterMN1 559Mobile Unit LocationArndt ChiroPrestonWI2 559Mobile Unit LocationBloom ChiroMN1 559Mobile Unit LocationBoulevard ChiroSt.Louis ParkMN11 559Mobile Unit LocationBurnsville Family ChiroBurnsvilleMN3 559Mobile Unit LocationCannon Point ChiroNorthfieldMN2 559Mobile Unit LocationCedar ChiroOwatonnaMN3 559Mobile Unit LocationCenter Of Hwy 8St. Croix FallsWI1 559Mobile Unit LocationChaska Lakes ChiroChaskaMN2 559Mobile Unit LocationCorbet ChiroNorthfieldMN6 559Mobile Unit LocationEllsworth ChiroEllsworthWI5 559Mobile Unit LocationFamily Friendly ChiroCoon RapidsMN3 559Mobile Unit LocationFirst ChiroShoreviewMN2 559Mobile Unit LocationFour Seasons ChiroPlymouthMN1 559Mobile Unit LocationFour Seasons ChiroPlymouthMN7 559Mobile Unit LocationHarel ChiroHudsonWI20 559Mobile Unit LocationHeather ChiroEden PrairieMN2 559Mobile Unit LocationHillside ChiroElk RiverMN2 559Mobile Unit LocationKinni Valley ChiroRiver FallsWI1 559Mobile Unit LocationMcclelland ChiroRiver FallsWI1 559Mobile Unit LocationMetro Center ChiroMinneapolisMN1 559Mobile UnitMobile Diagnostic Imaging, Inc. MRI-1Golden ValleyMN 559Mobile Unit LocationMoseng ChiroMontevideoMN7 559Mobile Unit
Answered 2 days AfterJul 07, 2022

Answer To: CHOOSEN TOPIC: Comparing the number of MRI Procedures between Clinics and Hospitals (all states)...

Shreya answered on Jul 10 2022
77 Votes
MRI_ClinicHospital
MRI_ClinicHospital
2022-07-08
knitr::opts_chunk$set(warning = FALSE, message=FALSE, tidy.opts=list(width.cutoff=80), tidy=TRUE, echo = TRUE)
# Libraries
library(tidyverse)
library(readxl)
library(ggplot2)
library(rmarkdown)
# Dataset use
d in this report
data <- readxl::read_excel(path = "C:/Users/shrey/OneDrive/Documents/Greynodes/assignment-2-data-set-x12bocvv.xlsx",
sheet = "Data")
# Looking at the first few entries of the data
head(data)
## # A tibble: 6 x 11
## `HCCIS ID` `Facility Type` Name City State `MRI Procedures` `PET Procedures`
##
## 1 1 Hospital Tyle~ Tyler MN 128 NA
## 2 2 Hospital Abbo~ Minn~ MN 19791 800
## 3 3 Hospital Esse~ Ada MN 44 NA
## 4 4 Hospital Rive~ Aitk~ MN 958 NA
## 5 5 Hospital Alba~ Alba~ MN 368 NA
## 6 6 Hospital Appl~ Appl~ MN 82 NA
## # ... with 4 more variables: PET/CT Procedures , CT Procedures ,
## # SPECT/CT Procedures , SPECT Procedures
# Looking at data structure
str(data)
## tibble [496 x 11] (S3: tbl_df/tbl/data.frame)
## $ HCCIS ID : num [1:496] 1 2 3 4 5 6 7 10 11 13 ...
## $ Facility Type : chr [1:496] "Hospital" "Hospital" "Hospital" "Hospital" ...
## $ Name : chr [1:496] "Tyler Healthcare Center, Inc." "Abbott Northwestern Hospital" "Essentia Health Ada" "Riverwood HealthCare Center" ...
## $ City : chr [1:496] "Tyler" "Minneapolis" "Ada" "Aitkin" ...
## $ State : chr [1:496] "MN" "MN" "MN" "MN" ...
## $ MRI Procedures : num [1:496] 128 19791 44 958 368 ...
## $ PET Procedures : num [1:496] NA 800 NA NA NA NA NA NA NA NA ...
## $ PET/CT Procedures : num [1:496] NA 1463 NA NA NA ...
## $ CT Procedures : num [1:496] 393 35517 240 2832 636 ...
## $ SPECT/CT Procedures: num [1:496] NA NA NA NA NA NA NA NA NA NA ...
## $ SPECT Procedures : num [1:496] NA 2949 NA 56 59 ...
# Getting the dimensions of the dataset
dim(data)
## [1] 496 11
There are 496 observations (rows) of 11 attributes(columns)
# Getting the column names
colnames(data)
## [1] "HCCIS ID" "Facility Type" "Name"
## [4] "City" "State" "MRI Procedures"
## [7] "PET Procedures" "PET/CT Procedures" "CT Procedures"
##...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here