Independent Sample t test

Using the credit card data that appears on the next tab, analyze Airline Spend.

Perform two t-tests to determine if there is a difference in your spending category based on Card Type or Reward Type.
Do people who get World Points spend more than those who get Gas Rebates on your Spend type?
Do people with Master Cards spend more than those with Visa Cards on your Spend type?

Gas Spend Hotel Transactions Hotel Spend Total Quarterly Payments Card Type Balance Credit Line CreditCategory Reward Type
25.61 3 517.99 650 MC 364.01 700 Low GAS REBATE
9.99 3 1408.29 1240 MC 751.72 1000 Low GAS REBATE
17.29 3 383.72 591.64 MC 211.18 1000 Low GAS REBATE
46.12 3 5931.51 59 MC 1145.85 1200 Low GAS REBATE
20 2 216.99 403.46 MC 439.33 1500 Low GAS REBATE
1484.03 9 391.66 674.67 VS 145.04 1500 Low WORLDPOINTS
8.89 2 39.9 420 MC 68.53 2000 Low GAS REBATE
26.99 2 192.86 300 MC 1088.69 2000 Low GAS REBATE
1221.4 5 1937.7 1500 VS 1036.24 2100 Low WORLDPOINTS
32.51 2 182.77 2859.03 MC 298.43 2500 Low GAS REBATE
32.13 2 244.26 91 MC 2409.05 2500 Low GAS REBATE
16.75 16 2108.27 440 VS 1894.97 2500 Low WORLDPOINTS
69.85 3 415.8 53.85 MC 703.44 2700 Low GAS REBATE
20.05 3 155.04 931.65 MC 157.26 3000 Low GAS REBATE
45.5 3 149.47 760 MC 2898.67 3000 Low GAS REBATE
1332.96 7 2021.69 174 VS 2915.07 3100 Low WORLDPOINTS
1982.95 7 495.42 691.27 VS 0 3300 Low WORLDPOINTS
7.01 3 250.83 0 MC 856.45 3500 Low GAS REBATE
26.66 3 764.73 870.4 MC 674.59 3500 Low GAS REBATE
392.92 5 597.44 2450 VS 1086.93 3500 Low WORLDPOINTS
667.8 4 253.38 601 VS 3772.95 4000 Low GAS REBATE
40.25 2 176 205 MC 3999.94 4200 Low GAS REBATE
5.99 2 153.81 680 MC 4463.02 4400 Low GAS REBATE
462.23 5 894.86 1050 VS 4402.49 4500 Low WORLDPOINTS
33.64 2 113.5 1317 MC 3983.71 4600 Low GAS REBATE
237.18 3 187.92 1300 VS 3257.96 4800 Low GAS REBATE
35.6 2 635.65 1761.51 MC 138.79 5000 Low GAS REBATE
24 2 629.71 598.38 MC 308.51 5000 Low GAS REBATE
30.45 3 0 865.84 MC 292.38 5000 Low GAS REBATE
38 3 413.79 1002.28 MC 0 5000 Low GAS REBATE
175.91 3 576.28 1250 VS 4290.37 5000 Low GAS REBATE
1174.91 5 226.58 0 VS 684 5000 Low WORLDPOINTS
1029.61 7 662.88 500 VS 350.53 5000 Low WORLDPOINTS
65.39 3 2980.95 3456.29 MC 444.8 5300 Low GAS REBATE
1500.23 5 771.07 163.58 VS 1478.86 5500 Low WORLDPOINTS
38.15 3 342.61 2137.38 MC 187.59 5600 Low GAS REBATE
30.18 3 75.33 500 MC 830.38 5600 Low GAS REBATE
38.03 3 652.9 747.45 MC 74.35 6000 Low GAS REBATE
10.16 3 466.5 1967.05 MC 1164.95 6000 Low GAS REBATE
24 15 963.74 1750 VS 2604.6 6000 Low WORLDPOINTS
2531.1 10 1753.82 550 VS 4275.8 6200 Low WORLDPOINTS
631.3 4 254.73 2032.39 VS 203.24 6500 Low GAS REBATE
3320.57 13 1395.71 556.49 VS 572.22 6700 Low WORLDPOINTS
30 3 511.41 974.35 MC 167.72 7000 Low GAS REBATE
30.01 3 222.77 500 MC 3173.31 7000 Low GAS REBATE
2321.33 10 1320.89 500 VS 6923.62 7100 Low WORLDPOINTS
20 2 49.28 1200 MC 5965.4 7400 Low GAS REBATE
30 3 200.53 970.62 MC 147.38 7500 Low GAS REBATE
66.82 3 406.67 180.04 MC 588.93 7500 Low GAS REBATE
156.44 3 205.1 485 VS 3608.28 7500 Low GAS REBATE
1369.6 5 1342.16 718.24 VS 251.77 7500 Low WORLDPOINTS
702.81 5 622.56 1200 VS 7467.95 7500 Low WORLDPOINTS
1622.32 7 482.96 1700 VS 7089.05 7500 Low WORLDPOINTS
18.85 17 2318.94 600 VS 7383.67 7500 Low WORLDPOINTS
2085.48 5 179.79 380 VS 6120.05 7600 Low WORLDPOINTS
921.31 4 806.21 600 VS 5766.12 7800 Low GAS REBATE
21.09 3 274.83 600 MC 6526.32 7900 Low GAS REBATE
893.52 5 128.84 941.32 VS 309.49 7900 Low WORLDPOINTS
1148.82 7 488.91 1105.53 VS 23.2 8000 Low WORLDPOINTS
1194.68 8 791.66 701.8 VS 299.48 8000 Low WORLDPOINTS
2669.49 8 696.97 1746.27 VS 223.22 8000 Low WORLDPOINTS
20 19 2367.87 1308.07 VS 146.86 8000 Low WORLDPOINTS
10.1 3 1428.76 853.58 MC 59.94 8500 Low GAS REBATE
2161.7 5 310.45 458.95 VS 0 8500 Low WORLDPOINTS
39.84 3 659.88 538.33 MC 416.97 8700 Low GAS REBATE
17.72 2 167.36 2000 MC 1904.61 9000 Low GAS REBATE
138 2 52.01 1300 MC 4698.1 9000 Low GAS REBATE
47.33 2 266.56 1005 MC 8892.77 9000 Low GAS REBATE
18.85 2 135.7 190 MC 4814.87 9000 Low GAS REBATE
1117.43 5 574.76 850 VS 6893.02 9000 Low WORLDPOINTS
1307.55 8 321.4 0 VS 696 9000 Low WORLDPOINTS
690.22 10 1617.63 225.06 VS 567 9000 Low WORLDPOINTS
28.51 3 271.46 1750 MC 544.71 9200 Low GAS REBATE
25.39 3 174 1300 MC 5495.89 9500 Low GAS REBATE
1152.01 7 873.24 1579.53 VS 603.03 9500 Low WORLDPOINTS
1260.84 9 1583.3 1014.2 VS 629.48 9500 Low WORLDPOINTS
35.27 2 2062.24 688 MC 9827.05 10000 Medium GAS REBATE
217.97 3 172.45 393.26 VS 192.27 10000 Medium GAS REBATE
701.73 5 447.48 433.69 VS 188.99 10000 Medium WORLDPOINTS
1436.95 7 787.76 3375.28 VS 129.88 10000 Medium WORLDPOINTS
1178.31 8 1150.12 482.47 VS 332 10000 Medium WORLDPOINTS
705 9 703.19 590.61 VS 0 10000 Medium WORLDPOINTS
38.05 3 168.11 375 MC 7807.31 10100 Medium GAS REBATE
20 17 1372.75 580.67 VS 493.04 10200 Medium WORLDPOINTS
44.18 2 323.6 300 MC 813.87 10500 Medium GAS REBATE
95.38 3 393.43 135 VS 2138.99 10500 Medium GAS REBATE
729.19 4 324.49 708.1 VS 508.88 10700 Medium GAS REBATE
9.7 3 264.24 661.6 MC 0 10800 Medium GAS REBATE
31.51 3 291.16 543.93 MC 536.44 11000 Medium GAS REBATE
60 3 206.1 498.37 MC 42.87 11000 Medium GAS REBATE
920.83 7 928.75 409.92 VS 358.47 11000 Medium WORLDPOINTS
6.32 3 903.76 1555 MC 11668.87 11300 Medium GAS REBATE
796.16 5 606.72 821.22 VS 332.03 11500 Medium WORLDPOINTS
1202.63 8 663.72 852 VS 11599.13 11600 Medium WORLDPOINTS
558.3 4 525.03 1245.79 VS 73.26 12000 Medium GAS REBATE
879.89 5 437.78 300 VS 1526.6 12000 Medium WORLDPOINTS
1764.58 9 365.57 680 VS 11912.08 12000 Medium WORLDPOINTS
2819.25 10 705.06 1400 VS 332.75 12000 Medium WORLDPOINTS
2085.1 11 804.41 316.08 VS 124.26 12000 Medium WORLDPOINTS
1104.7 10 1443.74 275 VS 590.93 12200 Medium WORLDPOINTS
810.29 8 412.18 300 VS 5195.71 12300 Medium WORLDPOINTS
97.91 2 1369.21 1912.02 MC 348.2 12500 Medium GAS REBATE
28.03 3 295.16 1467.7 MC 1198.13 12500 Medium GAS REBATE
30.6 3 438.16 507.23 MC 680.93 12500 Medium GAS REBATE
724.49 5 506.83 609.73 VS 685.68 12500 Medium WORLDPOINTS
1170.58 5 354.27 660 VS 9796.13 12500 Medium WORLDPOINTS
1324.14 8 1317.51 870.4 VS 74.7 12500 Medium WORLDPOINTS
18.45 3 395.16 2266.75 MC 13.68 12600 Medium GAS REBATE
120.15 3 588.97 95.62 MC 572.58 12600 Medium GAS REBATE
169.77 3 1114.51 676.58 VS 0 12600 Medium GAS REBATE
19.5 2 1275.89 646.58 MC 0 13000 Medium GAS REBATE
2624.14 10 1037.76 50 VS 703.63 13000 Medium WORLDPOINTS
28.7 15 3266.66 1204.67 VS 423.48 13000 Medium WORLDPOINTS
42.59 3 588.8 1026.98 MC 283.6 13200 Medium GAS REBATE
1011.08 5 320.87 815.69 VS 441.58 13200 Medium WORLDPOINTS
1352.21 5 886.23 1006.99 VS 661.64 13200 Medium WORLDPOINTS
1354.11 10 750.73 387.98 VS 222.12 13200 Medium WORLDPOINTS
26.5 2 130.59 240 MC 658.55 13400 Medium GAS REBATE
18 3 357.74 527.08 MC 143.2 13700 Medium GAS REBATE
177.5 3 206.74 853.69 VS 366.82 14000 Medium GAS REBATE
55.41 3 949.84 286.54 MC 74.96 14200 Medium GAS REBATE
290.07 3 105.19 6218.02 MC 122.19 14200 Medium GAS REBATE
1690.22 13 1556.47 4932 VS 3727.24 14300 Medium WORLDPOINTS
44.18 17 2827.55 642 VS 755.97 14300 Medium WORLDPOINTS
25.28 3 141.76 866.26 MC 153.46 14400 Medium GAS REBATE
95.59 3 547.59 1346.02 MC 472.01 14400 Medium GAS REBATE
16.75 2 479.66 1232.2 MC 84.35 15000 Medium GAS REBATE
43.31 3 428.28 1615 MC 14520.46 15000 Medium GAS REBATE
33.07 2 187.24 1250 MC 7068.01 15200 High GAS REBATE
14.14 3 9284.55 925.62 MC 23.37 15200 High GAS REBATE
2623.87 11 2815.88 650 VS 3793.42 15900 High WORLDPOINTS
36.65 3 178.46 0 MC 904.03 16000 High GAS REBATE
22.1 2 383.87 710.55 MC 97.39 16100 High GAS REBATE
33.22 2 2032.99 1064.03 MC 186.83 16200 High GAS REBATE
1137.35 5 552.37 1419.38 VS 729.92 16200 High WORLDPOINTS
22.48 2 406.65 1054.8 MC 168.98 16500 High GAS REBATE
1085.27 11 1060.12 500 VS 3449.9 16600 High WORLDPOINTS
1610 13 1097.36 939.23 VS 42.58 16600 High WORLDPOINTS
192.39 3 231.05 363.15 VS 612.93 16800 High GAS REBATE
708.27 5 1230.88 1500 VS 2757.48 16800 High WORLDPOINTS
2053.32 7 578.55 832.56 VS 662.05 17000 High WORLDPOINTS
50.01 3 279.18 188.85 MC 478.91 17300 High GAS REBATE
1964.38 7 436.64 494.05 VS 314.31 17300 High WORLDPOINTS
1175.11 7 511.82 1110 VS 17212.35 17300 High WORLDPOINTS
954.37 5 1318.14 761.02 VS 469.2 17400 High WORLDPOINTS
1404.57 9 1366.38 1161.7 VS 818.45 17600 High WORLDPOINTS
1383.81 4 677.95 87.14 VS 712.34 17700 High GAS REBATE
25 3 769.72 923.45 MC 5645.24 18000 High GAS REBATE
2169.47 5 981.05 944.25 VS 1293.07 18000 High WORLDPOINTS
1018.29 5 272.87 592.04 VS 220.35 18000 High WORLDPOINTS
2216.21 12 766.14 415 VS 2222.93 18000 High WORLDPOINTS
15.83 3 516.16 1400 MC 16848.699 18100 High GAS REBATE
1345.17 10 1029.53 1647 VS 17899.939 18100 High WORLDPOINTS
14.09 3 360.73 1741 MC 16660.49 18200 High GAS REBATE
500.35 5 183.27 152.3 VS 3012.71 18500 High WORLDPOINTS
1022.57 11 2027.59 516.11 VS 38.2 18700 High WORLDPOINTS
39.68 3 243.3 768.28 MC 226.39 19000 High GAS REBATE
27.14 3 242.17 1179 MC 319.16 19000 High GAS REBATE
1346.18 5 955.1 1412.8 VS 229.82 19200 High WORLDPOINTS
2313.18 10 1030.69 812.02 VS 1005.61 19300 High WORLDPOINTS
1476.26 7 504.68 3857.72 VS 32.02 19500 High WORLDPOINTS
44 2 0.75 347.94 MC 99.58 19600 High GAS REBATE
13.75 3 360.69 650 MC 4278.09 19600 High GAS REBATE
98.78 3 863.56 891.66 VS 886.28 19600 High GAS REBATE
975 4 901.69 828.12 VS 535.23 19600 High WORLDPOINTS
940.16 5 557.5 229.03 VS 534.9 19600 High WORLDPOINTS
55.41 19 2741.38 550 VS 316.49 19600 High WORLDPOINTS
196.26 3 287.09 1720.25 VS 421.81 19700 High GAS REBATE
1432.5 10 1089 674.75 VS 274.56 19700 High WORLDPOINTS
28.7 2 572.4 4798.32 MC 186.17 19800 High GAS REBATE
35.38 3 91.16 547.39 MC 609.03 19800 High GAS REBATE
125.58 3 1425.59 800 VS 5693.62 19800 High GAS REBATE
2263 10 636.6 1259.4 VS 255.26 19800 High WORLDPOINTS
6458.49 13 1252.14 1233.8 VS 338.71 19800 High WORLDPOINTS
5.33 3 152.1 1111.33 MC 251.49 19900 High GAS REBATE
14.74 3 295.38 925 MC 17300.43 20100 High GAS REBATE
20.58 3 156.39 996.67 MC 104.93 21700 High GAS REBATE
1271.07 10 2100.27 1100 VS 7978.7 22500 High WORLDPOINTS
26.91 3 614.6 1244 MC 417.63 22600 High GAS REBATE
1780.64 5 2133.3 500 VS 2293.18 22600 High WORLDPOINTS
133.32 3 85.74 600 VS 745.37 22800 High GAS REBATE
4095.05 13 1052.55 1971.73 VS 189.85 23200 High WORLDPOINTS
20 2 519.73 886.07 MC 529.67 23400 High GAS REBATE
38.5 3 335.84 2475 MC 295.36 24000 High GAS REBATE
35.39 3 398.81 704.97 MC 435.96 24000 High GAS REBATE
33.52 3 353.05 919.34 MC 20.19 24100 High GAS REBATE
54 3 287.09 829.46 MC 179.07 24100 High GAS REBATE
749.54 5 460.94 822.74 VS 318.61 24200 High WORLDPOINTS
1161.78 5 364.26 668 VS 0 24400 High WORLDPOINTS
1557.65 5 513.94 534.94 VS 149.05 24400 High WORLDPOINTS
783.9 5 288.7 505.82 VS 255.67 24600 High WORLDPOINTS
36.64 2 92.88 1371.91 MC 7.66 26800 High GAS REBATE
41.03 2 223.24 2811 MC 18742.67 28800 High GAS REBATE
469.03 4 291.22 879.31 VS 124.19 28800 High GAS REBATE
361.85 4 567.06 847.83 VS 42 29000 High GAS REBATE
26.09 3 1043.97 1980 MC 28748.051 29400 High GAS REBATE
28.11 3 270.88 2900 MC 55.46 29700 High GAS REBATE
759.98 5 1066.52 450 VS 3304.88 30500 High WORLDPOINTS
1704.93 5 250.36 772.69 VS 280.38 32000 High WORLDPOINTS
35.88 3 677.23 995.65 MC 2146.18 35000 High GAS REBATE
44.45 3 154.06 712.35 MC 401.21 39800 High GAS REBATE

