Develop a summary in the text boxes including the following calculations and using the information to determine whether the new billing system has reduced the mean bill payment time: - Essay Prowess

# Develop a summary in the text boxes including the following calculations and using the information to determine whether the new billing system has reduced the mean bill payment time:

The Payment Time Case

•

The purpose of the assignment is to develop students’ abilities in using datasets to apply the concepts of sampling distributions and confidence intervals to make management decisions.

Assignment Steps

Resources: Microsoft Excel®, The Payment Time Case Study, The Payment Time Case Data Set (Please create a text box for each within Microsoft Excel to complete this objective)

Review the Payment Time Case Study and Data Set.

Develop a summary in the text boxes including the following calculations and using the information to determine whether the new billing system has reduced the mean bill payment time:

• Assuming the standard deviation of the payment times for all payments is 4.2 days, construct a 95% confidence interval estimate to determine whether the new billing system was effective. State the interpretation of 95% confidence interval and state whether or not the billing system was effective.
• Using the 95% confidence interval, can we be 95% confident that µ ≤ 19.5 days?
• Using the 99% confidence interval, can we be 99% confident that µ ≤ 19.5 days?
• If the population mean payment time is 19.5 days, what is the probability of observing a sample mean payment time of 65 invoices less than or equal to 18.1077 days?