Calculate the weighted volumes (Wt. Vol) for each DRG and each of the 3 quarters (Q1, Q2, and Q3). Formula: MS-DRG RW Weight x Volume Populate the Excel spreadsheet with your results for each DRG for all 3 quarters MS-DRG MS-DRG RW Weight Volume Q1 VolumeQ2 VolumeQ3 56 1.8513 35 38 33 57 1.0716 12 13 11 58 1.7198 47 48 43 59 1.0134 5 7 5 60 0.813 21 19 20 61 2.6843 35 34 28 62 1.8918 27 31 25 63 1.5238 4 6 3 64 1.7326 35 36 33 65 1.0593 44 46 42
Calculate the weighted volumes (Wt. Vol) for each DRG and each of the 3 quarters (Q1, Q2, and Q3). Formula: MS-DRG RW Weight x Volume Populate the Excel spreadsheet with your results for each DRG for all 3 quarters MS-DRG MS-DRG RW Weight Volume Q1 VolumeQ2 VolumeQ3 56 1.8513 35 38 33 57 1.0716 12 13 11 58 1.7198 47 48 43 59 1.0134 5 7 5 60 0.813 21 19 20 61 2.6843 35 34 28 62 1.8918 27 31 25 63 1.5238 4 6 3 64 1.7326 35 36 33 65 1.0593 44 46 42
Chapter8: Hypodermic Syringe Measurement
Section: Chapter Questions
Problem 1.1P
Related questions
Question
Calculate the weighted volumes (Wt. Vol) for each DRG and each of the 3 quarters (Q1, Q2, and Q3).
- Formula: MS-DRG RW Weight x Volume
- Populate the Excel spreadsheet with your results for each DRG for all 3 quarters
MS-DRG |
MS-DRG RW Weight |
Volume |
Volume |
Volume |
56 |
1.8513 |
35 |
38 |
33 |
57 |
1.0716 |
12 |
13 |
11 |
58 |
1.7198 |
47 |
48 |
43 |
59 |
1.0134 |
5 |
7 |
5 |
60 |
0.813 |
21 |
19 |
20 |
61 |
2.6843 |
35 |
34 |
28 |
62 |
1.8918 |
27 |
31 |
25 |
63 |
1.5238 |
4 |
6 |
3 |
64 |
1.7326 |
35 |
36 |
33 |
65 |
1.0593 |
44 |
46 |
42 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Cardiopulmonary Anatomy & Physiology
Biology
ISBN:
9781337794909
Author:
Des Jardins, Terry.
Publisher:
Cengage Learning,
Cardiopulmonary Anatomy & Physiology
Biology
ISBN:
9781337794909
Author:
Des Jardins, Terry.
Publisher:
Cengage Learning,
Case Studies In Health Information Management
Biology
ISBN:
9781337676908
Author:
SCHNERING
Publisher:
Cengage