See attached excel document.

Independent sample T test

Period Week 1 Week 2 Week 3 Week 4 Week 5 Week 6
Mon :Group A 10 20 25 25 35 40
Tues: Group A 15 25 25 25 35 25
Wed: Group B 20 28 25 25 35 25
Thur: Group B 25 32 35 25 35 25

50 students were present each day
Do a T test to indicate the significance between those students who had homework assignments
The number of students in compliance is entered in the field, there were 50 different students present every 2 days(group A & Group B)
If a T-test is not the right move please provide
Graph information

70 105 110 100 140 115
200 200 200 200 200 200

Independent sample t test

Test the hypothesis of no differences for average payback period (years) necessary to justify solar heating systems for residences.

Savings and Loans Other Financiers
X1 = 8.7 X2 = 7.7
S2/1 = .5 S2/2 = .6
n1 = 100 n2 = 64.

Independent Sample t test

I am having a hard time understanding how to perform t-tests in nonnumerical data.

A. Perform two t – tests to determine if there is a difference in your spending category based on Card Type or Reward Type.

Do people who get World Points spend more than those who get Gas Rebates on your Spend type?
Do people with Master Cards spend more than those with Visa Cards on your Spend type?

238.03 1 MC GAS REBATE
354.89 1 MC GAS REBATE
308.25 1 MC GAS REBATE
547.78 1 MC GAS REBATE
460.25 1 MC GAS REBATE
833.88 2 VS WORLDPOINTS
56.45 1 MC GAS REBATE
54.37 1 MC GAS REBATE
126.79 1 VS WORLDPOINTS
428.74 1 MC GAS REBATE
623.72 1 MC GAS REBATE
695.16 3 VS WORLDPOINTS
388.12 1 MC GAS REBATE
239.4 1 MC GAS REBATE
268.93 1 MC GAS REBATE
668.91 2 VS WORLDPOINTS
788.3 1 VS WORLDPOINTS
568.18 1 MC GAS REBATE
544 1 MC GAS REBATE
331.51 1 VS WORLDPOINTS
297.85 1 VS GAS REBATE
142.77 1 MC GAS REBATE
37.43 1 MC GAS REBATE
128.69 1 VS WORLDPOINTS
77.99 1 MC GAS REBATE
675.1 1 VS GAS REBATE
292.56 1 MC GAS REBATE
792.82 1 MC GAS REBATE
259.75 1 MC GAS REBATE
274.62 1 MC GAS REBATE
290.01 1 VS GAS REBATE
59.4 1 VS WORLDPOINTS
219.31 2 VS WORLDPOINTS
125.68 1 MC GAS REBATE
289.92 1 VS WORLDPOINTS
230.17 1 MC GAS REBATE
21.48 1 MC GAS REBATE
327.65 1 MC GAS REBATE
192.53 1 MC GAS REBATE
2350.75 3 VS WORLDPOINTS
986.3 2 VS WORLDPOINTS
66.87 1 VS GAS REBATE
294.91 3 VS WORLDPOINTS
998.99 1 MC GAS REBATE
292.1 1 MC GAS REBATE
464.9 2 VS WORLDPOINTS
36.93 1 MC GAS REBATE
493.45 1 MC GAS REBATE
419.44 1 MC GAS REBATE
537.86 1 VS GAS REBATE
1606.46 1 VS WORLDPOINTS
49.58 1 VS WORLDPOINTS
54.04 1 VS WORLDPOINTS
69.9 3 VS WORLDPOINTS
153.8 1 VS WORLDPOINTS
177.79 1 VS GAS REBATE
296 1 MC GAS REBATE
573.48 1 VS WORLDPOINTS
783.68 1 VS WORLDPOINTS
222.84 2 VS WORLDPOINTS
16.73 2 VS WORLDPOINTS
1546.82 8 VS WORLDPOINTS
459.05 1 MC GAS REBATE
251.74 1 VS WORLDPOINTS
364.06 1 MC GAS REBATE
27.85 1 MC GAS REBATE
67.31 1 MC GAS REBATE
423.77 1 MC GAS REBATE
219.27 1 MC GAS REBATE
626.1 1 VS WORLDPOINTS
636.14 2 VS WORLDPOINTS
807.46 2 VS WORLDPOINTS
299.25 1 MC GAS REBATE
159.83 1 MC GAS REBATE
617.92 2 VS WORLDPOINTS
123.48 2 VS WORLDPOINTS
116.47 1 MC GAS REBATE
427.11 1 VS GAS REBATE
170.06 1 VS WORLDPOINTS
33.65 1 VS WORLDPOINTS
574.19 2 VS WORLDPOINTS
314.75 2 VS WORLDPOINTS
123.03 1 MC GAS REBATE
1298.22 7 VS WORLDPOINTS
382.5 1 MC GAS REBATE
198.13 1 VS GAS REBATE
61.89 1 VS GAS REBATE
59.35 1 MC GAS REBATE
5.16 1 MC GAS REBATE
94.36 1 MC GAS REBATE
1402.57 1 VS WORLDPOINTS
229.65 1 MC GAS REBATE
94.51 1 VS WORLDPOINTS
245.52 2 VS WORLDPOINTS
377.47 1 VS GAS REBATE
322.9 1 VS WORLDPOINTS
335.7 2 VS WORLDPOINTS
185.76 2 VS WORLDPOINTS
522.21 2 VS WORLDPOINTS
266.49 2 VS WORLDPOINTS
561.62 2 VS WORLDPOINTS
135.83 1 MC GAS REBATE
682.2 1 MC GAS REBATE
306.57 1 MC GAS REBATE
204.55 1 VS WORLDPOINTS
220.66 1 VS WORLDPOINTS
1135.71 2 VS WORLDPOINTS
453.44 1 MC GAS REBATE
283.92 1 MC GAS REBATE
584.93 1 VS GAS REBATE
71.09 1 MC GAS REBATE
20.69 2 VS WORLDPOINTS
619.56 3 VS WORLDPOINTS
229.98 1 MC GAS REBATE
488.62 1 VS WORLDPOINTS
300.65 1 VS WORLDPOINTS
274.82 2 VS WORLDPOINTS
40.15 1 MC GAS REBATE
255.14 1 MC GAS REBATE
79.97 1 VS GAS REBATE
111.41 1 MC GAS REBATE
50.62 1 MC GAS REBATE
796.37 3 VS WORLDPOINTS
819.9 3 VS WORLDPOINTS
257.96 1 MC GAS REBATE
450.64 1 MC GAS REBATE
322.85 1 MC GAS REBATE
20 1 MC GAS REBATE
218.39 1 MC GAS REBATE
128.01 1 MC GAS REBATE
499.78 2 VS WORLDPOINTS
182.61 1 MC GAS REBATE
116.09 1 MC GAS REBATE
232.1 1 MC GAS REBATE
131.56 1 VS WORLDPOINTS
579.48 1 MC GAS REBATE
359.92 2 VS WORLDPOINTS
318.37 3 VS WORLDPOINTS
197.32 1 VS GAS REBATE
1151.39 1 VS WORLDPOINTS
144.4 1 VS WORLDPOINTS
158.97 1 MC GAS REBATE
147.83 1 VS WORLDPOINTS
898.06 2 VS WORLDPOINTS
1496.7 1 VS WORLDPOINTS
591.83 2 VS WORLDPOINTS
64.2 1 VS GAS REBATE
982.99 1 MC GAS REBATE
96.99 1 VS WORLDPOINTS
634.97 1 VS WORLDPOINTS
147.22 3 VS WORLDPOINTS
187.86 1 MC GAS REBATE
221.1 2 VS WORLDPOINTS
580.75 1 MC GAS REBATE
505.32 1 VS WORLDPOINTS
321.14 3 VS WORLDPOINTS
524.13 1 MC GAS REBATE
213.31 1 MC GAS REBATE
41.79 1 VS WORLDPOINTS
396.86 2 VS WORLDPOINTS
89.32 1 VS WORLDPOINTS
155.6 1 MC GAS REBATE
81.58 1 MC GAS REBATE
578.67 1 VS GAS REBATE
299.2 1 VS WORLDPOINTS
603.85 1 VS WORLDPOINTS
738.87 10 VS WORLDPOINTS
67.84 1 VS GAS REBATE
367.07 2 VS WORLDPOINTS
59.24 1 MC GAS REBATE
253.43 1 MC GAS REBATE
1835.72 1 VS GAS REBATE
189.2 2 VS WORLDPOINTS
269.55 3 VS WORLDPOINTS
843.51 1 MC GAS REBATE
175.09 1 MC GAS REBATE
116.11 1 MC GAS REBATE
428.6 2 VS WORLDPOINTS
296.48 1 MC GAS REBATE
594.13 1 VS WORLDPOINTS
744.51 1 VS GAS REBATE
168.19 3 VS WORLDPOINTS
341.31 1 MC GAS REBATE
429.1 1 MC GAS REBATE
168.74 1 MC GAS REBATE
1180.77 1 MC GAS REBATE
19.23 1 MC GAS REBATE
250.22 1 VS WORLDPOINTS
157.89 1 VS WORLDPOINTS
454.83 1 VS WORLDPOINTS
264.82 1 VS WORLDPOINTS
34.91 1 MC GAS REBATE
439.79 1 MC GAS REBATE
6.22 1 VS GAS REBATE
591.52 1 VS GAS REBATE
218.89 1 MC GAS REBATE
203.35 1 MC GAS REBATE
235.86 1 VS WORLDPOINTS
627.61 1 VS WORLDPOINTS
301.42 1 MC GAS REBATE
96.93 1 MC GAS REBATE

