Link to data: https://docs.google.com/spreadsheets/d/1mDCGaeQ8Tj_tk_0BdrsWOIb8t7kaHKweo9o9GgUobyo/edit?usp=sharing

Question 1(a): If Medication A cost $1 for 100 units, what is the breakeven price point for Medication B (per unit of B)?

(b) How much does the average total monthly dose per patient (Medication A and B) change for patients

switched September vs October vs November?

(c) In patients that were switched to Med B, what percent of the 2nd Med B dose (total dose in month

following 1st dose) was the same as the 1st Med B dose? Higher than the 1st dose? Lower than the first dose (but not a zero dose)? No dose at all (a zero dose)? (calculate for patients switched in September only, October only, and Sept and Oct together, assume Med B dose is for 1 month only)

Background:

- XYZ client currently uses Medication A in all their patients and is considering a switch to Medication B. A

critical part of the evaluation of Medication B is how much of Medication B would be used in the XYZ client's patients. A trial of Medication B was conducted. The data in the excel file encompasses roughly 130 patients with data at least 2 months before switching medications and up to 3 months on the new medication.

- Patients can be on medication A or medication B or neither medication, but not both medications at the same time

Medication B is given less frequently (~1/month) than Medication A

- The units of Medication A and Medication B are different and are not interchangeable or able to be converted from one to another

- For time on medication, assume the patient is "on" Med A from the first recorded date of Med A administration until the last recorded date of Med A administration

- Assume a week is 7 days and a month is 4.33 weeks