Monthly Credit Card charges
December January
1545.24 903.07
4302.19 7208.16
4227.61 4242.62
202.81 79.93
3297.71 4046.26
874.73 89.16
3810.51 3291.06
1935.26 2418.75
99.13 83.92
504.72 6.42
410.88 0.00
683.25 564.36
2159.04 2714.58
1123.46 187.11
2509.71 3268.75
1835.18 1523.58
9.95 1360.31
2334.13 732.98
78.55 75.13
101.29 70.22
598.12 633.81
648.44 1041.91
236.13 553.81
1265.72 1016.92
2124.07 1304.08
3.66 249.42
305.91 48.73
1902.23 871.78
559.02 485.04
2448.35 616.27
2799.41 1574.17
531.39 422.91
537.22 769.43
767.24 56.58
1960.36 1486.88
1678.03 495.83
2065.72 1065.31
396.98 509.98
5638.43 5642.07
5.49 5.49
2281.35 870.51
3820.83 1635.03
89.12 92.11
1452.02 669.24
527.51 829.42
105.82 69.17
1404.59 831.15
4230.41 2303.44
633.76 270.25
970.53 210.46
347.97 1011.22
0.00 1045.12
49.99 298.23
30.03 -30.03
471.71 1634.75
1116.85 1733.45
70.68 0.00
31.09 31.41
4.95 4.95
2521.25 1088.33
16.98 26.87
40.53 120.25
258.76 2009.24
122.96 291.37
0.00 104.07
109.85 53.03
5057.31 2839.77
3674.02 675.28
139.79 221.74
76.03 37.78
3150.77 533.34
2989.53 1934.23
651.22 693.13
9123.04 6804.04
916.57 393.25
2874.06 1307.14
796.93 796.71
34.58 0.00
44.15 1040.62
478.46 565.41
762.18 339.48
2351.16 5276.09
44.23 40.08
43.26 43.36
1340.74 652.81
1127.72 1071.79
2801.32 2336.48
52.14 91.53
1295.39 1433.79
328.67 719.61
28.34 28.62
598.55 980.86
4277.96 1577.65
567.55 0.00
479.26 161.93
1617.14 493.71
285.37 533.99
1285.69 462.06
3761.52 1477.76
Excel output:
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.784308036 | |||||
R Square | 0.615139095 | |||||
Adjusted R Square | 0.611171456 | |||||
Standard Error | 874.5508582 | |||||
Observations | 99 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 1 | 118579989.3 | 118579989.3 | 155.0391 | 7.89731E-22 | |
Residual | 97 | 74189402.74 | 764839.2035 | |||
Total | 98 | 192769392 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 120.7405259 | 115.5862952 | 1.044592057 | 0.298808 | -108.6662742 | 350.1473259 |
December | 0.699497556 | 0.056177909 | 12.45147019 | 7.9E-22 | 0.587999958 | 0.810995154 |
From probability plot, we see that normality assumption holds. From residual plot we see that as fitted value increases the absolute value of residual also increases. Hence the equal spread conditions are not satisfied.
Option: B.
(c) Minitab output:
Predicted Values for New Observations
New Obs Fit SE Fit 95% CI 95% PI
1 1519.74 95.5 (1330.24, 1709.24) (-226.32, 3265.79)
Answer: ($1330.24, $1709.24).
(d) Answer: (-$226.32, $3265.79)
(e) Option D.
Monthly Credit Card charges December January 1545.24 903.07 4302.19 7208.16 4227.61 4242.62 202.81 79.93 3297.71 4046.26...
Spending on credit cards decreases after the Christmas spending season (as measured by amount charged on a credit card in December). The accompanying data set contains the monthly credit card charges of a random sample of 99 cardholders. Complete parts a) through e) below 囲Click the icon to view the monthly credit card charges A. All of the conditions are definitely satisfied B. The Randomization Condition is not satisfied. C. The Equal Spread Condition is not satisfied. D. The Nearly...
January February 902.79 640.77 7208.82 4571.22 4240.01 2271.57 79.89 299.69 4038.81 1376.69 89.24 −120.78 3290.41 1928.63 2418.77 2609.13 83.87 144.74 6.42 393.11 0.00 40.41 564.15 295.64 2714.19 850.07 187.25 162.07 3266.22 2411.62 1525.08 957.05 1358.98 38.013 733.71 2656.94 75.12 64.94 70.27 −70.21 633.98 1860.28 1040.93 478.78 554.05 995.75 1016.82 774.36 1304.09 3364.08 249.63 5.53 48.71 96.94 871.96 890.94 485.52 485.28 616.84 1486.08 1572.31 890.16 422.54 392.15 769.75 323.26 56.55 0.00 1486.28 2253.16 495.57 389.88 1064.46 1065.19 510.06 131.43 5646.18 4950.25...
December January 1543.47 903.06 4296.15 7207.24 4229.96 4236.85 202.69 79.99 3296.93 4041.82 873.21 89.25 3812.03 3289.29 1932.82 2418.49 99.17 83.92 503.97 6.42 411.05 0.00 682.55 564.45 2161.01 2712.73 1124.99 186.99 2507.68 3262.37 1837.64 1525.17 9.94 1360.49 2333.51 733.98 78.63 75.08 101.31 70.26 598.44 634.39 648.23 1042.22 235.96 554.09 1267.16 1016.15 2124.18 1304.17 3.66 249.61 306.05 48.73 1900.26 872.97 559.58 485.61 2445.76 616.65 2799.59 1575.21 531.44 422.63 537.23 770.56 766.99 56.54 1959.23 1485.17 1679.34 495.98 2064.97 1065.45 396.87 510.34 5637.86 5646.55...
Financial analysts know that January credit card charges will generally be much lower than those of the month before. What about the difference between January and the next month? Does the trend continue? The accompanying data set contains the monthly credit card charges of a random sample of 99 cardholders. Complete parts a) through e) below. Click the icon to view the monthly credit card charges. a) Build a regression model to predict February charges from January charges. Feb =...
January February 904.26 641.28 7214.25 4569.29 4234.27 2267.96 79.94 299.72 4043.51 1376.97 89.34 -120.83 3291.24 1927.78 2418.33 2610.63 83.88 144.81 6.42 392.68 0 40.48 564.23 295.82 2715.11 848.78 187.15 162.09 3265.33 2411.81 1525.05 956.79 1359.03 38.01 733.88 2657.81 75.16 64.89 70.26 -70.25 634.37 1860.98 1041.29 478.41 553.33 994.54 1016.79 774.13 1305.45 3365.66 249.35 5.54 48.79 96.89 872.19 890.51 485.45 485.61 616.27 1484.08 1573.04 889.57 422.45 391.95 770.17 323.65 56.54 0 1484.99 2253.41 495.42 389.59 1065.47 1066.84 510.79 131.48 5647.13 4946.21...
Suppose hat on January 1 you have a balance of $5900 on a credit card whose APRIs 15%, which you want o pay ofin 1 year. Assume that you make no additional charges the card after January 1 a. Calculate your monthly payments b. When the card is paid off, how much will you have paid since January 1? c. What percentage of your total payment from part (b) is interest? a. The monthly payment is s Do not round...
Suppose that on January 1 you have a balance of $6200 on a credit card whose APR is 14%, which you want to pay off in 1 year. Assume that you make no additional charges to the card after January 1. a. Calculate your monthly payments. b. When the card is paid off, how much will you have paid since January 1? c. What percentage of your total payment from part(b) is interest? a. The monthly payment is $ (Do...
4.D.29 Suppose that on January 1 you have a balance of $6000 on a credit card whose APR is 17%, which you want to pay off in 1 year. Assume that you make no additional charges to the card ather January 1 a. Calculate your monthly payments. b. When the card is paid off, how much will you have paid since January 1? c. What percentage of your total payment from part(b) is interest? a. The monthly payment is $...
Suppose that on January 1 you have a balance of $4700 on a credit card whose APR is 16%, which you want to pay off in 1 year. Assume that you make no addition al charges to the card after January 1 a. Calculate your monthly payments. b. When the card is paid off, how much will you have paid since January 1? c. What percentage of your total payment from part (b) is interest? a. The monthly payment is...
Here is Lashonda's credit card statement for the month of December. Date Transaction December 1 Beginning balance December 4 Payment December 13 Purchase December 24 Payment Transaction amount $1700.09 $340.00 $61.95 $800.00 (a) Use the credit card statement to help fill in the table below. Note that there are 31 days in December. Also, a purchase increases the unpaid balance, and a payment decreases the unpaid balance. Date Transaction Unpaid balance Number of days December 1 $5100.27 Beginning balance Payment...