Independent sample t test

The Business Administration department at a local university delivers some of its courses using online instruction. Of the two statistics courses offered, one is delivered online and the other is delivered on campus. Eighteen pairs of students are selected, who are well matched on a number of years and grades of mathematics courses in high school and college, class status (i.e., freshmen, sophomore, junior, senior), and previous GPA. Use the 8-step hypothesis testing procedure to report the findings and include a copy of the computer printout.

See Attachment.

Independent sample t test

Fairfield Homes is developing two parcels near Pigeon Fork, Tennessee. In order to test different advertising approaches, they use different media to reach potential buyers. The mean annual family income for 75 people making inquiries at the first development is $150,000, with a standard deviation of $40,000. A corresponding sample of 120 people at the second development had a mean of $180,000, with a standard deviation of $30,000. At the .05 significance level, can Fairfield conclude that the population means are different?

Independent sample t test

A real estate agent claims that there is no difference between the mean household incomes of two neighborhoods. The mean income of 12 randomly selected households from the first neighborhood was $35750 with a sample standard deviation of $1900. In the second neighborhood, 10 randomly selected households had a mean income of $34200 with a sample standard deviation of $1825.

(2) Which two-sample test should you use for this situation?

(18) Using a significance level of ±=0.01, determine if there is enough evidence to reject the real estate agent’s claim. You must state the hypotheses, determine the test statistic, and either the P-value(s) or critical value(s). Finally, you must clearly state your conclusion. Round all answers to two decimal places.

