# MEDICARE OVERBILLING ANALYSIS

Your company is running a Medicare audit on Sleaze Hospital. Because Sleaze has a history of overbilling, the focus of your audit is on checking whether the billing amounts are correct. Assume that each invoice is for too high an amount with probability 0.06 and for too low an amount with probability 0.01 (so that the probability of a correct billing is 0.93). Also, assume that the outcome for any invoice is probabilistically independent of the outcomes for other invoices.

## probability Question using Excel

- For this Assignment, reflect on the case presented. Think about what

strategies you might use to calculate associated probabilities for

Sleaze Hospital, and then address the series of questions for the

completion of the Assignment. - If you randomly sample 200 of Sleaze's invoices, what is the

probability that you will find at least 15 invoices that overcharge

the customer? What is the probability you won't find any that

undercharge the customer? - Find an integer, k, such that the probability is at least 0.99 that

you will find at least k invoices that overcharge the customer.

(Hint: Use trial and error with the BINOMDIST function to find k.)

Suppose that when Sleaze overcharges Medicare, the distribution of

the amount overcharged (expressed as a percentage of the correct

billing amount) is normally distributed with mean 15% and standard

deviation 4%. - What percentage of overbilled invoices are at least 10% more than

the legal billing amount? What percentage of all invoices are at

least 10% more than the legal billing amount? - If your auditing company samples 200 randomly chosen invoices, what

is the probability that it will find at least five where Medicare

was overcharged by at least 10%? - Submit your answers and embedded Excel analysis as a Microsoft Word

management report.