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

1. 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.
2. 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?
3. 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%.
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?
5. 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%?
6. Submit your answers and embedded Excel analysis as a Microsoft Word
   management report.