Independent sample t test.

A researcher wants to know if elderly people who own dogs are equally as likely to pay visits to their doctors than those who do not own dogs. The researcher obtained a sample of 5 elderly dog owners and 7 elderly people who do not own dogs. The number of visits to the doctor was recorded for each person for a year. The data are as follows:

Own a dog: 8 5 9 4 6
Do not own a dog: 12 10 6 9 15 10 8

Based on this data, answer the researcher’s question. Be certain to clearly specify the statistical test you used in answering this question, and show all of the computations you used in answering this question.

Independent sample t test

Periodically Merrill Lynch customers are asked to evaluate Merrill Lynch¯Financial consultants and services (2000 Merrill Lynch Client Satisfactory Survey). Higher ratings on the client satisfaction survey indicate better service with 7 the maximum service
rating. Independent samples of service ratings for two ¯Financial consultants are summarized below. Consultant A has 10 years of experience while consultant B has 1 year of experience. Using a= .05, test to see whether the consultant with the more experience has the higher population mean service rating.

Consultant A Consultant B
x1 = 6.82 x2 = 6.25
s1 = .64 s2 = .75
n1 = 16 n2 = 10
a) State the null and the alternative hypotheses.
b) Compute the value of the test statistic.
c) What is the p-value?
d) What is your conclusion?

