Excel Assignment Week 5 LIZBETH GARCIA

xlsx

School

DeVry University, Chicago *

*We aren’t endorsed by this school

Course

226

Subject

Mechanical Engineering

Date

Jan 9, 2024

Type

xlsx

Pages

11

Uploaded by EarlEel1831

Report
HIT 226 Excel Assignment # 3 - See the syyllabus section "Due Date for as Fiscal Year 2017 Race/Ethnicity Discharges '17 ER visits* '17 Outpt. procedures '17 Discharges '18 Asian 1,426 1,208 2,600 1,206 African American 2,312 2,896 3,114 2,211 Hispanic 3,500 2,865 5,365 3,800 Native American 268 404 980 147 Other/Unknown 976 708 1,245 965 Caucasian 4,005 6,432 6,762 3,887 Totals 12,487 14,513 20,066 12,216 Reason for encounter Discharges '17 ER visits* '17 Outpt. procedures '17 Discharges '18 Heart conditions 3,450 3,050 3,602 3,402 Respiratory conditions 2,645 2,760 2,890 2,441 Diabetes 1,014 1,001 897 1,112 Pregnancy/Delivery 2,859 16 3,564 3,314 Orthopedic care/surgery 1,208 564 5,213 1,008 Trauma 268 3,874 - 212 Other 1,043 3,248 3,900 727 Totals 12,487 14,513 20,066 12,216 Requirements with point allocation Question Point Value Points scored 1 8 2 8 3 8 4 8 5 8 Identify the top 6 8 7 8 Identify the tren The hospital data below shows the number of discharges, ER visits (*excluding ER encounters surgeries) by race/ethnicity and by condition or reason for the encounter, such as admission information, as per requirements listed below, under the data table. (Make sure to scroll all Create the appro inpatients (disch Create the appro outpatients (out 2019. Identify two tren you have created Show in one grap encounter in 201 Show in one grap and 2019.
8 8 9 8 10 8 Total points 80 0 Hints: When responding the last question (suggestions for the hospital adminis Show in one grap conditions in 201 Identify two tren conditions. After looking at t provide at least o For full credit, make sure to include titles, axes and legends in all graphs
ssignments and exams" Fiscal Year 2018 Fiscal Year 2019 ER visits* '18 Outpt. procedures '18 Discharges '19 ER visits* '19 Outpt. Procedures '19 1,094 2,689 1,156 956 2,700 3,002 3,220 1,800 3,200 3,224 2,988 5,150 4,008 3,120 4,985 414 1,600 142 100 3,200 687 1,368 967 690 1,400 5,056 7,580 3,750 4,987 7,690 13,241 21,607 11,823 13,053 23,199 ER visits* '18 Outpt. procedures '18 Discharges '19 ER visits* '19 Outpt. Procedures '19 2,970 3,558 3,115 2,900 3,417 2,905 2,714 2,006 3,295 2,997 1,002 906 885 1,056 1,024 20 3,754 4,216 18 4,056 552 5,540 887 502 5,978 3,902 - 187 4,012 - 1,890 5,135 527 1,270 5,727 13,241 21,607 11,823 13,053 23,199 Requirements Create the graph in the 1. Inpatient Composition tab Create the graph in the 2. Outpatient Composition tab Create the graph in the 4. ER 2019 tab three reasons for ER visits in 2019. As I look at my line chart I notice that the top main reaso Create the graph in the 6. ER Heart Cases tab nd of ER encounters related to heart conditions. there were more heart conditions in year 2017 than the s that resulted in patient admission), and outpatient encounters (such as radiology testing or outpatient (which results in a discharge), ER, or outpatient procedure. Use the data to build graphs and analyze the the way down for complete list and hints.) opriate graphs to show the composition of the hospital harges only) by race/ethnicity in 2017, 2018, and 2019. opriate graphs to show the composition of the hospital tpatient procedures) by race/ethnicity in 2017, 2018, & nds related to questions 1 and 2 by observing the graphs d. One of the trends i saw between both graphs is both has number on native american ph the volume (number) of ER visits by reason for 19. ph the ER encounters for heart conditions in 2017, 2018,
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Create the graph in the 8. DCs by Condition tab strator), think about what resources they may need to reallocate, expand, etc. ph the volume (number) of discharges related to all 7 17, 2018, and 2019. nds of the hospital discharges in relation to those Two trends I found between all those years were heart co and respitory which as well older people or anyone. the overall hospital data and the trends identified, one suggestion for the hospital administrator. One suggestion I would suggest for the administrator afte are heart conditions so I would suggest to have my empl more aware of that. s . It may help to place graphs in separate sheets. Adding labels to some of the graphs, may also help.
on for er visits is trauma, the second is respitory conditions and oth following years. s high numbers on caucasian and asian and both had a least
onditions which makes me feel like they get moslty older people er looking though all the data, the main one reason for er visits loyers the most knoweledegable in the heart and respitory to be
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1,426 2,312 3,500 268 976 4,005 Discharges '17 Asian African American Hispanic Native American Other/Unknown Caucasian
2,600 3,114 5,365 980 1,245 6,762 Outpt. procedures '17 Asian African American Hispanic Native American Other/Unknown Caucasian
Heart conditions Respiratory conditions Diab ete s Preg na ncy/Deli ver y Orth op edic care/surger y Traum a Other - 500 1,000 1,500 2,000 2,500 3,000 3,500 4,000 4,500 2,900 3,295 1,056 18 502 4,012 1,270 ER visits* '19
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ER visits* '17 ER visits* '18 ER visits* '19 2,800 2,850 2,900 2,950 3,000 3,050 3,100 3,050 2,970 2,900 Heart conditions
3,450 2,645 1,014 2,859 1,208 268 1,043 Discharges '17 Heart conditions Respiratory conditions Diabetes Pregnancy/Delivery Orthopedic care/surgery Trauma Other