Question

Develop a 700-word report 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?

PayTime Data
22
19
16
18
13
16
29
17
15
23
18
21
16
10
16
22
17
25
15
21
20
16
15
19
18
15
22
16
24
20
17
14
14
19
15
27
12
17
25
13
17
16
13
18
19
18
14
17
17
12
23
24
18
16
16
20
15
24
17
21
15
14
19
26
21

*Please give me step by step instructions on how to complete each step on excel. This is the help I need. I need to create the excel document with these calculations. Thanks!

Answer 1

Data entirely pasted in excel's A column

Formulas to calculate above values below

Hope the above answer has helped you in understanding the problem. Please upvote the ans if it has really helped you. Good Luck!!