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.
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%?
Attention:Complete the answers and embedded Excel analysis as a Microsoft Word management report.
Albright, S. C., & Winston, W. L. (2017). Business analytics: Data analysis and decision making (6th ed.). Stamford, CT: Cengage Learning.
Chapter 4, “Probability and Probability Distributions”
Chapter 5, “Normal, Binomial, Poisson, and Exponential Distributions”
Fulton, L. V., Mendez, F. A., Bastian, N. D., & Musal, R. M. (2012). Confusion between odds and probability, a pandemic? Journal of Statistics Education, 20(3), 1–20.
Note: Retrieved from the Walden Library databases.
https://support.microsoft.com/en-us/office/statistical-functions-reference-624dac86-a375-4435-bc25-76d659719ffd
https://youtu.be/RQ9VOaWxDFo Exponential function
https://youtu.be/MRxnYidPzlo Normal distribution function
