Questions
For Questions 1-18, answer each individually based on the values in your pivot table. PLEASE
NOTE: You do not need to turn in the pivot table for this assignment; only the answers to the
questions below will be assessed.
For General Hospital
1. What was the shortest length of stay in the 24-month period? 1 day
2. What was the longest length of stay in the 24-month period? 99 days
3. What was the average length of stay in the 24-month period? 4.5 days
4. What was the lowest cost of stay in the 24-month period? $211.00
5. What was the highest cost of stay in the 24-month period? $11,131.72
6. What was the average cost of stay in the 24-month period? $9520.15
For Hillside Pediatric
7. What was the shortest length of stay in the 24-month period? 1 day
8. What was the longest length of stay in the 24-month period? 108 days
9. What was the average length of stay in the 24-month period? 4.9 days
10. What was the lowest cost of stay in the 24-month period? $285.00
11. What was the highest cost of stay in the 24-month period? $13,231.66
12. What was the average cost of stay in the 24-month period? $10,726.18
For Valley View Therapy
13. What was the shortest length of stay in the 24-month period? 1 day
14. What was the longest length of stay in the 24-month period? 283 days
EHR Go Knowledge Activity: Query – Average Length of Stay (Informatics) IK1035.4 1
Archetype Innovations LLC ©2024
For Questions 1-18, answer each individually based on the values in your pivot table. PLEASE
NOTE: You do not need to turn in the pivot table for this assignment; only the answers to the
questions below will be assessed.
For General Hospital
1. What was the shortest length of stay in the 24-month period? 1 day
2. What was the longest length of stay in the 24-month period? 99 days
3. What was the average length of stay in the 24-month period? 4.5 days
4. What was the lowest cost of stay in the 24-month period? $211.00
5. What was the highest cost of stay in the 24-month period? $11,131.72
6. What was the average cost of stay in the 24-month period? $9520.15
For Hillside Pediatric
7. What was the shortest length of stay in the 24-month period? 1 day
8. What was the longest length of stay in the 24-month period? 108 days
9. What was the average length of stay in the 24-month period? 4.9 days
10. What was the lowest cost of stay in the 24-month period? $285.00
11. What was the highest cost of stay in the 24-month period? $13,231.66
12. What was the average cost of stay in the 24-month period? $10,726.18
For Valley View Therapy
13. What was the shortest length of stay in the 24-month period? 1 day
14. What was the longest length of stay in the 24-month period? 283 days
EHR Go Knowledge Activity: Query – Average Length of Stay (Informatics) IK1035.4 1
Archetype Innovations LLC ©2024
