1. In Health Administration Programs conducting satisfaction surveys are usually covered in courses on quality improvement.

• 1.
  In Health Administration Programs conducting satisfaction
  surveys are usually covered in courses on quality improvement. This
  exercise shows how datafrom satisfaction surveys
  can be analyzed over time. Assume that, in different time periods, 4 randomly
  selected patients rated their satisfaction with our services. Are we
  improving?

  o Please use the following peer
  video as
  a reference for this question. You can find the solution here

  In Health Administration
  programs accounting courses typically cover cost data. Forensic
  accounting examines tries to detect fraud through accounting procedures. The
  following data were
  obtained regarding the cost of taking care of patients over several time
  periods. Are our costs within expectation?

  o Please use the following peer
  video as
  a reference for this question. You can find the solution here

  Payment reform has made
  hospital payments more complex. One issue in payment reform is whether
  the net payments to hospitals are decreasing because of numerous carve-outs for
  never-events. In health administration programs, payment reform is
  covered in several courses including courses on value-based payments, finance,
  quality and strategic planning. In this assignment, examine if payments
  for AMI have declined over 4 time periods indicated in the table below.
  Visit the following link to download the files
  listed below. Keep in mind that start and end periods of data are also
  given inside the files and that these do not correspond to the reporting year.
  Also, note that the name of variables and files change over the years.

• In these files the denominator indicates the number of patients. Payment indicates average payment per patient. Select data for hospitals that had at least 100 patients. Submit an Excel file containing the control chart for the data.

In order to complete this assignment, you must submit an Excel file with each question answered in a separate sheet. Copy both the question prompts and your answers to the file. All calculations should be done by formulas and not as fixed values.