Question: I need assistant on this problem. I just received help on how to another problem out but not sure if this is the same way.
I need assistant on this problem. I just received help on how to another problem out but not sure if this is the same way. Please advise. Thanks!
After discussing the issue with you and others in the Finance department, the manager decided to change the payment terms for Accounts Receivable. The payment time remained at 14 days, but the penalty for late payments was increased.
After about 3 months under the new payment terms, you asked the manager to collect a second stratified random sample.
These is the data that I used
Old New Difference in Payment times
Payment Payment
Times Times
(in days) (in days)
1 Week 1 14 12 2
2 13 13 0
3 11 11 0
4 14 14 0
5 13 15 -2
6 19 14 5
7 Week 2 12 16 -4
8 18 14 4
9 13 12 1
10 16 15 1
11 15 16 -1
12 17 13 4
13 Week 3 15 14 1
14 16 12 4
15 18 16 2
16 16 13 3
17 13 18 -5
18 Week 4 27 21 6
19 25 20 5
20 23 22 1
21 26 23 3
22 23 19 4
23 27 21 6
24 Week 5 21 14 7
25 12 11 1
26 14 15 -1
27 15 13 2
28 13 14 -1
29 11 12 -1
30 Week 6 14 11 3
31 19 17 2
32 19 18 1
33 18 15 3
34 14 17 -3
35 19 17 2
36 Week 7 18 16 2
37 22 21 1
38 20 19 1
39 23 17 6
40 24 21 3
41 22 24 -2
42 Week 8 28 18 10
43 26 20 6
44 25 19 6
45 27 22 5
46 29 25 4
This is the information that I worked out in Excel
(in +H9:I26days)
Mean 16.52173913
Standard Error 0.552324146
Median 16
Mode 14
Standard Deviation 3.746044613
Sample Variance 14.03285024
Kurtosis -0.731516467
Skewness 0.427395547
Range 14
Minimum 11
Maximum 25
Sum 760
Count 46
Largest(1) 25
Smallest(1) 11
Confidence Level(95.0%) 1.112437933
t-Test: Two-Sample Assuming Equal Variances
14 12
Mean 18.73333333 16.62222222
Variance 27.83636364 13.87676768
Observations 45 45
Pooled Variance 20.85656566
Hypothesized Mean Difference 0
df 88
t Stat 2.192708762
P(T<=t) one-tail 0.015483242
t Critical one-tail 1.291245948
P(T<=t) two-tail 0.030966484
t Critical two-tail 1.662354029
Please advise on how to do this explanation and if the six step process needs to be used. Thanks!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
