Overview

In this assignment, you will calculate statistics for this scenario and write an essay to answer the questions presented. Include both, your calculations and your essay in your assignment.

Scenario

Vila Health has been working on a new billing system to be deployed to all hospitals. Before they release the billing system to all hospitals, they have deployed it to Cengaly Hospital first. With the older billing system, the hospital system mostly had payments from their patients taking 40 days or more. Vila Health hopes that with the new billing system, it will substantially reduce the amount of time it takes patients to make their payments.

There is a random sample of 65 invoices from 15025 invoices that were processed in the first two months of the new system's operation. If the sample can be used to establish that the new billing system substantially reduces payment time, Vila Health does plan to quickly deploy it to the other hospitals within their system.

By looking at the payment times, we can see that the shortest payment time is 10 days and that the longest is 29 days. This does nottell us much information so it is important to perform a frequency distribution of the data and then graph the distribution by constructing a histogram.

InstructionsCalculations

For this assignment, the dataset is available as Invoice Day and Amount [CSV] of the invoice payment days and the amount:

1. Determine the frequency distribution and construct the histogram:
   • Find the number of classes.
   • Find the class length.
   • Form the non-overlapping classes of equal width by defining the boundaries of the classes.
   • Tally and count the number of measurements in each class.
   • Graph the histogram.
2. Determine the skewness and kurtosis of the payment days.
3. Calculate the correlation between the payment days and the amount owed.

Essay

1. Explain how the correlation calculation shows the correlationbetween payment days and the amount owed.
2. Explain if the new billing system is more efficient than the old billing system based on the sample of the new system.

Your assignment will be graded on the following criteria:

• Create the frequency distribution and histogram.
• Explain the skewness and kurtosis on the sample data set.
• Calculate the correlation of two variables.
• Explain how the correlation calculation shows the correlation between two variables.
• Explain if one billing system approach is more efficient than another based upon statistical analysis of a data set.
• Provide a logical argument in support of conclusions or recommendations.

Refer to the Additional Statistics rubric for details.