Independent sample t test

A study is conducted to compare mean cholesterol levels for individuals following a low carbohydrate diet for at least 6 months to individuals following a conventional (low fat, low calorie )diet for at least 6 months. test if there is a significant difference in mean cholesterol levels between the diet programs using a 5% level of significance.

Data below:

Diet Program Sample Size Mean Cholesterol Std Dev Cholesterol

Low Carb 50 225.4 24.5

Conventional 75 203.8 21.6

Independent sample t test

Twenty students randomly assigned to an experimental group receive an instructional program; 30 in a control group do not. After 6 months, both groups are tested on their knowledge. The experimental group has a mean of 38 on the test (with an estimated population standard deviation of 3); teh control group has a mean of 35 (with an estimated population standard deviation of 5). Using the .05 level, what should the experimenter conclude? (a) Use the steps of hypothesis testing, (b) sketch the distributions involved, and (c) explain your answer to someone who is familiar with the t test for a single sample, but not with the t test for independent means.

independent sample t test

Two new york designs are under consideration for possible adoption in an assembly plant. A time study is conducted with 10 workers using design 1, and 12 workers using design 2. The means and standard deviation of their assembly times in minutes are below.

Design 1 Design 2
Mean 78.3 minutes Mean 85.6 Minutes
Standard Deviation 4.8 Standard Deviation 6.5

