Question: how to solve this in excel from a data which consists of ID , Med, Admin date and Units 4 . In each month separately

how to solve this in excel from a data which consists of ID, Med, Admin date and Units 4. In each month separately (September, October, and November) and also all together across these 3 months, how many patients are switched from Med A to Med B? In each month separately (Sept, Oct, Nov), how many patients are started on Med B having not been on Med A before? 5. In each month separately (September, October, and November) and across all 3 months, for patients switched to Med B, what is the average number of weeks the patients were on Med A before being switched to Med B?(see time on medication definition below)6. What is the average total monthly dose per patient per month (in patients that switched) of Medication A before switching to Medication B (use time from question 5)? What is the average total monthly dose per patient per month of Medication B (in patients that switched assume Med B dose is for 1 month)?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!