Nursing homework
Lupita81
7 days ago
15
files (2)Diabetic_Data_Analysis_and_Visualization.docx
DiabeticDatasetandVisualizations-updated.xlsx
Diabetic_Data_Analysis_and_Visualization.docx
Diabetic Data Analysis and Visualization
Scenario
You are a new nurse informaticist at a small-sized regional hospital that has been actively collecting diabetes treatment data over the past year. The hospital aims to evaluate the effectiveness of its diabetes management programs and identify areas for improvement, particularly in terms of patient compliance and overall treatment outcomes.
It is just your luck that the person who was to present the data to stakeholders had to have emergency surgery and will be out for at least a month. The much-anticipated stakeholder meeting is in 2 weeks. The task of presenting the data now falls on you. Luckily, the data collection is complete, but the analysis and presentation now fall on your shoulders.
Your task is to analyze the collected data, focusing on treatment compliance and its impact on patient outcomes such as HbA1c levels, complications, and hospital admissions related to diabetes. Your analysis will help the hospital understand which factors are contributing to successful treatment outcomes and where additional resources or interventions are needed.
Analyze the Data
Use the attached, “Diabetic Dataset and Visualizations” to answer the questions below.
1. Explain what the cohort's mean age (52.36) represents
2. Compare treatment type and control (changes in HbA1c levels)
1. Which treatment type(s) produced the greatest decrease in HbA1c?
1. Did ALL methods of treatment reduce HbA1c?
1. What conclusions can you draw, if any?
3. Compare compliance with hospital admissions
1. Which type of compliance resulted in fewer hospital admissions?
1. What conclusions can you draw, if any?
4. Compare frequency of exercise and control (changes in HbA1c levels)
1. What conclusions can you draw, if any?
5. Compare the frequency of check-ups and control (changes in HbA1c levels)
1. What conclusions can you draw, if any?
6. Compare the BMI and initial HbA1c readings
1. What conclusions can you draw, if any?
7. Conclusions
Summarize your conclusions based on the data analysis.
8. Recommendations
Use conclusions from your analysis to craft your recommendations. Consider informatics tools and technologies.
DiabeticDatasetandVisualizations-updated.xlsx
Diabetic Data Set
| ID | Age | Gender | Ethni-city | BMI | (Yrs since dx) | Tx type | HbA1C Start of year | HbA1C End of year | Change in HbA1c | Avg. Blood Sugar | Check-up freq. | Tx Com-pliance | Exercise freq. | Complications | # of hosp adm r/t diabetes | ||||||||||
| 1001 | 58 | M | Hispanic | 32.0 | 2 | Insulin | 8.0 | 7.5 | -0.5 | 160 | 2 | Yes | 2 | Cardiovascular | 1 | ||||||||||
| 1002 | 50 | F | White | 29.0 | 5 | Oral Med | 7.5 | 7.0 | -0.5 | 150 | 4 | Yes | 3 | None | 0 | ||||||||||
| 1003 | 60 | M | Black | 33.0 | 8 | Combo | 8.5 | 7.8 | -0.7 | 175 | 5 | Yes | 4 | Nephropathy | 2 | ||||||||||
| 1004 | 47 | F | Asian | 27.0 | 3 | Diet and exercise | 7.0 | 6.5 | -0.5 | 140 | 3 | Yes | 5 | None | 0 | ||||||||||
| 1005 | 55 | M | Hispanic | 31.0 | 7 | Insulin | 8.2 | 7.7 | -0.5 | 165 | 1 | No | 1 | Cardiovascular | 3 | ||||||||||
| 1006 | 52 | F | White | 28.0 | 6 | Oral Med | 7.2 | 6.7 | -0.5 | 145 | 4 | Yes | 4 | None | 0 | ||||||||||
| 1007 | 49 | M | Black | 34.0 | 4 | Combo | 8.3 | 7.6 | -0.7 | 170 | 5 | Yes | 3 | Neuropathy | 1 | ||||||||||
| 1008 | 45 | F | Asian | 26.0 | 2 | Diet and exercise | 6.8 | 6.3 | -0.5 | 135 | 3 | Yes | 5 | None | 0 | ||||||||||
| 1009 | 59 | M | Hispanic | 30.0 | 9 | Insulin | 8.4 | 7.9 | -0.5 | 162 | 2 | No | 2 | Retinopathy | 2 | ||||||||||
| 1010 | 53 | F | White | 29.0 | 5 | Oral Med | 7.3 | 6.8 | -0.5 | 148 | 4 | Yes | 3 | none | 0 | ||||||||||
| 1011 | 61 | M | Black | 32.0 | 10 | Combo | 8.6 | 7.9 | -0.7 | 180 | 5 | Yes | 4 | Multiple | 3 | ||||||||||
| 1012 | 46 | F | Asian | 25.0 | 1 | Diet and exercise | 6.9 | 6.4 | -0.5 | 138 | 3 | Yes | 5 | none | 0 | ||||||||||
| 1013 | 54 | M | Hispanic | 33.0 | 6 | Insulin | 8.1 | 7.6 | -0.5 | 163 | 1 | No | 1 | Cardiovascular | 3 | ||||||||||
| 1014 | 51 | F | White | 28.0 | 7 | Oral Med | 7.4 | 6.9 | -0.5 | 147 | 4 | Yes | 4 | None | 0 | ||||||||||
| 1015 | 48 | M | Black | 35.0 | 3 | Combo | 8.4 | 7.7 | -0.7 | 172 | 5 | Yes | 3 | Neuropathy | 1 | ` | |||||||||
| 1016 | 44 | F | Asian | 26.0 | 2 | Diet and exercise | 6.7 | 6.2 | -0.5 | 132 | 3 | Yes | 5 | None | 0 | ||||||||||
| 1017 | 57 | M | Hispanic | 31.0 | 8 | Insulin | 8.3 | 7.8 | -0.5 | 167 | 2 | No | 2 | Retinopathy | 2 | ||||||||||
| 1018 | 50 | F | White | 27.0 | 4 | Oral Med | 7.1 | 6.6 | -0.5 | 143 | 4 | Yes | 4 | None | 0 | ||||||||||
| 1019 | 62 | M | Black | 34.0 | 9 | Combo | 8.7 | 8.0 | -0.7 | 182 | 5 | Yes | 4 | None | 0 | ||||||||||
| 1020 | 47 | F | Asian | 25.0 | 1 | Diet and exercise | 6.6 | 6.1 | -0.5 | 130 | 3 | Yes | 5 | None | 0 | ||||||||||
| 1021 | 56 | M | Hispanic | 32.0 | 7 | Insulin | 8.2 | 7.7 | -0.5 | 168 | 1 | No | 1 | Cardiovascular | 3 | ||||||||||
| 1022 | 49 | F | White | 28.0 | 3 | Oral Med | 7.0 | 6.5 | -0.5 | 139 | 4 | Yes | 4 | None | 0 | ||||||||||
| 1023 | 58 | M | Black | 33.0 | 6 | Combo | 8.5 | 7.8 | -0.7 | 177 | 5 | Yes | 3 | Neuropathy | 2 | ||||||||||
| 1024 | 45 | F | Black | 26.0 | 2 | Diet and exercise | 6.8 | 6.3 | -0.5 | 133 | 3 | Yes | 5 | None | 0 | ||||||||||
| 1025 | 53 | M | Hispanic | 30.0 | 5 | Insulin | 8.0 | 7.5 | -0.5 | 160 | 2 | No | 2 | Retinopathy | 2 |
Data Visualizations
| Bar Chart Depicting Sum of Change in HbA1c by Tx Type | Clustered Column Chart Depicting Compliance and Hospital Admissions | |||||||||||||||||||||||
| Stacked Column Chart Depicting Exercise Frequency and Changes in HbA1c | Scatter Plot Chart Depicting BMI and Initial HbA1c | |||||||||||||||||||||||
| Pie Chat Depicting Gender Distribution | ||||||||||||||||||||||||
| Stacked Column Chart Depicting Check-up Frequency and Change in HbA1c | ||||||||||||||||||||||||
| Pie Chart Depicting Ethnicity | ||||||||||||||||||||||||
image1.png
image2.png
image3.png
image4.png
image5.png
image6.png
image7.png
- Due by 10 pm central time on due date , Must be in simple mid-level terms formed un your own words.
- Raising a Product or a Quotient to a power. Simplify. Assume that no denominator is 0
- mgt
- Thanks
- Learning Team Case Studies 8-3, 9-1 / qrb 501
- for trevian
- The Freedman's Bureau Letters
- MKT 421 Final Exams (10 different)
- EEOC religious discrimination criteria
- will this assignment be completed in 10 hours?
