Question
Question 1 Dataset, creditpromo: An analyst at a retail department store wants to evaluate a recent credit card promotion. To this end, 500 cardholders were
Question 1 Dataset, creditpromo:
An analyst at a retail department store wants to evaluate a recent credit card promotion. To this end, 500 cardholders were randomly selected. Half received an ad promoting a reduced interest rate on purchases make over the next three months, and half received a standard seasonal ad.
Dataset coding: id= Customer ID insert = type of promotion received. 0 = standard seasonal ad, 1 = reduced interest rate ad dollars = amount spent during promotional period. For example - Customer with ID 572 spent $ 1403,81 over the 3 month period of the promotion.
Question: Using SPSS software and the appropriate statistical test, is there a significant difference between the spending patterns between the two groups
id | insert | dollars |
148 | 0 | 2232.77 |
572 | 1 | 1403.81 |
973 | 0 | 2327.09 |
1096 | 0 | 1280.03 |
1541 | 1 | 1513.56 |
1947 | 1 | 1729.63 |
2001 | 1 | 1609.71 |
2130 | 0 | 1476.62 |
2616 | 0 | 1460.77 |
2886 | 1 | 1854.49 |
3340 | 0 | 1495.29 |
3400 | 1 | 1107.21 |
3539 | 0 | 1949.59 |
3730 | 1 | 2144.65 |
3906 | 1 | 784.08 |
3924 | 1 | 1409.66 |
3962 | 0 | 1856.95 |
4465 | 1 | 2226.12 |
4900 | 0 | 1470.68 |
5126 | 0 | 1567.24 |
5731 | 0 | 1627.40 |
5945 | 1 | 1869.39 |
6362 | 1 | 1629.10 |
6486 | 1 | 2006.78 |
6501 | 1 | 2096.78 |
6651 | 1 | 1445.53 |
6802 | 1 | 1887.14 |
7294 | 0 | 1903.64 |
7355 | 0 | 1696.94 |
7659 | 1 | 1644.57 |
7820 | 0 | 1334.26 |
8113 | 1 | 1668.49 |
8213 | 1 | 1154.14 |
9586 | 1 | 1856.25 |
9864 | 1 | 1612.23 |
9917 | 1 | 1655.10 |
11365 | 0 | 2032.94 |
11702 | 1 | 1555.94 |
11759 | 1 | 1761.03 |
12207 | 0 | 1766.63 |
12363 | 1 | 1835.17 |
12494 | 0 | 1987.13 |
13387 | 1 | 1251.48 |
13960 | 0 | 1876.32 |
14351 | 1 | 1647.97 |
14635 | 0 | 1364.74 |
15336 | 1 | 1988.14 |
15520 | 1 | 1969.48 |
15694 | 1 | 2334.90 |
15768 | 1 | 1093.11 |
15841 | 0 | 1479.35 |
16334 | 1 | 1503.77 |
16568 | 0 | 1775.44 |
16796 | 0 | 1107.79 |
16970 | 0 | 2149.39 |
17036 | 1 | 1248.61 |
17086 | 1 | 788.06 |
17205 | 0 | 1334.18 |
17545 | 1 | 1932.53 |
17550 | 0 | 1084.51 |
17686 | 1 | 1531.88 |
17867 | 1 | 1425.07 |
17884 | 1 | 1872.12 |
18382 | 0 | 2149.71 |
18610 | 0 | 806.04 |
19586 | 1 | 1283.32 |
20766 | 0 | 1564.83 |
21069 | 0 | 1615.41 |
21162 | 1 | 1668.66 |
21316 | 1 | 1493.32 |
21411 | 0 | 844.37 |
21802 | 0 | 1563.50 |
21847 | 0 | 1442.46 |
21999 | 1 | 961.97 |
22183 | 0 | 1147.48 |
22318 | 1 | 1724.96 |
22454 | 0 | 1521.44 |
22681 | 1 | 1742.34 |
22702 | 1 | 1317.36 |
22797 | 0 | 1526.62 |
22825 | 0 | 1369.44 |
23058 | 1 | 926.66 |
23187 | 0 | 1058.08 |
23226 | 0 | 1272.34 |
23529 | 1 | 1657.76 |
23583 | 1 | 1702.68 |
24926 | 1 | 1857.50 |
25202 | 1 | 1197.32 |
25427 | 0 | 1326.16 |
26275 | 0 | 1794.50 |
26527 | 1 | 1186.31 |
26745 | 0 | 1245.85 |
27401 | 1 | 1301.35 |
27849 | 1 | 2180.45 |
27902 | 0 | 1539.83 |
28646 | 1 | 2152.12 |
29450 | 1 | 1558.75 |
29861 | 1 | 1024.06 |
29976 | 1 | 1818.90 |
29995 | 0 | 1809.45 |
30254 | 0 | 2112.64 |
30370 | 1 | 1949.54 |
30676 | 1 | 1921.23 |
30728 | 1 | 1293.02 |
30744 | 0 | 2111.49 |
31512 | 0 | 1537.36 |
31581 | 1 | 1496.17 |
32240 | 0 | 1114.43 |
32311 | 1 | 1020.85 |
32433 | 1 | 1335.42 |
32841 | 0 | 1512.02 |
32920 | 0 | 1718.49 |
32961 | 0 | 1415.53 |
33069 | 1 | 1705.88 |
33323 | 0 | 1431.91 |
33386 | 0 | 1596.86 |
33433 | 0 | 1161.08 |
33523 | 1 | 1993.31 |
33925 | 1 | 1331.24 |
33958 | 1 | 1801.60 |
34221 | 1 | 1920.18 |
34458 | 0 | 1878.37 |
34556 | 1 | 2154.47 |
34606 | 0 | 1521.88 |
34659 | 1 | 2182.23 |
34739 | 0 | 1405.70 |
35113 | 1 | 1293.09 |
35295 | 0 | 1813.78 |
35735 | 1 | 2021.11 |
36018 | 0 | 1892.45 |
36083 | 1 | 1722.57 |
36476 | 1 | 1709.16 |
37369 | 0 | 1948.88 |
37732 | 0 | 1417.59 |
37767 | 0 | 2174.24 |
38195 | 1 | 1229.06 |
38359 | 1 | 1257.92 |
38535 | 0 | 1670.26 |
38746 | 0 | 1676.36 |
39105 | 0 | 1489.34 |
39155 | 1 | 1751.57 |
39171 | 0 | 1501.17 |
39501 | 0 | 1505.67 |
39744 | 1 | 1635.82 |
39838 | 0 | 1375.44 |
39856 | 0 | 1360.23 |
40132 | 1 | 1500.69 |
40233 | 1 | 1294.39 |
40501 | 0 | 2251.41 |
40857 | 0 | 1427.76 |
41045 | 0 | 911.47 |
41095 | 1 | 1297.83 |
41140 | 1 | 2054.84 |
41370 | 1 | 1337.27 |
41489 | 0 | 1416.50 |
41955 | 1 | 1470.23 |
41974 | 1 | 1664.40 |
42254 | 0 | 1549.88 |
42459 | 0 | 1707.59 |
42507 | 0 | 1662.75 |
42620 | 1 | 1733.25 |
42782 | 1 | 2236.35 |
42978 | 0 | 1211.93 |
43681 | 0 | 1268.61 |
43788 | 0 | 1881.39 |
44295 | 1 | 1543.24 |
44621 | 0 | 1468.52 |
44649 | 1 | 1430.57 |
44662 | 0 | 1962.03 |
45790 | 0 | 1304.11 |
45853 | 0 | 1587.83 |
45888 | 1 | 2181.44 |
46212 | 1 | 1481.03 |
46281 | 1 | 1703.43 |
46402 | 1 | 1770.78 |
46465 | 1 | 1738.04 |
46886 | 1 | 2250.77 |
47037 | 0 | 1228.80 |
47093 | 1 | 1773.03 |
47183 | 0 | 1468.81 |
47321 | 0 | 1777.90 |
47874 | 1 | 1447.59 |
47875 | 0 | 1938.57 |
48051 | 0 | 1815.76 |
48311 | 0 | 1339.15 |
48693 | 1 | 1920.90 |
48717 | 1 | 1142.48 |
48799 | 0 | 1422.44 |
49290 | 0 | 1278.97 |
49678 | 0 | 1212.80 |
49698 | 1 | 1629.81 |
50933 | 0 | 728.51 |
51000 | 1 | 1320.96 |
51022 | 0 | 1932.99 |
51565 | 0 | 1828.80 |
52235 | 0 | 1332.03 |
52309 | 1 | 1875.82 |
52670 | 0 | 1501.18 |
52791 | 0 | 1214.45 |
53180 | 0 | 1220.74 |
53302 | 0 | 1699.01 |
53357 | 1 | 1980.03 |
53421 | 0 | 1490.75 |
53502 | 1 | 1566.06 |
54285 | 0 | 1649.00 |
54451 | 0 | 1971.75 |
54867 | 1 | 2191.42 |
54896 | 0 | 1427.82 |
55106 | 0 | 848.28 |
55360 | 1 | 1784.32 |
55518 | 0 | 1279.06 |
55607 | 1 | 2160.95 |
55974 | 1 | 1590.90 |
56231 | 1 | 1417.74 |
56240 | 1 | 2030.03 |
56390 | 1 | 1675.38 |
56487 | 0 | 2713.03 |
56662 | 1 | 1323.77 |
56721 | 0 | 961.42 |
56830 | 1 | 1878.10 |
57507 | 1 | 1540.17 |
58412 | 0 | 1993.07 |
58440 | 0 | 1398.32 |
58563 | 1 | 1837.06 |
58636 | 0 | 1606.41 |
58768 | 0 | 1585.94 |
58900 | 1 | 2000.09 |
58967 | 1 | 1234.67 |
58968 | 0 | 1364.47 |
59298 | 1 | 1254.65 |
59605 | 1 | 1450.44 |
59886 | 0 | 1576.19 |
60038 | 0 | 1629.78 |
60156 | 1 | 1424.09 |
60236 | 0 | 1633.90 |
60561 | 0 | 1645.33 |
60672 | 1 | 1761.52 |
60812 | 0 | 1286.85 |
60850 | 1 | 1111.60 |
60865 | 0 | 1979.73 |
60926 | 0 | 1260.41 |
60999 | 1 | 1006.98 |
61050 | 1 | 1158.30 |
61393 | 0 | 1514.50 |
61463 | 0 | 894.49 |
62278 | 1 | 993.07 |
62296 | 1 | 1694.11 |
62406 | 1 | 1861.46 |
62504 | 1 | 1469.62 |
62902 | 0 | 1859.85 |
63353 | 1 | 1897.26 |
63383 | 1 | 1414.65 |
63540 | 0 | 1058.08 |
63583 | 1 | 1329.25 |
63762 | 1 | 1602.95 |
64012 | 0 | 1569.37 |
64737 | 1 | 1524.03 |
65796 | 0 | 1484.28 |
66477 | 1 | 1331.73 |
66949 | 0 | 1896.84 |
67033 | 1 | 1817.07 |
67037 | 1 | 1805.13 |
67532 | 0 | 1495.25 |
68290 | 0 | 1613.22 |
68633 | 0 | 1488.59 |
68675 | 1 | 1574.02 |
68778 | 1 | 1669.04 |
69155 | 1 | 1971.90 |
69207 | 0 | 1253.23 |
69223 | 1 | 1389.08 |
69283 | 1 | 2002.44 |
69393 | 0 | 1167.36 |
69809 | 0 | 1530.05 |
70293 | 1 | 1674.47 |
70377 | 1 | 1648.67 |
70777 | 0 | 1931.86 |
70852 | 0 | 1902.03 |
71148 | 1 | 1667.42 |
71331 | 1 | 1518.70 |
71384 | 0 | 544.60 |
72011 | 1 | 1510.89 |
72101 | 1 | 1418.02 |
72818 | 0 | 1681.54 |
73729 | 0 | 2273.88 |
73749 | 0 | 2001.30 |
74743 | 1 | 1304.87 |
74807 | 1 | 1138.33 |
75112 | 0 | 1877.69 |
75479 | 0 | 1603.34 |
75496 | 0 | 2210.43 |
75865 | 0 | 1620.34 |
76244 | 1 | 2204.63 |
76656 | 1 | 1730.41 |
76754 | 0 | 1630.01 |
77389 | 1 | 947.66 |
77881 | 1 | 1516.43 |
78180 | 0 | 1529.85 |
78520 | 1 | 1609.69 |
79386 | 1 | 918.35 |
79647 | 0 | 1807.75 |
79723 | 0 | 1639.77 |
79945 | 1 | 1989.10 |
80037 | 1 | 1808.38 |
80345 | 1 | 1153.75 |
80855 | 0 | 810.80 |
81231 | 1 | 1745.64 |
81304 | 1 | 1008.24 |
81647 | 0 | 1409.09 |
81659 | 0 | 1831.91 |
81805 | 1 | 2228.05 |
82140 | 0 | 1634.69 |
82412 | 1 | 2138.00 |
82828 | 1 | 763.10 |
84242 | 1 | 1598.52 |
84456 | 0 | 2047.49 |
84634 | 0 | 1685.44 |
85074 | 1 | 1695.36 |
85100 | 1 | 745.65 |
85775 | 0 | 1840.55 |
86204 | 0 | 1603.48 |
86317 | 0 | 1475.98 |
86911 | 0 | 1272.25 |
87488 | 0 | 1250.38 |
87636 | 0 | 1474.78 |
87695 | 1 | 2158.61 |
88480 | 0 | 2064.89 |
88515 | 0 | 2030.87 |
88541 | 0 | 1214.56 |
88601 | 1 | 1540.81 |
89927 | 0 | 1712.73 |
90075 | 1 | 2315.43 |
90169 | 0 | 1034.58 |
90219 | 0 | 1451.89 |
90396 | 1 | 1873.21 |
91195 | 1 | 1645.40 |
91294 | 0 | 1623.61 |
91462 | 1 | 895.71 |
91806 | 0 | 2001.77 |
92146 | 1 | 1020.24 |
92214 | 0 | 1566.88 |
92499 | 0 | 1414.09 |
92631 | 0 | 1448.89 |
92795 | 1 | 1770.02 |
92851 | 1 | 2191.50 |
93070 | 1 | 1778.76 |
93113 | 0 | 2200.87 |
93205 | 0 | 1587.34 |
93241 | 1 | 1201.46 |
94014 | 1 | 1781.39 |
94394 | 1 | 1562.01 |
94751 | 1 | 2048.84 |
94977 | 0 | 1121.07 |
95331 | 1 | 2444.14 |
95552 | 0 | 1252.98 |
95899 | 1 | 1584.14 |
96063 | 0 | 1736.85 |
96185 | 1 | 1552.17 |
96308 | 0 | 1692.66 |
96353 | 0 | 1422.01 |
96379 | 1 | 1975.27 |
97355 | 0 | 1407.98 |
97990 | 1 | 1406.47 |
98218 | 0 | 1927.35 |
98249 | 0 | 1660.04 |
98865 | 0 | 1629.30 |
98882 | 1 | 1443.45 |
99250 | 1 | 2074.11 |
99526 | 1 | 1739.01 |
100164 | 0 | 1140.48 |
100359 | 0 | 1715.45 |
100996 | 0 | 1567.94 |
101160 | 0 | 1467.43 |
101320 | 0 | 1713.91 |
101492 | 0 | 770.01 |
102034 | 1 | 2138.09 |
103208 | 0 | 1791.74 |
103878 | 1 | 1960.25 |
103952 | 1 | 2080.13 |
104019 | 1 | 1913.88 |
104302 | 0 | 1426.91 |
104396 | 1 | 1101.54 |
104503 | 0 | 1201.10 |
104546 | 1 | 1358.64 |
104566 | 1 | 1666.15 |
104589 | 0 | 2007.40 |
104913 | 0 | 1256.19 |
105338 | 0 | 1689.85 |
105360 | 1 | 1585.55 |
105508 | 1 | 860.14 |
105644 | 0 | 1603.74 |
105652 | 1 | 1736.46 |
105912 | 0 | 1711.35 |
106118 | 0 | 1634.60 |
106170 | 1 | 1831.88 |
106180 | 1 | 1520.60 |
106544 | 0 | 1279.00 |
107260 | 0 | 817.89 |
107262 | 1 | 2166.18 |
107400 | 0 | 2303.63 |
107563 | 0 | 1109.49 |
108107 | 1 | 1712.42 |
108368 | 1 | 2139.89 |
108615 | 1 | 1390.34 |
108806 | 0 | 2122.55 |
108846 | 1 | 1576.91 |
109555 | 0 | 2072.08 |
109862 | 0 | 1414.35 |
109959 | 1 | 2018.59 |
110067 | 0 | 1690.10 |
110557 | 1 | 2179.41 |
111467 | 1 | 1357.85 |
111587 | 0 | 1471.37 |
112265 | 1 | 1767.50 |
112367 | 1 | 2015.52 |
112481 | 1 | 1834.73 |
112539 | 1 | 1925.47 |
112620 | 0 | 1857.23 |
113027 | 0 | 1061.71 |
113120 | 1 | 1788.29 |
113396 | 1 | 1531.29 |
113586 | 1 | 1701.31 |
113684 | 1 | 1929.75 |
113910 | 0 | 1484.09 |
114128 | 1 | 1280.42 |
114282 | 1 | 1498.08 |
114347 | 0 | 1627.78 |
114874 | 0 | 1718.79 |
115318 | 0 | 875.56 |
115409 | 0 | 1790.24 |
115537 | 0 | 1386.57 |
116086 | 0 | 1560.18 |
116121 | 1 | 1049.52 |
116182 | 0 | 1770.95 |
116479 | 1 | 1917.89 |
117191 | 1 | 1820.73 |
117444 | 1 | 1579.87 |
117456 | 0 | 1693.09 |
117654 | 1 | 1741.37 |
118011 | 0 | 1563.58 |
118083 | 1 | 1345.80 |
118397 | 0 | 1528.00 |
118404 | 0 | 1225.97 |
118515 | 1 | 2019.61 |
118649 | 1 | 1429.15 |
119217 | 0 | 1369.19 |
119391 | 0 | 2214.43 |
119535 | 0 | 1596.62 |
119716 | 1 | 1829.79 |
119736 | 1 | 1938.81 |
120856 | 0 | 1182.48 |
121130 | 0 | 1325.24 |
121254 | 0 | 1464.76 |
121363 | 1 | 1406.31 |
121566 | 1 | 1810.80 |
121611 | 0 | 2354.06 |
121622 | 1 | 1442.19 |
122076 | 1 | 1837.92 |
122265 | 0 | 1782.73 |
122331 | 1 | 1451.36 |
122401 | 0 | 1732.61 |
122843 | 0 | 967.52 |
122908 | 1 | 1686.29 |
122966 | 0 | 1893.02 |
123085 | 1 | 2196.83 |
123513 | 0 | 1448.63 |
123593 | 0 | 1846.56 |
123824 | 0 | 1443.14 |
124029 | 1 | 1500.23 |
124129 | 0 | 1931.17 |
124138 | 1 | 1578.46 |
124247 | 0 | 1279.99 |
124444 | 0 | 1441.89 |
124463 | 1 | 2637.88 |
124573 | 0 | 1171.05 |
124783 | 0 | 1119.82 |
124795 | 0 | 1544.84 |
125058 | 1 | 2007.31 |
125105 | 0 | 2711.72 |
125416 | 0 | 1624.64 |
125716 | 1 | 1892.60 |
126180 | 1 | 1768.34 |
126217 | 1 | 1384.10 |
126362 | 0 | 1501.74 |
126552 | 0 | 1534.79 |
126831 | 0 | 1459.86 |
127429 | 1 | 1612.07 |
127535 | 1 | 1399.90 |
127695 | 0 | 1577.33 |
128093 | 0 | 2158.36 |
128225 | 1 | 1016.13 |
128993 | 0 | 1336.52 |
129531 | 1 | 2227.46 |
129634 | 1 | 2007.54 |
129779 | 0 | 1330.23 |
130128 | 1 | 2000.05 |
130163 | 1 | 1513.06 |
130204 | 1 | 1020.76 |
130255 | 0 | 1919.86 |
130583 | 0 | 1863.01 |
130682 | 0 | 1295.01 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started