Answered step by step
Verified Expert Solution
Question
1 Approved Answer
what step do I take in excel to make a box plot with the information below? Hospital Characteristics Teaching Non-Teaching p-value N Mean St. Dev
what step do I take in excel to make a box plot with the information below?
Hospital Characteristics | Teaching | Non-Teaching | p-value | ||||
N | Mean | St. Dev | N | Mean | St. Dev | ||
1. Hospital beds | 936 | 549 | 605 | 2094 | 300 | 537 | 0 |
2. Number of paid Employee | 929 | 2476 | 2551 | 2084 | 870 | 1001 | 0 |
3. Number of non-paid Employees | 30 | 57.1 | 102 | 30 | 27.7 | 32.6 | 0.1409 |
4. Interns and Residents | 617 | 125 | 179 | 308 | 0.577 | 0.494 | 0 |
5. System Membership | 936 | 0.67 | 0.471 | 2094 | 0.577 | 0.494 | 0 |
6. Total hospital cost | 936 | 392979714 | 424408629 | 2094 | 136608825 | 169943309 | 0 |
7. Total hospital revenues | 936 | 19.4 | 457483256 | 2094 | 8635257 | 30582241 | 0 |
8. Hospital net benefit | 936 | 24522161 | 52182874 | 2094 | 8635257 | 30582241 | 0 |
9. Available Medicare days | 929 | 28826 | 24287 | 2086 | 11626 | 13980 | 0 |
10. Available Medicaid days | 929 | 10373 | 13103 | 2056 | 3057 | 5538 | 0 |
11. Total Hospital Discharge | 929 | 16650 | 133564 | 2088 | 6345 | 7655 | 0 |
12. Medicare discharge | 929 | 5572 | 4247 | 2086 | 2455 | 2773 | 0 |
13. Medicaid discharge | 929 | 2011 | 2311 | 2050 | 724 | 1228 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started