Is the mean assembly time significantly higher for work design 2. Test at the 5% level of significance. Defend your position (this means write a brief explanation that the plant manager will understand)

Independent sample t test

Comparison of profit from French store location and profit from German store locations using the independent sample student t test.

See attached file for full problem description.

Independent sample t test

Twenty students randomly assigned to an experimental group receive an instructional program; 30 in a control group do not. After 6 months, both groups are tested on their knowledge. The experimental group has a mean of 38 on the test (with an estimated population standard deviation of 3); the control group has a mean of 35 (with an estimated population standard deviation of 5). Using the .05 level, what should the experimenter conclude? (a) Use the steps of hypothesis testing, (b) sketch the distributions involved, and (c) explain your answer to someone who is familiar with the t test for a single sample, but not with the t test for independent means.

Independent sample t test

The average mpg usage for a 2004 Ford Expedition 2WD for a sample of 10 tanks of gas was 17.0 with the standard deviation of 0.8. For a Ford Explorer 2WD, the average mpg usage for a sample of 10 tanks of gas was 18.5 with a standard deviation of 1.0. (a) Assuming equal variances, at a (alpha) = .01. is the true mean mpg lower for the Ford Expedition? (b) Calculate p-value using Excel.

Independent Sample t Test

Using the raw measurement data presented below, calculate the t value for independent groups to determine whether or not there exists a statistically significant difference between the salaries of female and male human resource managers. Develop a research question, testable hypothesis, confidence level (i.e. set your alpha level), and degrees of freedom. Draw the appropriate conclusions with respect to female and male human resource manager salary levels.

Salary Level:

Female HR Directors Male HR Directors

$50,000 $58,000
$75,000 $69,000
$72,000 $73,000
$67,000 $67,000
$54,000 $55,000
$58,000 $63,000
$52,000 $53,000
$68,000 $70,000
$71,000 $69,000
$55,000 $60,000

Independent sample t test

A manufacturer claims that the mean lifetime of its fluorescent bulbs is 1050 hours. A homeowner
selects 40 bulbs and finds the mean lifetime to be 1030 hours with a standard deviation of 80 hours.
Test the manufacturer’s claim. Use α = 0.05

1. State H0
2. State Ha
3. What is the claim?
4. What is the critical value?
5. What is the standardized test statistic?
6. What is the decision?

A local politician, running for reelection claims the mean prison time for car thieves is less than the required four years. A sample of 80 convicted car thieves was randomly selected and the mean length of prison time was found to be 3.5 years with a standard deviation of 1.25 years. At α = 0.05 test the politician’s claim.

