A. Open grocery_coupons.sav.
Conduct a Two-Way analysis of variance
using shopfor and style as factors and amtspent as the dependent variable.
i. State the hypothesis of the study in words. 3points
Null Hypothesis: (at α=0.01, 0.05)
1. There is no significant difference on the amount spent for any
beneficiary of shopping (who to shop for).
2. There is no significant difference on the amount spent for any
shopping style used.
3. There is no interaction effect between whom the respondents are
shopping for and the shopping style on the amount spent.
ii. Prepare the descriptive table. 1 point
Descriptive Statistics
Dependent Variable: Amount spent
Who shopping for Shopping style Mean Std. Deviation N
Biweekly; in bulk 80.4054 78.66912 76
Weekly; similar items 84.4548 18.43950 316
Self
Often; what's on sale 94.1112 17.53390 92
Total 85.6544 35.49042 484
Biweekly; in bulk 86.3846 87.47239 120
Weekly; similar items 98.2209 17.41530 340
Self and spouse
Often; what's on sale 96.8950 14.84065 100
Total 95.4478 43.29497 560
Biweekly; in bulk 119.2799 115.52559 84
Weekly; similar items 128.1399 27.15435 232
Self and family
Often; what's on sale 128.4452 15.44123 44
Total 126.1099 60.02387 360
Biweekly; in bulk 94.6303 95.73314 280
Weekly; similar items 101.1388 26.86657 888
Total
Often; what's on sale 101.6920 20.53686 236
Total 99.9338 48.54435 1404
iii. Provide the Two-way ANOVA Table 1 point
Tests of Between-Subjects Effects
Dependent Variable: Amount spent
Source Type III Sum of df Mean Square F Sig.
Squares
Corrected Model 383548.285a 8 47943.536 22.883 .000
Intercept 9606264.836 1 9606264.836 4585.059 .000
shopfor 224096.300 2 112048.150 53.480 .000
style 18067.033 2 9033.516 4.312 .014
shopfor * style 5938.576 4 1484.644 .709 .586
Error 2922697.078 1395 2095.123
Total 17327659.518 1404
Corrected Total 3306245.363 1403
a. R Squared = .116 (Adjusted R Squared = .111)
iv. Make a post hoc analysis using LSD and show the multiple comparison
table. 1 point
Multiple Comparisons
Dependent Variable: Amount spent
LSD
(I) Who (J) Who shopping for Mean Difference Std. Error Sig. 95% Confidence Interval
shopping for (I-J) Lower Bound Upper Bound
*
Self and spouse -9.7933 2.84078 .001 -15.3660 -4.2206
Self
Self and family -40.4554* 3.18568 .000 -46.7047 -34.2062
*
Self and Self 9.7933 2.84078 .001 4.2206 15.3660
*
spouse Self and family -30.6621 3.09210 .000 -36.7278 -24.5964
*
Self and Self 40.4554 3.18568 .000 34.2062 46.7047
family Self and spouse 30.6621*
3.09210 .000 24.5964 36.7278
Based on observed means.
The error term is Mean Square(Error) = 2095.123.
*. The mean difference is significant at the .05 level.
Multiple Comparisons
Dependent Variable: Amount spent
LSD
(I) Shopping (J) Shopping style Mean Difference Std. Error Sig. 95% Confidence Interval
style (I-J) Lower Bound Upper Bound
Biweekly; in Weekly; similar items -6.5085* 3.13719 .038 -12.6627 -.3544
bulk Often; what's on sale -7.0618 4.04478 .081 -14.9963 .8727
Weekly; Biweekly; in bulk 6.5085* 3.13719 .038 .3544 12.6627
similar items Often; what's on sale -.5532 3.35217 .869 -7.1291 6.0226
Often; Biweekly; in bulk 7.0618 4.04478 .081 -.8727 14.9963
what's on .5532 3.35217 .869 -6.0226 7.1291
Weekly; similar items
sale
Based on observed means.
The error term is Mean Square(Error) = 2095.123.
*. The mean difference is significant at the .05 level.
v. Create a textual presentation of the result using an APA format. 4point
The two-way analysis of variance shows that:
1. There is a significant difference on the amount spent for any
beneficiary of shopping (who to shop for) (F(53.48)=.000, p<0.01).
2. Also, there is a significant difference on the amount spent for any
shopping style used (F(4.312)=.014, p<0.05).
3. However, there is no interaction effect between whom the
respondents are shopping for and the shopping style in the amount
spent (F(.709)=0.586, p>0.05).
B. Open grocery_1month.sav. Conduct a Three-Way analysis of variance
using size of store, gender, and use coupons as factors and Amount Spent as
the dependent variable.
i. How many null hypothesis are there? 1 point
There are seven (7) null hypotheses in the three-way anova.
ii. Prepare the descriptive table. 1 point
Descriptive Statistics
Dependent Variable: Amount spent
Size of store Gender Use coupons Mean Std. Deviation N
No 402.9467 53.08116 9
From newspaper 394.7378 55.32768 9
Male From mailings 486.0945 102.05962 11
From both 495.5311 145.37071 9
Total 446.9995 104.01544 38
No 312.7457 95.14233 7
From newspaper 346.5400 74.19457 4
Small Female From mailings 421.9209 117.22599 11
From both 445.1050 94.51037 6
Total 388.8264 110.82671 28
No 363.4838 85.20156 16
From newspaper 379.9077 62.87336 13
Total From mailings 454.0077 112.17151 22
From both 475.3607 126.17342 15
Total 422.3200 109.99971 66
Medium No 420.3574 91.36326 19
From newspaper 393.2867 50.65505 15
Male From mailings 466.4032 89.88635 22
From both 482.1941 126.93069 17
Total 443.0721 98.50290 73
Female No 367.2993 87.36657 27
From newspaper 348.4579 109.34620 14
From mailings 375.9794 43.46181 16
From both 375.5800 102.33838 11
Total 366.8021 85.85565 68
No 389.2146 91.90592 46
From newspaper 371.6452 85.75530 29
Total From mailings 428.3300 86.01453 38
From both 440.3100 127.42846 28
Total 406.2894 99.90239 141
No 403.9424 70.40061 21
From newspaper 390.0657 64.58329 23
Male From mailings 422.9924 87.10245 21
From both 437.6578 106.28393 9
Total 409.1359 78.79906 74
No 311.7272 63.96829 18
From newspaper 327.9559 65.37216 17
Large Female From mailings 398.4242 110.11958 19
From both 382.1663 88.68204 16
Total 355.3009 90.72567 70
No 361.3815 81.29022 39
From newspaper 363.6690 71.22492 40
Total From mailings 411.3225 98.19282 40
From both 402.1432 97.05552 25
Total 382.9661 88.71589 144
No 410.1245 75.71493 49
From newspaper 391.9883 57.55010 47
Male From mailings 453.5324 93.20937 54
From both 474.1714 125.37160 35
Total 430.3043 93.47877 185
No 340.7190 84.25149 52
From newspaper 338.2806 84.69003 35
Total Female From mailings 396.2361 94.03784 46
From both 391.4142 94.99714 33
Total 365.6671 92.64058 166
No 374.3910 87.10401 101
From newspaper 369.0643 74.87278 82
Total From mailings 427.1761 97.43944 100
From both 434.0099 118.41767 68
Total 399.7352 98.40821 351
iii. Provide the Two-way ANOVA Table 1 point (Ma’am three-way ba dapat
to?)
Tests of Between-Subjects Effects
Dependent Variable: Amount spent
Source Type III Sum of df Mean Square F Sig.
Squares
Corrected Model 808543.670a 23 35154.073 4.454 .000
Intercept 45283573.429 1 45283573.429 5737.388 .000
size 42773.796 2 21386.898 2.710 .068
gender 300081.581 1 300081.581 38.020 .000
usecoup 293466.366 3 97822.122 12.394 .000
size * gender 3898.764 2 1949.382 .247 .781
size * usecoup 46133.591 6 7688.932 .974 .443
gender * usecoup 7441.979 3 2480.660 .314 .815
size * gender * usecoup 40286.880 6 6714.480 .851 .532
Error 2580918.151 327 7892.716
Total 59475118.440 351
Corrected Total 3389461.820 350
a. R Squared = .239 (Adjusted R Squared = .185)
iv. Make a post hoc analysis using LSD and show the multiple comparison
table. 1 point
Multiple Comparisons
Dependent Variable: Amount spent
LSD
(I) Size of store (J) Size of store Mean Difference Std. Error Sig. 95% Confidence Interval
(I-J) Lower Bound Upper Bound
Medium 16.0306 13.25003 .227 -10.0354 42.0967
Small
Large 39.3539* 13.20595 .003 13.3745 65.3332
Small -16.0306 13.25003 .227 -42.0967 10.0354
Medium *
Large 23.3233 10.52555 .027 2.6169 44.0296
*
Small -39.3539 13.20595 .003 -65.3332 -13.3745
Large
*
Medium -23.3233 10.52555 .027 -44.0296 -2.6169
Based on observed means.
The error term is Mean Square(Error) = 7892.716.
*. The mean difference is significant at the .05 level.
Multiple Comparisons
Dependent Variable: Amount spent
LSD
(I) Use coupons (J) Use coupons Mean Difference Std. Error Sig. 95% Confidence Interval
(I-J) Lower Bound Upper Bound
From newspaper 5.3267 13.20600 .687 -20.6527 31.3062
No From mailings -52.7851* 12.53287 .000 -77.4403 -28.1299
From both -59.6189* 13.93611 .000 -87.0346 -32.2031
No -5.3267 13.20600 .687 -31.3062 20.6527
*
From newspaper From mailings -58.1118 13.23555 .000 -84.1494 -32.0743
*
From both -64.9456 14.57127 .000 -93.6108 -36.2803
*
No 52.7851 12.53287 .000 28.1299 77.4403
*
From mailings From newspaper 58.1118 13.23555 .000 32.0743 84.1494
From both -6.8338 13.96412 .625 -34.3046 20.6371
*
No 59.6189 13.93611 .000 32.2031 87.0346
From both From newspaper 64.9456* 14.57127 .000 36.2803 93.6108
From mailings 6.8338 13.96412 .625 -20.6371 34.3046
Based on observed means.
The error term is Mean Square(Error) = 7892.716.
*. The mean difference is significant at the .05 level.
v. Create a textual presentation of the result using an APA format. 7 points
The three-way analysis of variance shows that:
1. There is no significant difference on the amount spent for any size
of the store(F(2.710)=.068, p>0.05).
2. There is a significant difference on the amount spent when grouped
by gender(F(38.020)=.000, p>0.01).
3. There is a significant difference on the amount spent when grouped
according to the use of coupon(F(12.394)=.000, p>0.01).
4. There is no interaction effect between the size of the store and the
gender in the amount spent (F(.247)=0.781, p>0.05).
5. There is no interaction effect between the size of the store and the
use of coupon in the amount spent (F(.974)=0.443, p>0.05).
6. There is no interaction effect between the gender and the use of
coupon in the amount spent (F(.314)=0.815, p>0.05).
7. There is no interaction effect of the size of the store, gender and
the use of coupon in the amount spent (F(.851)=0.532, p>0.05).