Share
Explore BrainMass

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

Attachments

Solution Summary

The solution provides step by step method for the calculation of testing of hypothesis using independent sample t test. Formula for the calculation and Interpretations of the results are also included. Interactive excel sheet is included. The user can edit the inputs and obtain the complete results for a new set of data.

$2.19