7. State H0
8. State Ha
9. What is the claim?
10. What is the critical value?
11. What is the standardized test statistic?
12. What is the decision?

A local brewery distributes beer in bottles labeled 12 ounces. A government agency thinks the brewery is cheating its customers. The agency selects 20 of these bottles and measures their contents and obtains a mean of 11.7 ounces with a standard deviation of 0.7. At α = 0.01 test the claim.

13. State H0
14. State Ha
15. What is the claim?
16. What is the critical value?
17. What is the standardized test statistic?
18. What is the decision?
A medical researcher suspects that the pulse rate of smokers is higher than the pulse rate of non-smokers. Used the sample statistics below to test the researcher’s suspicion. Use α = 0.05

Smokers Nonsmokers
n1 = 100 N2 = 100
x bar1 = 84 X bar2 =81
S1 = 4.8 S2= 5.3

19. State H0
20. State Ha
21. What is the claim?
22. What is the critical value?
23. What is the standardized test statistic?
24. What is the decision?

At α = 0.05, test a financial advisor’s claim that the difference between the mean dividend rate for listings in the NYSE market and the mean dividend rate for listing in the NASDAQ market is more than 0.75. The sample statistics from randomly selected listings from each market are listed below.

NYSE NASDAQ
n1 = 30 n2 = 50
x bar1 = 2.75% x bar2 =1.66%
S1 = 1.44% S2= 0.63%

25. State H0
26. State Ha
27. What is the claim?
28. What is the critical value?
29. What is the standardized test statistic?
30. What is the decision?

31. Construct a 95% confidence interval for µ1 – µ2. Two samples are randomly selected from each
population . The sample statistics are given below.

n1 = 40 n2 = 35
x bar1 = 12 x bar2 =13
S1 = 2.5 S2= 2.8

A study was conducted to determine if the salaries of elementary school teachers from two neighboring districts are equal. A sample of 15 teachers from each school district was randomly selected. The mean from the first district was $28,000 with a standard deviation of $2,300. The mean from second school district was $30,300 with a standard deviation of $2,100. Test the claim that the salaries from both district are equal. Assume the variances are equal. Use α = 0.05.

32. State H0
33. State Ha
34. What is the claim?
35. What is the critical value?
36. What is the standardized test statistic?
37. What is the decision?

A local bank claims that the waiting time for its customers to be served is the lowest in the area. A competitor’s bank checks the waiting time at both banks. The sample statistics are listed below. Test the local bank’s claim assuming the variances are not equal. Use α = 0.05.

Local Bank Competitor Bank
n1 = 15 n2 = 16
x bar1 = 5.3 minutes x bar2 =5.6 minutes
S1 = 1.1 minutes S2= 1.0 minutes

38. State H0
39. State Ha
40. What is the claim?
41. What is the critical value?
42. What is the standardized test statistic?
43. What is the decision?

A manager wishes to determine the relationship between the number of miles (in hundreds of miles) the manager’s sales representatives travel per month and the amount of sales (in thousands of dollars) per month.

Miles traveled, x 3 4 4 5 3 6 2 7 3
Sales, y 31 33 78 62 65 61 48 55 120

44. Find the linear regression.
45. Find the correlation coefficient.
46. Find the amount of sales if a sales rep traveled 10 miles.
47. If a sales rep made 80 in sales how many miles had they traveled?
The data below are the final exam scores of 10 randomly selected statistics students and the number of hours they studied for the exam.

Hours, x 3 5 2 8 2 4 4 5 6 3
Scores, y 65 80 60 88 66 78 85 90 90 71

48. Find the linear regression.
49. Find the correlation coefficient.
50. What grade did a student make if they studied 7 hours?
51. If a student made a 100 on the test how many hours had they studied?

Independent sample t test

Members of the general adult population volunteer an average of 4.2 hours per week. A random sample of 20 female college students and 18 male college students produced the results given in the table below. Assuming that the variances of the time volunteered by females and males are equal, at the .01 level of significance, is there sufficient evidence to conclude that a difference exists between the mean number of volunteer hours per week for male and female college students?

Females Males
Sample size 20 18
Sample mean 3.8 2.5
Sample variance 3.5 2.2

A. No, because the test value 2.36 is greater than the critical value
B. No, because the test value 2.36 does not exceed the critical value
C. No, because the test value 2.58 is greater than the critical value
D. Yes, because the test value 2.58 is greater than the critical value

Independent sample t test

1) Survey showed 75 new employees hired at one employment place had an average salary of $60K with standard deviation of $20K. At another employment place, the average income of 60 households surveyed showed $85K with standard deviation of $25K. At significance level of 0.05, can a surveyor conclude that population means are different?

2) A random sample of 20 observations from the first population revealed a sample mean of 325 and a sample standard deviation of 15. A random sample of 25 observations from the second population revealed a sample mean of 316 and a sample standard deviation of 20. At the 0.10 significance level, is there a difference in the population mean?

Independent sample t test

A pharmaceutical company is testing the effectiveness of a new drug for lowering cholesterol. As part of this trial, they wish to determine whether there is a difference between the effectiveness for women and for men. At = .05, what is the value the test statistic?
Women Men
Sample size 50 80
Mean effect 7 6.95
Sample S.D.s 3 4

A. t = 3.252
B. z = 0.455
C. z = 0.081
D. z = 0.151

Independent Sample t Test

Pooled-Variances t-Test for (µ1 – µ2), Population Variances Unknown but
Assumed Equal

t-Test: Two-Sample Assuming Equal Variances

Format 1 Format 2
Mean 6 8.166666667
Variance 9.777777778 11.06060606
Observations 10 12
Pooled Variance 10.48333333
Hypothesized Mean Difference 0
df 20
t Stat -1.562865798
P(T<=t) one-tail 0.066884748
t Critical one-tail 1.724718218
P(T<=t) two-tail 0.133769496
t Critical two-tail 2.085963441

Format 1 Format 2
11 10
8 11
8 9
3 7
7 2
5 11
9 12
5 3
1 6
3 7
8
12

See attached file – Pooled-Variances t-Test

(11.1 – Module 7)

Independent sample t test

A sample of 40 observations is selected from one approximately normal population. The sample mean is 102 and the sample standard deviation is 5. A sample of 50 observations is selected from a second source. The sample mean is 99 and the standard deviation is 6. Conduct a hypothesis test using the .04 level of significance to determine if there is a difference between the population means.

Independent sample t test

Please see the attached file.

Problem 8-55

Two movies were screen-tested at two different samples of theaters. Mystic river was viewed at 80 theaters and was considered a success in terms of box office sales in 60 of these theaters. Swimming Pool was viewed at a random sample of 100 theaters and was considered a success in 65. Based on these data, do you believe that one of these movies was a greater success than the other? Explain.

Problem 8-72

The New York Times reports that cosmetic surgery is seeing much growth recently as the US population ages. One aspect of this growth is that more men are choosing to have plastic surgery to improve their looks. If a random sample of 3,000 men reveals that 140 of them have had plastic surgery, and an independent random sample of 3,000 women reveals that 351 of them have had plastic surgery, test for equality of proportions. Use the 0.05 level of significance.

Independent sample t test

Grand Strand Family Medical Center is specifically set up to treat minor medical emergencies for visitors to the Myrtle Beach area. There are two facilities, one in the Little River Area and the other in Murrells Inlet. The Quality Assurance Department wishes to compare the mean waiting time for patients at the two locations. Samples of the waiting times, reported in minutes, follow:
Location Waiting Time
Little River
31.73 28.77 29.53 22.08 29.47 18.60 32.94 25.18 29.82 26.49

Murrells Inlet
22.93 23.92 26.92 27.20 26.44 25.62 30.61 29.44 23.09 23.10 26.69 22.31

Assume the population standard deviations are not the same. At the .05 significance level, is there a difference in the mean waiting time?

Independent sample t test

Rental car gasoline prices per gallon were sampled at eight major airports. Date for Hertz and National car rental companies follow (USA today April 4, 2000)

Airport Hertz National

Boston Logan 1.55 1.56

Chicago O’Hare 1.62 1.59

Los Angeles 1.72 1.78

Miami 1.65 1.49

New York (JFK) 1.72 1.51

New York (LaGuardia) 1.67 1.50

Orange County, CA 1.68 1.77

Washington 1.52 1.41

Use a=.05 to test the hypothesis of no difference between the population mean prices per gallon for the4 two companies.

Independent sample t test

The assignment starts out by stating, you are given the responsibility fo presenting the results of a yearlong study of a teaching strategy to the school board. Fifty-two students were chosen at random from the school population to participate in the study. Twenty-six students were then randomly chosen to serve as a control group and received traditional instruction in the subject. The other 26 experienced the alternative treatment.

Then it goes on to tell me to prepare a report to submit to the school board. Using the most appropriate statistical test to present the information. (HINT: Consider using a “difference of means” test). Present the information in both a graphic (table, graph, etc.) and a written form (one to two paragraphs). Summarize and make a recommendation based on the results (one to two paragraphs).

Also, gives me the following information on the control group and the treatment group

CONTROL GROUP
71 65
81 75
98 75
62 63
65 74
81 75
77 98
74 58
65 74
89 45
78 81
89 65
78 74

TREATMENT GROUP
76 80
80 81
100 78
75 87
78 89
85 80
72 92
78 61
56 78
89 74
78 83
88 70
79 78

Independent sample t test

A marketing firm asked a random set of married and single men as to how much they were willing to spend for a vacation. At = .05, is a difference in the two amounts?

Married men Single men
Sample size 50 70
Mean spending 260 185
Sample variance 4500 9000

A) Yes, because the test value 5.07 is outside the interval (-1.96, 1.96)
B) No, because the test value 2.00 is outside the interval (-1.96, 1.96)
C) No, because the test value 0.34 is inside the interval (-1.96, 1.96)
D) Yes, because the test value 2.00 is inside the interval (-1.96, 1.96)

Independent sample t test

An Ohio university wishes to demonstrate that car ownership is detrimental to academic achievement. A random sample of 100 students who do not own cars had a mean GPA of 2.68 with a standard deviation of 0.6, while the same size of sample who own cars had a mean GPA of 2.55 with a standard deviation of 0.7. Can the university justify that the mean GPA for non-car owners is greater than the mean GPA for car owners at a 99% confidence?

Independent sample t test

D) Silver Gym’s aerobic class grew so large that the class had to be split in half and offered on two different nights. Silver also hired a new aerobic leader to handle the Tuesday night class, whereas an existing staff member continued to handle the Thursday night class. Concerned about customer satisfaction with the new leader, Silver Gym’s management decided to secure a leader-approval rating from each class after four weeks. Results are shown in the table below:
Tuesday Thursday
Class Size
Mean Approval Rating
Standard Deviation 38
87.3
7.4 41
89.7
6.3
Did the new leader of the Tuesday night class receive a lower approval rating than the leader of the Thursday night class? Set up and test = 0.05. at &#61537; as your hypotheses.

Independent sample t test

Pre-Step: Calculate the statistics from your sample.

Group # 1 Group # 2
Mean
Variance
Standard Deviation
Sample Size

Step I: State the Null and Alternative Hypothesis

Step 2:

a. One-Tail or Two-Tail Test: ________________

b. Choose a Test Statistic: __________

c. Critical Value of the Test Statistic: __________

d. Label your Decision Rule: