Examdata

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 88

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.5768551281
R Square 0.3327618388
Adjusted R Square 0.3161991894
Standard Error 80561.651428
Observations 290

ANOVA
df SS MS F Significance F
Regression 7 912763925439 130394846491 20.091099616 8.1127932E-22
Residual 282 1830230669989 6490179681
Total 289 2742994595428

Coefficients Standard Error t Stat P-value Lower 95%


Intercept 19624813.82 37463011.6274 0.5238450666 0.6007977503 -54117824.096
price -129.6061955 34.0059682944 -3.811277902 0.000169777 -196.54394816
returns -9.879975337 10.9896697687 -0.89902386 0.3694069508 -31.512172092
s 1.5025714157 0.22276959695 6.7449572843 8.657813E-11 1.06406908996
i -631.4371265 1208.46158672 -0.522513196 0.6017232969 -3010.1872951
h -1839.451533 4833.30273565 -0.380578589 0.7038024892 -11353.382157
size 56319.104297 14263.0898519 3.9485907248 9.935882E-05 28243.4684942
markup -294761.8187 94984.9074095 -3.103248998 0.002108449 -481731.24084
Upper 95% Lower 95,0% Upper 95,0%
93367451.735 -54117824.1 93367451.735
-62.6684428 -196.5439482 -62.6684428
11.752221418 -31.51217209 11.752221418
1.9410737414 1.06406909 1.9410737414
1747.3130421 -3010.187295 1747.3130421
7674.4790906 -11353.38216 7674.4790906
84394.740099 28243.468494 84394.740099
-107792.3966 -481731.2408 -107792.3966
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.5567548835
R Square 0.3099760003
Adjusted R Square 0.2953465162
Standard Error 81780.800317
Observations 290

ANOVA
df SS MS F Significance F
Regression 6 850262493402 141710415567 21.188443712 1.6037686E-20
Residual 283 1892732102026 6688099300
Total 289 2742994595428

Coefficients Standard Error t Stat P-value Lower 95%


Intercept 9773446.989 37893160.8742 0.2579211331 0.7966552323 -64814765.897
retail_price -119.06684943 34.3479932645 -3.466486339 0.0006091825 -186.67681847
returns -12.909501415 11.1118731317 -1.161775451 0.2463055742 -34.781911623
inventories 1.5015405714 0.22614054389 6.639855665 1.600837E-10 1.05640961267
Avg income -314.21884315 1222.35272333 -0.257060697 0.7973187134 -2720.2758478
house size -2904.7223503 4894.05529374 -0.593520542 0.553306904 -12538.092323
size of product 65676.180991 14151.6980298 4.6408693044 5.312917E-06 37820.2344033
Upper 95% Lower 95,0% Upper 95,0%
84361659.875 -64814765.9 84361659.875
-51.45688038 -186.6768185 -51.45688038
8.962908793 -34.78191162 8.962908793
1.9466715301 1.0564096127 1.9466715301
2091.8381615 -2720.275848 2091.8381615
6728.6476222 -12538.09232 6728.6476222
93532.127579 37820.234403 93532.127579
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.5567548835
R Square 0.3099760003
Adjusted R Square 0.2953465162
Standard Error 81780.800317
Observations 290

ANOVA
df SS MS F Significance F
Regression 6 850262493402 141710415567 21.188443712 1.6037686E-20
Residual 283 1892732102026 6688099300
Total 289 2742994595428

Coefficients Standard Error t Stat P-value Lower 95%


Intercept 9773446.989 37893160.8742 0.2579211331 0.7966552323 -64814765.897
Unit retail price (price) -119.0668494 34.3479932645 -3.466486339 0.0006091825 -186.67681847
returns (returns) -12.90950141 11.1118731317 -1.161775451 0.2463055742 -34.781911623
Inventories in physical units (s) 1.5015405714 0.22614054389 6.639855665 1.600837E-10 1.05640961267
Average real income (i) -314.2188432 1222.35272333 -0.257060697 0.7973187134 -2720.2758478
Average household size (h) -2904.72235 4894.05529374 -0.593520542 0.553306904 -12538.092323
Size of the product (size) 65676.180991 14151.6980298 4.6408693044 5.312917E-06 37820.2344033
Tcrit from (Two Tailed test)
1.9683819234

Upper 95% Lower 95,0% Upper 95,0%


84361659.875 -64814765.9 84361659.875
-51.45688038 -186.6768185 -51.45688038
8.962908793 -34.78191162 8.962908793
1.9466715301 1.0564096127 1.9466715301
2091.8381615 -2720.275848 2091.8381615
6728.6476222 -12538.09232 6728.6476222
93532.127579 37820.234403 93532.127579
salesUnit retail price (price)
returns Inventories in physical units Average real income Average household size
137160 29 0 42115 30992 2
4000 149 245 8605 30992 2
572316 72 0 21002 30992 2
12024 148 144 22363 30992 2
1002 634 83 978 30992 2
9616 202 109 5423 30992 2
61580 64 0 7392 30992 2
5160 162 268 2749 30992 2
13704 163 143 1966 30992 2
165204 72 455 28113 30992 2
174888 32 0 34649 30998 3
3402 620 28 2098 30998 3
17740 80 0 14602 30998 3
305244 71 0 12407 30998 3
9040 160 3584 9149 30998 3
12576 171 140 3930 30998 3
21896 189 92 11051 30998 3
4968 171 210 2791 30998 3
86340 70 0 22488 30998 3
21528 151 78 9913 30998 3
3136 210 0 7872 30999 3
1692 612 3 1609 30999 3
27768 155 130 3652 30999 3
79020 70 0 17943 30999 3
10968 153 48 2671 30999 3
40100 74 153 9215 30999 3
20772 149 214 1955 30999 3
169536 31 0 56153 30999 3
9840 147 0 2387 30999 3
278028 70 0 9366 30999 3
2550 616 2 2901 30997 3
11904 199 35 9211 30997 3
104592 65 0 14829 30997 3
16180 79 0 1299 30997 3
3000 151 1 6588 30997 3
30456 151 0 1816 30997 3
384420 65 0 22985 30997 3
12288 151 28 1211 30997 3
181776 29 0 76107 30997 3
6624 156 110 8041 30997 3
10056 155 60 3964 31000 3
11880 141 99 4807 31000 3
17520 80 0 14708 31000 3
4080 155 25 3156 31000 3
169968 33 466 8989 31000 3
5872 207 116 3455 31000 3
750 658 7 2158 31000 3
48084 67 699 27732 31000 3
138996 67 0 4585 31000 3
23364 142 12 6289 31000 3
11712 152 245 2097 30999 4
4272 152 50 1334 30999 4
2904 592 8 762 30999 4
17928 140 0 2756 30999 4
7320 139 0 1485 30999 4
166608 33 0 41064 30999 4
37040 78 0 5711 30999 4
112344 67 214 -5593 30999 4
36552 68 378 6402 30999 4
4264 221 2 1065 30999 4
188856 34 0 45050 31000 2
4446 596 12 1428 31000 2
6280 141 40 9245 31000 2
17664 193 3 13884 31000 2
21480 141 1241 1495 31000 2
14364 141 102 11894 31000 2
92400 66 521 122260 31000 2
43608 141 0 5791 31000 2
48120 69 5 19516 31000 2
83724 59 419 56213 31000 2
9880 140 40 7485 30999 3
84024 65 0 35122 30999 3
235284 65 0 1846 30999 3
7976 200 0 5882 30999 3
9264 140 24 -569 30999 3
21120 141 63 -866 30999 3
23580 140 79 8193 30999 3
317328 30 0 65879 30999 3
42800 69 0 10603 30999 3
2346 608 0 2081 30999 3
34632 133 0 2898 31004 2
2364 594 0 1806 31004 2
4080 216 3 1805 31004 2
7600 81 10 9493 31004 2
315252 65 1108 28118 31004 2
3320 143 0 6165 31004 2
14880 133 123 1474 31004 2
175464 32 2180 55891 31004 2
6480 144 10 5323 31004 2
105768 65 233 15123 31004 2
20480 79 0 26223 31000 2
131712 35 2179 32678 31000 2
8168 202 0 3531 31000 2
9888 140 27 5533 31000 2
251304 68 0 5868 31000 2
5680 139 0 7205 31000 2
2376 586 0 6305 31000 2
19152 140 0 3536 31000 2
14580 141 0 8498 31000 2
76128 67 0 -2728 31000 2
148488 32 0 716 31001 1
49920 72 250 14393 31001 1
348168 65 0 -4218 31001 1
49608 133 0 3216 31001 1
12960 132 365 4610 31001 1
21232 188 80 11179 31001 1
4884 568 41 6262 31001 1
72180 65 109 3309 31001 1
34200 133 111 1409 31001 1
17448 134 305 1350 31001 1
8400 198 140 2919 31007 3
15672 122 0 9628 31007 3
45144 122 244 18916 31007 3
219096 30 0 310 31007 3
35460 72 0 25157 31007 3
4500 567 0 2578 31007 3
33732 121 535 7776 31007 3
61284 79 3800 66986 31007 3
12960 120 0 6336 31007 3
21084 73 0 9343 31007 3
570252 72 0 56881 31005 1
79160 69 0 8565 31005 1
115224 34 0 52157 31005 1
17232 123 204 7000 31005 1
1566 593 84 8308 31005 1
8008 208 37 10188 31005 1
41424 123 0 11083 31005 1
232008 71 0 16421 31005 1
8028 125 174 1722 31005 1
3160 124 184 3360 31005 1
76884 75 1306 36867 30993 0
228612 76 0 53616 30993 0
9180 86 58 6643 30993 0
9680 121 89 5769 30993 0
24552 122 70 6040 30993 0
6348 566 47 2007 30993 0
94968 37 0 27793 30993 0
19968 127 66 4861 30993 0
13240 194 122 12310 30993 0
5736 126 37 2021 30993 0
3688 207 182 8804 30996 2
200928 34 0 35296 30996 2
175704 72 0 22957 30996 2
20736 126 12 4537 30996 2
936 592 0 1047 30996 2
7200 127 175 2916 30996 2
13120 90 0 3259 30996 2
3680 123 124 6213 30996 2
10944 124 10 13106 30996 2
79104 72 0 13671 30996 2
457908 66 0 1513 31003 0
1572 602 0 675 31003 0
175596 66 776 5411 31003 0
175392 34 218 26010 31003 0
6320 211 0 2437 31003 0
10120 94 1 4660 31003 0
12912 137 116 621 31003 0
6216 135 0 361 31003 0
30492 126 0 4044 31003 0
11600 125 0 2533 31003 0
4040 129 67 1760 31005 2
37128 69 0 28572 31005 2
224220 66 0 -13596 31005 2
7896 138 95 1680 31005 2
1512 608 27 2790 31005 2
23904 136 0 -2064 31005 2
11736 133 1788 1656 31005 2
178920 35 0 131544 31005 2
8640 95 0 5820 31005 2
6480 212 0 11880 31005 2
7400 130 38 2398 31003 3
31920 132 31 5647 31003 3
12672 131 0 2205 31003 3
14620 91 0 4840 31003 3
83256 35 1429 50197 31003 3
12976 193 32 1912 31003 3
18324 131 47 6779 31003 3
64440 62 0 21224 31003 3
242748 62 0 19658 31003 3
1038 607 0 1746 31003 3
2952 140 1 11254 30997 3
10608 139 46 33485 30997 3
201108 63 866 13444 30997 3
4600 233 34 12586 30997 3
16200 131 0 12152 30997 3
5440 130 81 5039 30997 3
2928 591 21 39 30997 3
75828 63 785 9253 30997 3
9020 91 0 3732 30997 3
161352 36 0 142163 30997 3
3660 570 28 907 31007 3
14256 130 43 4241 31007 3
13144 209 0 14679 31007 3
264696 63 0 54380 31007 3
35808 131 0 3660 31007 3
20920 84 19 42591 31007 3
90360 64 0 44459 31007 3
16488 130 16 6480 31007 3
175704 35 0 21030 31007 3
6280 128 0 4758 31007 3
15504 135 81 2637 30999 1
4000 128 105 4863 30999 1
12708 129 0 2694 30999 1
50760 64 0 1529 30999 1
9800 85 22 32813 30999 1
3000 229 118 11797 30999 1
209496 31 0 39518 30999 1
708 605 54 253 30999 1
5160 134 8 1489 30999 1
96468 64 0 -2499 30999 1
64836 73 0 16122 31004 1
4644 571 61 2570 31004 1
32200 80 20 633 31004 1
6800 131 317 4380 31004 1
141864 32 0 67611 31004 1
11928 133 222 1783 31004 1
33744 133 0 8484 31004 1
12240 210 0 12725 31004 1
17820 133 0 4671 31004 1
179532 72 0 11645 31004 1
25200 127 9 8280 31005 1
118920 74 0 59022 31005 1
282912 74 0 58511 31005 1
10840 127 39 3579 31005 1
100920 33 0 17772 31005 1
10536 131 0 4542 31005 1
3880 226 9 8854 31005 1
894 600 0 2273 31005 1
23040 80 169 17362 31005 1
26160 130 606 6330 31005 1
13639 118 601 6541 30999 3
1128 630 0 964 30999 3
36174 119 0 13286 30999 3
7339 145 42 6233 30999 3
5200 216 0 3654 30999 3
144552 33 0 145405 30999 3
72192 74 0 7059 30999 3
2490 159 2 2654 30999 3
8560 89 216 9018 30999 3
202692 74 0 53304 30999 3
123552 34 0 17686 30999 1
4469 141 0 2303 30999 1
30449 114 0 13544 30999 1
4064 239 0 10756 30999 1
390504 73 0 82028 30999 1
39080 74 233 13271 30999 1
16440 138 0 6564 30999 1
138756 73 0 46242 30999 1
1596 633 2 1470 30999 1
13680 113 905 7766 30999 1
152592 34 1594 83120 30995 0
4716 128 541 9369 30995 0
89256 73 1914 34068 30995 0
1524 633 0 1500 30995 0
1280 136 635 7121 30995 0
242220 73 0 89196 30995 0
2736 148 154 921 30995 0
4088 242 0 6634 30995 0
11380 85 260 2151 30995 0
36312 120 1482 7734 30995 0
1284 641 0 2220 30996 2
3320 126 160 7961 30996 2
9560 89 0 13491 30996 2
370272 73 0 28547 30996 2
11880 133 0 3441 30996 2
140520 34 0 103149 30996 2
9324 126 0 10845 30996 2
138912 73 0 25200 30996 2
24816 132 168 4686 30996 2
4352 242 1 9395 30996 2
160920 67 0 2261 30995 3
5880 137 0 2361 30995 3
25884 127 0 11925 30995 3
10800 127 12 9173 30995 3
35260 80 40 20751 30995 3
16680 135 24 6030 30995 3
427344 67 0 423 30995 3
1302 641 12 990 30995 3
86976 36 0 16090 30995 3
4088 240 16 5323 30995 3
13248 139 0 2358 31000 2
5920 90 1 40512 31000 2
1380 634 6 1416 31000 2
220536 32 0 58870 31000 2
14616 126 8 9917 31000 2
136464 67 331 4896 31000 2
3696 142 0 585 31000 2
4800 125 0 6773 31000 2
328944 67 0 5688 31000 2
3200 242 8 2131 31000 2
Size of the product markup prod_des sup_code product_id city p_price
0 0 San miguel beer 26012 2697 1 27
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 1 146
1 0 Leche Sam whole milk 12020 2841 1 72
0 0 Baque Coffee (mild) 4183 5789 1 146
0 0 Nescafe decaf 20024 520 1 610
1 0 Marbu maria tea biscuits 9020 7278 1 192
1 0 Mistol all purpose cleaner 25002 8276 1 62
0 0 Cafe fortaleza coffee(intense) 2133 3421 1 150
0 0 Cafe fortaleza coffee (mild) 2133 7385 1 150
1 0 Leche Sam low fat milk 12020 3616 1 72
0 0 San miguel beer 26012 2697 2 29
0 0 Nescafe decaf 20024 520 2 621
1 0 Mistol all purpose cleaner 25002 8276 2 73
1 0 Leche Sam whole milk 12020 2841 2 71
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 2 152
0 0 Cafe fortaleza coffee (mild) 2133 7385 2 149
1 0 Marbu maria tea biscuits 9020 7278 2 188
0 0 Cafe fortaleza coffee(intense) 2133 3421 2 149
1 0 Leche Sam low fat milk 12020 3616 2 71
0 0 Baque Coffee (mild) 4183 5789 2 152
1 0 Marbu maria tea biscuits 9020 7278 3 198
0 0 Nescafe decaf 20024 520 3 614
0 0 Cafe fortaleza coffee (mild) 2133 7385 3 150
1 0 Leche Sam low fat milk 12020 3616 3 70
0 0 Cafe fortaleza coffee(intense) 2133 3421 3 150
1 0 Mistol all purpose cleaner 25002 8276 3 74
0 0 Baque Coffee (mild) 4183 5789 3 148
0 0 San miguel beer 26012 2697 3 30
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 3 148
1 0 Leche Sam whole milk 12020 2841 3 70
0 0 Nescafe decaf 20024 520 4 613
1 0 Marbu maria tea biscuits 9020 7278 4 196
1 0 Leche Sam low fat milk 12020 3616 4 65
1 0 Mistol all purpose cleaner 25002 8276 4 76
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 4 149
0 0 Cafe fortaleza coffee (mild) 2133 7385 4 149
1 0 Leche Sam whole milk 12020 2841 4 65
0 0 Cafe fortaleza coffee(intense) 2133 3421 4 149
0 0 San miguel beer 26012 2697 4 29
0 0 Baque Coffee (mild) 4183 5789 4 149
0 0 Cafe fortaleza coffee (mild) 2133 7385 5 148
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 5 141
1 0 Mistol all purpose cleaner 25002 8276 5 77
0 0 Cafe fortaleza coffee(intense) 2133 3421 5 148
0 0 San miguel beer 26012 2697 5 30
1 0 Marbu maria tea biscuits 9020 7278 5 204
0 0 Nescafe decaf 20024 520 5 633
1 0 Leche Sam low fat milk 12020 3616 5 65
1 0 Leche Sam whole milk 12020 2841 5 65
0 0 Baque Coffee (mild) 4183 5789 5 142
0 0 Cafe fortaleza coffee (mild) 2133 7385 6 146
0 0 Cafe fortaleza coffee(intense) 2133 3421 6 145
0 0 Nescafe decaf 20024 520 6 581
0 0 Baque Coffee (mild) 4183 5789 6 140
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 6 140
0 0 San miguel beer 26012 2697 6 31
1 0 Mistol all purpose cleaner 25002 8276 6 77
1 0 Leche Sam whole milk 12020 2841 6 65
1 0 Leche Sam low fat milk 12020 3616 6 65
1 0 Marbu maria tea biscuits 9020 7278 6 193
0 0 San miguel beer 26012 2697 7 31
0 0 Nescafe decaf 20024 520 7 590
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 7 140
1 0 Marbu maria tea biscuits 9020 7278 7 188
0 0 Cafe fortaleza coffee(intense) 2133 3421 7 140
0 0 Baque Coffee (mild) 4183 5789 7 140
1 0 Leche Sam whole milk 12020 2841 7 63
0 0 Cafe fortaleza coffee (mild) 2133 7385 7 140
1 0 Mistol all purpose cleaner 25002 8276 7 67
1 0 Leche Sam low fat milk 12020 3616 7 56
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 8 139
1 0 Leche Sam low fat milk 12020 3616 8 64
1 0 Leche Sam whole milk 12020 2841 8 64
1 0 Marbu maria tea biscuits 9020 7278 8 189
0 0 Cafe fortaleza coffee(intense) 2133 3421 8 138
0 0 Cafe fortaleza coffee (mild) 2133 7385 8 138
0 0 Baque Coffee (mild) 4183 5789 8 139
0 0 San miguel beer 26012 2697 8 30
1 0 Mistol all purpose cleaner 25002 8276 8 68
0 0 Nescafe decaf 20024 520 8 600
0 0 Cafe fortaleza coffee (mild) 2133 7385 9 133
0 0 Nescafe decaf 20024 520 9 594
1 0 Marbu maria tea biscuits 9020 7278 9 188
1 0 Mistol all purpose cleaner 25002 8276 9 69
1 0 Leche Sam whole milk 12020 2841 9 65
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 9 139
0 0 Cafe fortaleza coffee(intense) 2133 3421 9 133
0 0 San miguel beer 26012 2697 9 30
0 0 Baque Coffee (mild) 4183 5789 9 139
1 0 Leche Sam low fat milk 12020 3616 9 65
1 0 Mistol all purpose cleaner 25002 8276 10 71
0 0 San miguel beer 26012 2697 10 30
1 0 Marbu maria tea biscuits 9020 7278 10 188
0 0 Cafe fortaleza coffee(intense) 2133 3421 10 135
1 0 Leche Sam whole milk 12020 2841 10 64
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 10 138
0 0 Nescafe decaf 20024 520 10 567
0 0 Cafe fortaleza coffee (mild) 2133 7385 10 134
0 0 Baque Coffee (mild) 4183 5789 10 138
1 0 Leche Sam low fat milk 12020 3616 10 65
0 0 San miguel beer 26012 2697 11 29
1 0 Mistol all purpose cleaner 25002 8276 11 71
1 0 Leche Sam whole milk 12020 2841 11 65
0 0 Cafe fortaleza coffee (mild) 2133 7385 11 133
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 11 133
1 0 Marbu maria tea biscuits 9020 7278 11 188
0 0 Nescafe decaf 20024 520 11 564
1 0 Leche Sam low fat milk 12020 3616 11 65
0 0 Baque Coffee (mild) 4183 5789 11 133
0 0 Cafe fortaleza coffee(intense) 2133 3421 11 134
1 0 Marbu maria tea biscuits 9020 7278 12 188
0 0 Cafe fortaleza coffee(intense) 2133 3421 12 122
0 0 Cafe fortaleza coffee (mild) 2133 7385 12 122
0 0 San miguel beer 26012 2697 12 29
1 0 Mistol all purpose cleaner 25002 8276 12 71
0 0 Nescafe decaf 20024 520 12 567
0 0 Baque Coffee (mild) 4183 5789 12 121
1 0 Leche Sam whole milk 12020 2841 12 71
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 12 120
1 0 Leche Sam low fat milk 12020 3616 12 71
1 0 Leche Sam whole milk 12020 2841 13 71
1 0 Mistol all purpose cleaner 25002 8276 13 68
0 0 San miguel beer 26012 2697 13 29
0 0 Cafe fortaleza coffee(intense) 2133 3421 13 122
0 0 Nescafe decaf 20024 520 13 565
1 0 Marbu maria tea biscuits 9020 7278 13 190
0 0 Cafe fortaleza coffee (mild) 2133 7385 13 122
1 0 Leche Sam low fat milk 12020 3616 13 71
0 0 Baque Coffee (mild) 4183 5789 13 119
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 13 119
1 0 Leche Sam low fat milk 12020 3616 14 73
1 0 Leche Sam whole milk 12020 2841 14 73
1 0 Mistol all purpose cleaner 25002 8276 14 84
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 14 122
0 0 Baque Coffee (mild) 4183 5789 14 122
0 0 Nescafe decaf 20024 520 14 566
0 0 San miguel beer 26012 2697 14 34
0 0 Cafe fortaleza coffee (mild) 2133 7385 14 124
1 0 Marbu maria tea biscuits 9020 7278 14 188
0 0 Cafe fortaleza coffee(intense) 2133 3421 14 123
1 0 Marbu maria tea biscuits 9020 7278 15 194
0 0 San miguel beer 26012 2697 15 34
1 0 Leche Sam whole milk 12020 2841 15 71
0 0 Cafe fortaleza coffee (mild) 2133 7385 15 123
0 0 Nescafe decaf 20024 520 15 578
0 0 Cafe fortaleza coffee(intense) 2133 3421 15 123
1 0 Mistol all purpose cleaner 25002 8276 15 80
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 15 122
0 0 Baque Coffee (mild) 4183 5789 15 122
1 0 Leche Sam low fat milk 12020 3616 15 71
1 0 Leche Sam whole milk 12020 2841 16 66
0 0 Nescafe decaf 20024 520 16 574
1 0 Leche Sam low fat milk 12020 3616 16 66
0 0 San miguel beer 26012 2697 16 33
1 0 Marbu maria tea biscuits 9020 7278 16 191
1 0 Mistol all purpose cleaner 25002 8276 16 85
0 0 Cafe fortaleza coffee (mild) 2133 7385 16 123
0 0 Cafe fortaleza coffee(intense) 2133 3421 16 123
0 0 Baque Coffee (mild) 4183 5789 16 124
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 16 124
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 17 123
1 0 Leche Sam low fat milk 12020 3616 17 64
1 0 Leche Sam whole milk 12020 2841 17 63
0 0 Cafe fortaleza coffee(intense) 2133 3421 17 128
0 0 Nescafe decaf 20024 520 17 586
0 0 Cafe fortaleza coffee (mild) 2133 7385 17 128
0 0 Baque Coffee (mild) 4183 5789 17 123
0 0 San miguel beer 26012 2697 17 33
1 0 Mistol all purpose cleaner 25002 8276 17 85
1 0 Marbu maria tea biscuits 9020 7278 17 192
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 18 129
0 0 Cafe fortaleza coffee (mild) 2133 7385 18 130
0 0 Cafe fortaleza coffee(intense) 2133 3421 18 130
1 0 Mistol all purpose cleaner 25002 8276 18 79
0 0 San miguel beer 26012 2697 18 33
1 0 Marbu maria tea biscuits 9020 7278 18 188
0 0 Baque Coffee (mild) 4183 5789 18 129
1 0 Leche Sam low fat milk 12020 3616 18 63
1 0 Leche Sam whole milk 12020 2841 18 63
0 0 Nescafe decaf 20024 520 18 594
0 0 Cafe fortaleza coffee(intense) 2133 3421 19 128
0 0 Cafe fortaleza coffee (mild) 2133 7385 19 128
1 0 Leche Sam whole milk 12020 2841 19 61
1 0 Marbu maria tea biscuits 9020 7278 19 204
0 0 Baque Coffee (mild) 4183 5789 19 130
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 19 130
0 0 Nescafe decaf 20024 520 19 586
1 0 Leche Sam low fat milk 12020 3616 19 61
1 0 Mistol all purpose cleaner 25002 8276 19 81
0 0 San miguel beer 26012 2697 19 34
0 0 Nescafe decaf 20024 520 20 566
0 0 Cafe fortaleza coffee(intense) 2133 3421 20 128
1 0 Marbu maria tea biscuits 9020 7278 20 206
1 0 Leche Sam whole milk 12020 2841 20 63
0 0 Cafe fortaleza coffee (mild) 2133 7385 20 128
1 0 Mistol all purpose cleaner 25002 8276 20 82
1 0 Leche Sam low fat milk 12020 3616 20 63
0 0 Baque Coffee (mild) 4183 5789 20 126
0 0 San miguel beer 26012 2697 20 34
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 20 125
0 0 Cafe fortaleza coffee (mild) 2133 7385 21 128
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 21 125
0 0 Baque Coffee (mild) 4183 5789 21 125
1 0 Leche Sam low fat milk 12020 3616 21 62
1 0 Mistol all purpose cleaner 25002 8276 21 80
1 0 Marbu maria tea biscuits 9020 7278 21 205
0 0 San miguel beer 26012 2697 21 30
0 0 Nescafe decaf 20024 520 21 565
0 0 Cafe fortaleza coffee(intense) 2133 3421 21 128
1 0 Leche Sam whole milk 12020 2841 21 62
1 0 Leche Sam low fat milk 12020 3616 22 70
0 0 Nescafe decaf 20024 520 22 565
1 0 Mistol all purpose cleaner 25002 8276 22 80
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 22 124
0 0 San miguel beer 26012 2697 22 30
0 0 Cafe fortaleza coffee(intense) 2133 3421 22 129
0 0 Cafe fortaleza coffee (mild) 2133 7385 22 128
1 0 Marbu maria tea biscuits 9020 7278 22 207
0 0 Baque Coffee (mild) 4183 5789 22 125
1 0 Leche Sam whole milk 12020 2841 22 70
0 0 Baque Coffee (mild) 4183 5789 23 126
1 0 Leche Sam low fat milk 12020 3616 23 72
1 0 Leche Sam whole milk 12020 2841 23 72
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 23 126
0 0 San miguel beer 26012 2697 23 31
0 0 Cafe fortaleza coffee(intense) 2133 3421 23 129
1 0 Marbu maria tea biscuits 9020 7278 23 203
0 0 Nescafe decaf 20024 520 23 546
1 0 Mistol all purpose cleaner 25002 8276 23 79
0 0 Cafe fortaleza coffee (mild) 2133 7385 23 129
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 24 117
0 0 Nescafe decaf 20024 520 24 598
0 0 Baque Coffee (mild) 4183 5789 24 118
0 0 Cafe fortaleza coffee (mild) 2133 7385 24 132
1 0 Marbu maria tea biscuits 9020 7278 24 212
0 0 San miguel beer 26012 2697 24 32
1 0 Leche Sam low fat milk 12020 3616 24 72
0 0 Cafe fortaleza coffee(intense) 2133 3421 24 133
1 0 Mistol all purpose cleaner 25002 8276 24 83
1 0 Leche Sam whole milk 12020 2841 24 72
0 0 San miguel beer 26012 2697 25 32
0 0 Cafe fortaleza coffee(intense) 2133 3421 25 129
0 0 Baque Coffee (mild) 4183 5789 25 113
1 0 Marbu maria tea biscuits 9020 7278 25 212
1 0 Leche Sam whole milk 12020 2841 25 72
1 0 Mistol all purpose cleaner 25002 8276 25 72
0 0 Cafe fortaleza coffee (mild) 2133 7385 25 128
1 0 Leche Sam low fat milk 12020 3616 25 72
0 0 Nescafe decaf 20024 520 25 607
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 25 113
0 0 San miguel beer 26012 2697 26 33
0 0 Baque Coffee (mild) 4183 5789 26 113
1 0 Leche Sam low fat milk 12020 3616 26 73
0 0 Nescafe decaf 20024 520 26 608
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 26 113
1 0 Leche Sam whole milk 12020 2841 26 73
0 0 Cafe fortaleza coffee(intense) 2133 3421 26 129
1 0 Marbu maria tea biscuits 9020 7278 26 219
1 0 Mistol all purpose cleaner 25002 8276 26 79
0 0 Cafe fortaleza coffee (mild) 2133 7385 26 119
0 0 Nescafe decaf 20024 520 27 609
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 27 118
1 0 Mistol all purpose cleaner 25002 8276 27 79
1 0 Leche Sam whole milk 12020 2841 27 72
0 0 Cafe fortaleza coffee(intense) 2133 3421 27 131
0 0 San miguel beer 26012 2697 27 33
0 0 Baque Coffee (mild) 4183 5789 27 118
1 0 Leche Sam low fat milk 12020 3616 27 72
0 0 Cafe fortaleza coffee (mild) 2133 7385 27 131
1 0 Marbu maria tea biscuits 9020 7278 27 216
1 0 Leche Sam low fat milk 12020 3616 28 66
0 0 Cafe fortaleza coffee(intense) 2133 3421 28 128
0 0 Baque Coffee (mild) 4183 5789 28 127
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 28 127
1 0 Mistol all purpose cleaner 25002 8276 28 79
0 0 Cafe fortaleza coffee (mild) 2133 7385 28 128
1 0 Leche Sam whole milk 12020 2841 28 66
0 0 Nescafe decaf 20024 520 28 609
0 0 San miguel beer 26012 2697 28 35
1 0 Marbu maria tea biscuits 9020 7278 28 215
0 0 Cafe fortaleza coffee (mild) 2133 7385 29 128
1 0 Mistol all purpose cleaner 25002 8276 29 84
0 0 Nescafe decaf 20024 520 29 605
0 0 San miguel beer 26012 2697 29 30
0 0 Baque Coffee (mild) 4183 5789 29 122
1 0 Leche Sam low fat milk 12020 3616 29 67
0 0 Cafe fortaleza coffee(intense) 2133 3421 29 128
0 0 CAFE BAQUE SUPER.GRANO 250 G 4183 4993 29 122
1 0 Leche Sam whole milk 12020 2841 29 67
1 0 Marbu maria tea biscuits 9020 7278 29 215
p_sales w_price
62208 27
3080 143
570648 70
9720 143
450 624
5552 193
54220 79
2136 150
4944 150
164832 71
55800 30
2586 621
3700 78
289488 70
8960 143
96 150
20640 193
48 150
81300 70
20736 143
888 193
1308 621
18984 146
70776 64
8184 146
35500 78
19656 143
72000 29
9160 143
232020 64
2358 621
10704 193
95916 64
7400 78
2320 143
27672 146
356580 64
11232 146
162240 30
3600 143
6384 140
11520 138
9080 79
2640 140
60528 30
4904 193
66 621
25752 64
70260 64
22500 138
5760 140
2088 140
2304 578
16776 138
6960 138
64944 30
31380 79
40932 64
12720 64
632 209
61656 29
3954 615
5760 136
15680 193
20472 138
13032 136
17520 62
40368 138
43900 76
59388 62
9800 135
71064 62
192984 62
5432 193
8184 138
18336 131
22860 135
276480 29
39940 76
1980 615
33888 131
2328 605
936 193
1400 76
303528 67
2600 134
14472 131
90456 30
4752 134
98856 65
11940 69
31824 30
4944 197
6264 131
138744 65
4760 134
1812 556
11568 131
11232 134
28308 64
62448 29
45500 79
319068 71
48600 131
12920 134
20784 192
4482 576
71532 64
33876 134
17088 131
5936 192
15024 119
43776 119
196992 29
32540 67
4434 576
33408 116
2592 73
12920 116
864 69
505488 76
71980 81
52632 34
15960 120
756 573
3576 193
37464 120
206076 72
4860 120
2200 120
42468 72
134628 72
1900 81
9480 120
23292 120
6270 573
33984 32
14304 123
10872 193
4128 123
1560 193
174504 32
146640 67
17016 123
396 573
5784 123
4060 86
3440 120
9612 120
64860 67
456924 66
402 571
174948 66
127176 34
2184 193
700 88
3912 130
2520 130
27252 120
10840 120
2280 120
4956 63
124980 63
4200 125
156 571
13272 125
5112 120
89616 32
1620 84
2248 194
6440 124
28536 128
11496 128
3260 84
43416 32
11344 208
14544 124
45672 64
230916 64
108 571
1008 125
4608 125
147864 60
720 203
14652 124
5120 124
2328 571
56316 60
660 81
68760 32
3282 571
12552 125
11520 203
230064 60
30216 125
15600 81
76728 60
12204 123
130032 32
5400 123
9720 125
3280 123
9612 123
36396 66
4600 81
872 203
172272 32
108 571
3528 125
61392 66
2532 69
3948 571
30640 81
4360 123
89736 29
8808 128
25224 128
10736 203
10296 123
6756 69
23184 122
66000 73
158208 73
9960 122
50256 32
9912 128
1360 203
186 591
21040 80
23856 128
12840 116
30 591
33840 116
216 128
4400 203
100368 32
43980 73
144 128
1040 80
120552 73
51624 32
1488 128
28872 109
360 215
297420 73
31800 80
7536 128
107280 73
204 601
13200 109
124248 32
1296 109
77424 71
384 601
640 109
209040 71
24 128
488 215
3600 80
33840 117
42 601
880 120
1360 83
290796 68
10200 126
120744 32
1800 120
112212 68
22800 126
640 215
144792 68
3120 126
23904 120
10560 120
32380 83
10248 126
373632 68
24 601
57144 32
736 215
4680 126
600 83
294 601
167016 32
10836 120
127392 64
936 126
4040 120
280944 64
408 215
sales wholesale_price retail_price returns inventories Avg income house size size of product markup
137160 27 29 0 42115 30992 2 0 0
4000 143 149 245 8605 30992 2 0 0
572316 70 72 0 21002 30992 2 1 0
12024 143 148 144 22363 30992 2 0 0
1002 624 634 83 978 30992 2 0 0
9616 193 202 109 5423 30992 2 1 0
61580 79 64 0 7392 30992 2 1 0
5160 150 162 268 2749 30992 2 0 0
13704 150 163 143 1966 30992 2 0 0
165204 71 72 455 28113 30992 2 1 0
174888 30 32 0 34649 30998 3 0 0
3402 621 620 28 2098 30998 3 0 0
17740 78 80 0 14602 30998 3 1 0
305244 70 71 0 12407 30998 3 1 0
9040 143 160 3584 9149 30998 3 0 0
12576 150 171 140 3930 30998 3 0 0
21896 193 189 92 11051 30998 3 1 0
4968 150 171 210 2791 30998 3 0 0
86340 70 70 0 22488 30998 3 1 0
21528 143 151 78 9913 30998 3 0 0
3136 193 210 0 7872 30999 3 1 0
1692 621 612 3 1609 30999 3 0 0
27768 146 155 130 3652 30999 3 0 0
79020 64 70 0 17943 30999 3 1 0
10968 146 153 48 2671 30999 3 0 0
40100 78 74 153 9215 30999 3 1 0
20772 143 149 214 1955 30999 3 0 0
169536 29 31 0 56153 30999 3 0 0
9840 143 147 0 2387 30999 3 0 0
278028 64 70 0 9366 30999 3 1 0
2550 621 616 2 2901 30997 3 0 0
11904 193 199 35 9211 30997 3 1 0
104592 64 65 0 14829 30997 3 1 0
16180 78 79 0 1299 30997 3 1 0
3000 143 151 1 6588 30997 3 0 0
30456 146 151 0 1816 30997 3 0 0
384420 64 65 0 22985 30997 3 1 0
12288 146 151 28 1211 30997 3 0 0
181776 30 29 0 76107 30997 3 0 0
6624 143 156 110 8041 30997 3 0 0
10056 140 155 60 3964 31000 3 0 0
11880 138 141 99 4807 31000 3 0 0
17520 79 80 0 14708 31000 3 1 0
4080 140 155 25 3156 31000 3 0 0
169968 30 33 466 8989 31000 3 0 0
5872 193 207 116 3455 31000 3 1 0
750 621 658 7 2158 31000 3 0 0
48084 64 67 699 27732 31000 3 1 0
138996 64 67 0 4585 31000 3 1 0
23364 138 142 12 6289 31000 3 0 0
11712 140 152 245 2097 30999 4 0 0
4272 140 152 50 1334 30999 4 0 0
2904 578 592 8 762 30999 4 0 0
17928 138 140 0 2756 30999 4 0 0
7320 138 139 0 1485 30999 4 0 0
166608 30 33 0 41064 30999 4 0 0
37040 79 78 0 5711 30999 4 1 0
112344 64 67 214 -5593 30999 4 1 0
36552 64 68 378 6402 30999 4 1 0
4264 209 221 2 1065 30999 4 1 0
188856 29 34 0 45050 31000 2 0 0
4446 615 596 12 1428 31000 2 0 0
6280 136 141 40 9245 31000 2 0 0
17664 193 193 3 13884 31000 2 1 0
21480 138 141 1241 1495 31000 2 0 0
14364 136 141 102 11894 31000 2 0 0
92400 62 66 521 122260 31000 2 1 0
43608 138 141 0 5791 31000 2 0 0
48120 76 69 5 19516 31000 2 1 0
83724 62 59 419 56213 31000 2 1 0
9880 135 140 40 7485 30999 3 0 0
84024 62 65 0 35122 30999 3 1 0
235284 62 65 0 1846 30999 3 1 0
7976 193 200 0 5882 30999 3 1 0
9264 138 140 24 -569 30999 3 0 0
21120 131 141 63 -866 30999 3 0 0
23580 135 140 79 8193 30999 3 0 0
317328 29 30 0 65879 30999 3 0 0
42800 76 69 0 10603 30999 3 1 0
2346 615 608 0 2081 30999 3 0 0
34632 131 133 0 2898 31004 2 0 0
2364 605 594 0 1806 31004 2 0 0
4080 193 216 3 1805 31004 2 1 0
7600 76 81 10 9493 31004 2 1 0
315252 67 65 1108 28118 31004 2 1 0
3320 134 143 0 6165 31004 2 0 0
14880 131 133 123 1474 31004 2 0 0
175464 30 32 2180 55891 31004 2 0 0
6480 134 144 10 5323 31004 2 0 0
105768 65 65 233 15123 31004 2 1 0
20480 69 79 0 26223 31000 2 1 0
131712 30 35 2179 32678 31000 2 0 0
8168 197 202 0 3531 31000 2 1 0
9888 131 140 27 5533 31000 2 0 0
251304 65 68 0 5868 31000 2 1 0
5680 134 139 0 7205 31000 2 0 0
2376 556 586 0 6305 31000 2 0 0
19152 131 140 0 3536 31000 2 0 0
14580 134 141 0 8498 31000 2 0 0
76128 64 67 0 -2728 31000 2 1 0
148488 29 32 0 716 31001 1 0 0
49920 79 72 250 14393 31001 1 1 0
348168 71 65 0 -4218 31001 1 1 0
49608 131 133 0 3216 31001 1 0 0
12960 134 132 365 4610 31001 1 0 0
21232 192 188 80 11179 31001 1 1 0
4884 576 568 41 6262 31001 1 0 0
72180 64 65 109 3309 31001 1 1 0
34200 134 133 111 1409 31001 1 0 0
17448 131 134 305 1350 31001 1 0 0
8400 192 198 140 2919 31007 3 1 0
15672 119 122 0 9628 31007 3 0 0
45144 119 122 244 18916 31007 3 0 0
219096 29 30 0 310 31007 3 0 0
35460 67 72 0 25157 31007 3 1 0
4500 576 567 0 2578 31007 3 0 0
33732 116 121 535 7776 31007 3 0 0
61284 73 79 3800 66986 31007 3 1 0
12960 116 120 0 6336 31007 3 0 0
21084 69 73 0 9343 31007 3 1 0
570252 76 72 0 56881 31005 1 1 0
79160 81 69 0 8565 31005 1 1 0
115224 34 34 0 52157 31005 1 0 0
17232 120 123 204 7000 31005 1 0 0
1566 573 593 84 8308 31005 1 0 0
8008 193 208 37 10188 31005 1 1 0
41424 120 123 0 11083 31005 1 0 0
232008 72 71 0 16421 31005 1 1 0
8028 120 125 174 1722 31005 1 0 0
3160 120 124 184 3360 31005 1 0 0
76884 72 75 1306 36867 30993 0 1 0
228612 72 76 0 53616 30993 0 1 0
9180 81 86 58 6643 30993 0 1 0
9680 120 121 89 5769 30993 0 0 0
24552 120 122 70 6040 30993 0 0 0
6348 573 566 47 2007 30993 0 0 0
94968 32 37 0 27793 30993 0 0 0
19968 123 127 66 4861 30993 0 0 0
13240 193 194 122 12310 30993 0 1 0
5736 123 126 37 2021 30993 0 0 0
3688 193 207 182 8804 30996 2 1 0
200928 32 34 0 35296 30996 2 0 0
175704 67 72 0 22957 30996 2 1 0
20736 123 126 12 4537 30996 2 0 0
936 573 592 0 1047 30996 2 0 0
7200 123 127 175 2916 30996 2 0 0
13120 86 90 0 3259 30996 2 1 0
3680 120 123 124 6213 30996 2 0 0
10944 120 124 10 13106 30996 2 0 0
79104 67 72 0 13671 30996 2 1 0
457908 66 66 0 1513 31003 0 1 0
1572 571 602 0 675 31003 0 0 0
175596 66 66 776 5411 31003 0 1 0
175392 34 34 218 26010 31003 0 0 0
6320 193 211 0 2437 31003 0 1 0
10120 88 94 1 4660 31003 0 1 0
12912 130 137 116 621 31003 0 0 0
6216 130 135 0 361 31003 0 0 0
30492 120 126 0 4044 31003 0 0 0
11600 120 125 0 2533 31003 0 0 0
4040 120 129 67 1760 31005 2 0 0
37128 63 69 0 28572 31005 2 1 0
224220 63 66 0 -13596 31005 2 1 0
7896 125 138 95 1680 31005 2 0 0
1512 571 608 27 2790 31005 2 0 0
23904 125 136 0 -2064 31005 2 0 0
11736 120 133 1788 1656 31005 2 0 0
178920 32 35 0 131544 31005 2 0 0
8640 84 95 0 5820 31005 2 1 0
6480 194 212 0 11880 31005 2 1 0
7400 124 130 38 2398 31003 3 0 0
31920 128 132 31 5647 31003 3 0 0
12672 128 131 0 2205 31003 3 0 0
14620 84 91 0 4840 31003 3 1 0
83256 32 35 1429 50197 31003 3 0 0
12976 208 193 32 1912 31003 3 1 0
18324 124 131 47 6779 31003 3 0 0
64440 64 62 0 21224 31003 3 1 0
242748 64 62 0 19658 31003 3 1 0
1038 571 607 0 1746 31003 3 0 0
2952 125 140 1 11254 30997 3 0 0
10608 125 139 46 33485 30997 3 0 0
201108 60 63 866 13444 30997 3 1 0
4600 203 233 34 12586 30997 3 1 0
16200 124 131 0 12152 30997 3 0 0
5440 124 130 81 5039 30997 3 0 0
2928 571 591 21 39 30997 3 0 0
75828 60 63 785 9253 30997 3 1 0
9020 81 91 0 3732 30997 3 1 0
161352 32 36 0 142163 30997 3 0 0
3660 571 570 28 907 31007 3 0 0
14256 125 130 43 4241 31007 3 0 0
13144 203 209 0 14679 31007 3 1 0
264696 60 63 0 54380 31007 3 1 0
35808 125 131 0 3660 31007 3 0 0
20920 81 84 19 42591 31007 3 1 0
90360 60 64 0 44459 31007 3 1 0
16488 123 130 16 6480 31007 3 0 0
175704 32 35 0 21030 31007 3 0 0
6280 123 128 0 4758 31007 3 0 0
15504 125 135 81 2637 30999 1 0 0
4000 123 128 105 4863 30999 1 0 0
12708 123 129 0 2694 30999 1 0 0
50760 66 64 0 1529 30999 1 1 0
9800 81 85 22 32813 30999 1 1 0
3000 203 229 118 11797 30999 1 1 0
209496 32 31 0 39518 30999 1 0 0
708 571 605 54 253 30999 1 0 0
5160 125 134 8 1489 30999 1 0 0
96468 66 64 0 -2499 30999 1 1 0
64836 69 73 0 16122 31004 1 1 0
4644 571 571 61 2570 31004 1 0 0
32200 81 80 20 633 31004 1 1 0
6800 123 131 317 4380 31004 1 0 0
141864 29 32 0 67611 31004 1 0 0
11928 128 133 222 1783 31004 1 0 0
33744 128 133 0 8484 31004 1 0 0
12240 203 210 0 12725 31004 1 1 0
17820 123 133 0 4671 31004 1 0 0
179532 69 72 0 11645 31004 1 1 0
25200 122 127 9 8280 31005 1 0 0
118920 73 74 0 59022 31005 1 1 0
282912 73 74 0 58511 31005 1 1 0
10840 122 127 39 3579 31005 1 0 0
100920 32 33 0 17772 31005 1 0 0
10536 128 131 0 4542 31005 1 0 0
3880 203 226 9 8854 31005 1 1 0
894 591 600 0 2273 31005 1 0 0
23040 80 80 169 17362 31005 1 1 0
26160 128 130 606 6330 31005 1 0 0
13639 116 118 601 6541 30999 3 0 0
1128 591 630 0 964 30999 3 0 0
36174 116 119 0 13286 30999 3 0 0
7339 128 145 42 6233 30999 3 0 0
5200 203 216 0 3654 30999 3 1 0
144552 32 33 0 145405 30999 3 0 0
72192 73 74 0 7059 30999 3 1 0
2490 128 159 2 2654 30999 3 0 0
8560 80 89 216 9018 30999 3 1 0
202692 73 74 0 53304 30999 3 1 0
123552 32 34 0 17686 30999 1 0 0
4469 128 141 0 2303 30999 1 0 0
30449 109 114 0 13544 30999 1 0 0
4064 215 239 0 10756 30999 1 1 0
390504 73 73 0 82028 30999 1 1 0
39080 80 74 233 13271 30999 1 1 0
16440 128 138 0 6564 30999 1 0 0
138756 73 73 0 46242 30999 1 1 0
1596 601 633 2 1470 30999 1 0 0
13680 109 113 905 7766 30999 1 0 0
152592 32 34 1594 83120 30995 0 0 0
4716 109 128 541 9369 30995 0 0 0
89256 71 73 1914 34068 30995 0 1 0
1524 601 633 0 1500 30995 0 0 0
1280 109 136 635 7121 30995 0 0 0
242220 71 73 0 89196 30995 0 1 0
2736 128 148 154 921 30995 0 0 0
4088 215 242 0 6634 30995 0 1 0
11380 80 85 260 2151 30995 0 1 0
36312 117 120 1482 7734 30995 0 0 0
1284 601 641 0 2220 30996 2 0 0
3320 120 126 160 7961 30996 2 0 0
9560 83 89 0 13491 30996 2 1 0
370272 68 73 0 28547 30996 2 1 0
11880 126 133 0 3441 30996 2 0 0
140520 32 34 0 103149 30996 2 0 0
9324 120 126 0 10845 30996 2 0 0
138912 68 73 0 25200 30996 2 1 0
24816 126 132 168 4686 30996 2 0 0
4352 215 242 1 9395 30996 2 1 0
160920 68 67 0 2261 30995 3 1 0
5880 126 137 0 2361 30995 3 0 0
25884 120 127 0 11925 30995 3 0 0
10800 120 127 12 9173 30995 3 0 0
35260 83 80 40 20751 30995 3 1 0
16680 126 135 24 6030 30995 3 0 0
427344 68 67 0 423 30995 3 1 0
1302 601 641 12 990 30995 3 0 0
86976 32 36 0 16090 30995 3 0 0
4088 215 240 16 5323 30995 3 1 0
13248 126 139 0 2358 31000 2 0 0
5920 83 90 1 40512 31000 2 1 0
1380 601 634 6 1416 31000 2 0 0
220536 32 32 0 58870 31000 2 0 0
14616 120 126 8 9917 31000 2 0 0
136464 64 67 331 4896 31000 2 1 0
3696 126 142 0 585 31000 2 0 0
4800 120 125 0 6773 31000 2 0 0
328944 64 67 0 5688 31000 2 1 0
3200 215 242 8 2131 31000 2 1 0
prod_des sup_code product_id city p_price p_sales
San miguel beer 26012 2697 1 27 62208
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 1 146 3080
Leche Sam whole milk 12020 2841 1 72 570648
Baque Coffee (mild) 4183 5789 1 146 9720
Nescafe decaf 20024 520 1 610 450
Marbu maria tea biscuits 9020 7278 1 192 5552
Mistol all purpose cleaner 25002 8276 1 62 54220
Cafe fortaleza coffee(intense) 2133 3421 1 150 2136
Cafe fortaleza coffee (mild) 2133 7385 1 150 4944
Leche Sam low fat milk 12020 3616 1 72 164832
San miguel beer 26012 2697 2 29 55800
Nescafe decaf 20024 520 2 621 2586
Mistol all purpose cleaner 25002 8276 2 73 3700
Leche Sam whole milk 12020 2841 2 71 289488
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 2 152 8960
Cafe fortaleza coffee (mild) 2133 7385 2 149 96
Marbu maria tea biscuits 9020 7278 2 188 20640
Cafe fortaleza coffee(intense) 2133 3421 2 149 48
Leche Sam low fat milk 12020 3616 2 71 81300
Baque Coffee (mild) 4183 5789 2 152 20736
Marbu maria tea biscuits 9020 7278 3 198 888
Nescafe decaf 20024 520 3 614 1308
Cafe fortaleza coffee (mild) 2133 7385 3 150 18984
Leche Sam low fat milk 12020 3616 3 70 70776
Cafe fortaleza coffee(intense) 2133 3421 3 150 8184
Mistol all purpose cleaner 25002 8276 3 74 35500
Baque Coffee (mild) 4183 5789 3 148 19656
San miguel beer 26012 2697 3 30 72000
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 3 148 9160
Leche Sam whole milk 12020 2841 3 70 232020
Nescafe decaf 20024 520 4 613 2358
Marbu maria tea biscuits 9020 7278 4 196 10704
Leche Sam low fat milk 12020 3616 4 65 95916
Mistol all purpose cleaner 25002 8276 4 76 7400
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 4 149 2320
Cafe fortaleza coffee (mild) 2133 7385 4 149 27672
Leche Sam whole milk 12020 2841 4 65 356580
Cafe fortaleza coffee(intense) 2133 3421 4 149 11232
San miguel beer 26012 2697 4 29 162240
Baque Coffee (mild) 4183 5789 4 149 3600
Cafe fortaleza coffee (mild) 2133 7385 5 148 6384
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 5 141 11520
Mistol all purpose cleaner 25002 8276 5 77 9080
Cafe fortaleza coffee(intense) 2133 3421 5 148 2640
San miguel beer 26012 2697 5 30 60528
Marbu maria tea biscuits 9020 7278 5 204 4904
Nescafe decaf 20024 520 5 633 66
Leche Sam low fat milk 12020 3616 5 65 25752
Leche Sam whole milk 12020 2841 5 65 70260
Baque Coffee (mild) 4183 5789 5 142 22500
Cafe fortaleza coffee (mild) 2133 7385 6 146 5760
Cafe fortaleza coffee(intense) 2133 3421 6 145 2088
Nescafe decaf 20024 520 6 581 2304
Baque Coffee (mild) 4183 5789 6 140 16776
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 6 140 6960
San miguel beer 26012 2697 6 31 64944
Mistol all purpose cleaner 25002 8276 6 77 31380
Leche Sam whole milk 12020 2841 6 65 40932
Leche Sam low fat milk 12020 3616 6 65 12720
Marbu maria tea biscuits 9020 7278 6 193 632
San miguel beer 26012 2697 7 31 61656
Nescafe decaf 20024 520 7 590 3954
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 7 140 5760
Marbu maria tea biscuits 9020 7278 7 188 15680
Cafe fortaleza coffee(intense) 2133 3421 7 140 20472
Baque Coffee (mild) 4183 5789 7 140 13032
Leche Sam whole milk 12020 2841 7 63 17520
Cafe fortaleza coffee (mild) 2133 7385 7 140 40368
Mistol all purpose cleaner 25002 8276 7 67 43900
Leche Sam low fat milk 12020 3616 7 56 59388
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 8 139 9800
Leche Sam low fat milk 12020 3616 8 64 71064
Leche Sam whole milk 12020 2841 8 64 192984
Marbu maria tea biscuits 9020 7278 8 189 5432
Cafe fortaleza coffee(intense) 2133 3421 8 138 8184
Cafe fortaleza coffee (mild) 2133 7385 8 138 18336
Baque Coffee (mild) 4183 5789 8 139 22860
San miguel beer 26012 2697 8 30 276480
Mistol all purpose cleaner 25002 8276 8 68 39940
Nescafe decaf 20024 520 8 600 1980
Cafe fortaleza coffee (mild) 2133 7385 9 133 33888
Nescafe decaf 20024 520 9 594 2328
Marbu maria tea biscuits 9020 7278 9 188 936
Mistol all purpose cleaner 25002 8276 9 69 1400
Leche Sam whole milk 12020 2841 9 65 303528
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 9 139 2600
Cafe fortaleza coffee(intense) 2133 3421 9 133 14472
San miguel beer 26012 2697 9 30 90456
Baque Coffee (mild) 4183 5789 9 139 4752
Leche Sam low fat milk 12020 3616 9 65 98856
Mistol all purpose cleaner 25002 8276 10 71 11940
San miguel beer 26012 2697 10 30 31824
Marbu maria tea biscuits 9020 7278 10 188 4944
Cafe fortaleza coffee(intense) 2133 3421 10 135 6264
Leche Sam whole milk 12020 2841 10 64 138744
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 10 138 4760
Nescafe decaf 20024 520 10 567 1812
Cafe fortaleza coffee (mild) 2133 7385 10 134 11568
Baque Coffee (mild) 4183 5789 10 138 11232
Leche Sam low fat milk 12020 3616 10 65 28308
San miguel beer 26012 2697 11 29 62448
Mistol all purpose cleaner 25002 8276 11 71 45500
Leche Sam whole milk 12020 2841 11 65 319068
Cafe fortaleza coffee (mild) 2133 7385 11 133 48600
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 11 133 12920
Marbu maria tea biscuits 9020 7278 11 188 20784
Nescafe decaf 20024 520 11 564 4482
Leche Sam low fat milk 12020 3616 11 65 71532
Baque Coffee (mild) 4183 5789 11 133 33876
Cafe fortaleza coffee(intense) 2133 3421 11 134 17088
Marbu maria tea biscuits 9020 7278 12 188 5936
Cafe fortaleza coffee(intense) 2133 3421 12 122 15024
Cafe fortaleza coffee (mild) 2133 7385 12 122 43776
San miguel beer 26012 2697 12 29 196992
Mistol all purpose cleaner 25002 8276 12 71 32540
Nescafe decaf 20024 520 12 567 4434
Baque Coffee (mild) 4183 5789 12 121 33408
Leche Sam whole milk 12020 2841 12 71 2592
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 12 120 12920
Leche Sam low fat milk 12020 3616 12 71 864
Leche Sam whole milk 12020 2841 13 71 505488
Mistol all purpose cleaner 25002 8276 13 68 71980
San miguel beer 26012 2697 13 29 52632
Cafe fortaleza coffee(intense) 2133 3421 13 122 15960
Nescafe decaf 20024 520 13 565 756
Marbu maria tea biscuits 9020 7278 13 190 3576
Cafe fortaleza coffee (mild) 2133 7385 13 122 37464
Leche Sam low fat milk 12020 3616 13 71 206076
Baque Coffee (mild) 4183 5789 13 119 4860
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 13 119 2200
Leche Sam low fat milk 12020 3616 14 73 42468
Leche Sam whole milk 12020 2841 14 73 134628
Mistol all purpose cleaner 25002 8276 14 84 1900
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 14 122 9480
Baque Coffee (mild) 4183 5789 14 122 23292
Nescafe decaf 20024 520 14 566 6270
San miguel beer 26012 2697 14 34 33984
Cafe fortaleza coffee (mild) 2133 7385 14 124 14304
Marbu maria tea biscuits 9020 7278 14 188 10872
Cafe fortaleza coffee(intense) 2133 3421 14 123 4128
Marbu maria tea biscuits 9020 7278 15 194 1560
San miguel beer 26012 2697 15 34 174504
Leche Sam whole milk 12020 2841 15 71 146640
Cafe fortaleza coffee (mild) 2133 7385 15 123 17016
Nescafe decaf 20024 520 15 578 396
Cafe fortaleza coffee(intense) 2133 3421 15 123 5784
Mistol all purpose cleaner 25002 8276 15 80 4060
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 15 122 3440
Baque Coffee (mild) 4183 5789 15 122 9612
Leche Sam low fat milk 12020 3616 15 71 64860
Leche Sam whole milk 12020 2841 16 66 456924
Nescafe decaf 20024 520 16 574 402
Leche Sam low fat milk 12020 3616 16 66 174948
San miguel beer 26012 2697 16 33 127176
Marbu maria tea biscuits 9020 7278 16 191 2184
Mistol all purpose cleaner 25002 8276 16 85 700
Cafe fortaleza coffee (mild) 2133 7385 16 123 3912
Cafe fortaleza coffee(intense) 2133 3421 16 123 2520
Baque Coffee (mild) 4183 5789 16 124 27252
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 16 124 10840
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 17 123 2280
Leche Sam low fat milk 12020 3616 17 64 4956
Leche Sam whole milk 12020 2841 17 63 124980
Cafe fortaleza coffee(intense) 2133 3421 17 128 4200
Nescafe decaf 20024 520 17 586 156
Cafe fortaleza coffee (mild) 2133 7385 17 128 13272
Baque Coffee (mild) 4183 5789 17 123 5112
San miguel beer 26012 2697 17 33 89616
Mistol all purpose cleaner 25002 8276 17 85 1620
Marbu maria tea biscuits 9020 7278 17 192 2248
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 18 129 6440
Cafe fortaleza coffee (mild) 2133 7385 18 130 28536
Cafe fortaleza coffee(intense) 2133 3421 18 130 11496
Mistol all purpose cleaner 25002 8276 18 79 3260
San miguel beer 26012 2697 18 33 43416
Marbu maria tea biscuits 9020 7278 18 188 11344
Baque Coffee (mild) 4183 5789 18 129 14544
Leche Sam low fat milk 12020 3616 18 63 45672
Leche Sam whole milk 12020 2841 18 63 230916
Nescafe decaf 20024 520 18 594 108
Cafe fortaleza coffee(intense) 2133 3421 19 128 1008
Cafe fortaleza coffee (mild) 2133 7385 19 128 4608
Leche Sam whole milk 12020 2841 19 61 147864
Marbu maria tea biscuits 9020 7278 19 204 720
Baque Coffee (mild) 4183 5789 19 130 14652
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 19 130 5120
Nescafe decaf 20024 520 19 586 2328
Leche Sam low fat milk 12020 3616 19 61 56316
Mistol all purpose cleaner 25002 8276 19 81 660
San miguel beer 26012 2697 19 34 68760
Nescafe decaf 20024 520 20 566 3282
Cafe fortaleza coffee(intense) 2133 3421 20 128 12552
Marbu maria tea biscuits 9020 7278 20 206 11520
Leche Sam whole milk 12020 2841 20 63 230064
Cafe fortaleza coffee (mild) 2133 7385 20 128 30216
Mistol all purpose cleaner 25002 8276 20 82 15600
Leche Sam low fat milk 12020 3616 20 63 76728
Baque Coffee (mild) 4183 5789 20 126 12204
San miguel beer 26012 2697 20 34 130032
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 20 125 5400
Cafe fortaleza coffee (mild) 2133 7385 21 128 9720
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 21 125 3280
Baque Coffee (mild) 4183 5789 21 125 9612
Leche Sam low fat milk 12020 3616 21 62 36396
Mistol all purpose cleaner 25002 8276 21 80 4600
Marbu maria tea biscuits 9020 7278 21 205 872
San miguel beer 26012 2697 21 30 172272
Nescafe decaf 20024 520 21 565 108
Cafe fortaleza coffee(intense) 2133 3421 21 128 3528
Leche Sam whole milk 12020 2841 21 62 61392
Leche Sam low fat milk 12020 3616 22 70 2532
Nescafe decaf 20024 520 22 565 3948
Mistol all purpose cleaner 25002 8276 22 80 30640
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 22 124 4360
San miguel beer 26012 2697 22 30 89736
Cafe fortaleza coffee(intense) 2133 3421 22 129 8808
Cafe fortaleza coffee (mild) 2133 7385 22 128 25224
Marbu maria tea biscuits 9020 7278 22 207 10736
Baque Coffee (mild) 4183 5789 22 125 10296
Leche Sam whole milk 12020 2841 22 70 6756
Baque Coffee (mild) 4183 5789 23 126 23184
Leche Sam low fat milk 12020 3616 23 72 66000
Leche Sam whole milk 12020 2841 23 72 158208
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 23 126 9960
San miguel beer 26012 2697 23 31 50256
Cafe fortaleza coffee(intense) 2133 3421 23 129 9912
Marbu maria tea biscuits 9020 7278 23 203 1360
Nescafe decaf 20024 520 23 546 186
Mistol all purpose cleaner 25002 8276 23 79 21040
Cafe fortaleza coffee (mild) 2133 7385 23 129 23856
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 24 117 12840
Nescafe decaf 20024 520 24 598 30
Baque Coffee (mild) 4183 5789 24 118 33840
Cafe fortaleza coffee (mild) 2133 7385 24 132 216
Marbu maria tea biscuits 9020 7278 24 212 4400
San miguel beer 26012 2697 24 32 100368
Leche Sam low fat milk 12020 3616 24 72 43980
Cafe fortaleza coffee(intense) 2133 3421 24 133 144
Mistol all purpose cleaner 25002 8276 24 83 1040
Leche Sam whole milk 12020 2841 24 72 120552
San miguel beer 26012 2697 25 32 51624
Cafe fortaleza coffee(intense) 2133 3421 25 129 1488
Baque Coffee (mild) 4183 5789 25 113 28872
Marbu maria tea biscuits 9020 7278 25 212 360
Leche Sam whole milk 12020 2841 25 72 297420
Mistol all purpose cleaner 25002 8276 25 72 31800
Cafe fortaleza coffee (mild) 2133 7385 25 128 7536
Leche Sam low fat milk 12020 3616 25 72 107280
Nescafe decaf 20024 520 25 607 204
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 25 113 13200
San miguel beer 26012 2697 26 33 124248
Baque Coffee (mild) 4183 5789 26 113 1296
Leche Sam low fat milk 12020 3616 26 73 77424
Nescafe decaf 20024 520 26 608 384
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 26 113 640
Leche Sam whole milk 12020 2841 26 73 209040
Cafe fortaleza coffee(intense) 2133 3421 26 129 24
Marbu maria tea biscuits 9020 7278 26 219 488
Mistol all purpose cleaner 25002 8276 26 79 3600
Cafe fortaleza coffee (mild) 2133 7385 26 119 33840
Nescafe decaf 20024 520 27 609 42
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 27 118 880
Mistol all purpose cleaner 25002 8276 27 79 1360
Leche Sam whole milk 12020 2841 27 72 290796
Cafe fortaleza coffee(intense) 2133 3421 27 131 10200
San miguel beer 26012 2697 27 33 120744
Baque Coffee (mild) 4183 5789 27 118 1800
Leche Sam low fat milk 12020 3616 27 72 112212
Cafe fortaleza coffee (mild) 2133 7385 27 131 22800
Marbu maria tea biscuits 9020 7278 27 216 640
Leche Sam low fat milk 12020 3616 28 66 144792
Cafe fortaleza coffee(intense) 2133 3421 28 128 3120
Baque Coffee (mild) 4183 5789 28 127 23904
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 28 127 10560
Mistol all purpose cleaner 25002 8276 28 79 32380
Cafe fortaleza coffee (mild) 2133 7385 28 128 10248
Leche Sam whole milk 12020 2841 28 66 373632
Nescafe decaf 20024 520 28 609 24
San miguel beer 26012 2697 28 35 57144
Marbu maria tea biscuits 9020 7278 28 215 736
Cafe fortaleza coffee (mild) 2133 7385 29 128 4680
Mistol all purpose cleaner 25002 8276 29 84 600
Nescafe decaf 20024 520 29 605 294
San miguel beer 26012 2697 29 30 167016
Baque Coffee (mild) 4183 5789 29 122 10836
Leche Sam low fat milk 12020 3616 29 67 127392
Cafe fortaleza coffee(intense) 2133 3421 29 128 936
CAFE BAQUE SUPER.GRANO 250 G 4183 4993 29 122 4040
Leche Sam whole milk 12020 2841 29 67 280944
Marbu maria tea biscuits 9020 7278 29 215 408
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.5723709315
R Square 0.3276084832
Adjusted R Squ 0.3109179136
Standard Error 80872.158474
Observations 290

ANOVA
df SS MS F Significance F
Regression 7 898628298845 128375471264 19.628358512 2.3105658E-21
Residual 282 1844366296583 6540306016
Total 289 2742994595428

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%


Intercept 19209731.569 37632464.119 0.5104563844 0.6101310942 -54866458.649 93285921.786
w_price 1568.3544772 576.732001869 2.7193817442 0.0069461776 433.108341282 2703.600613
price -1648.984107 563.621871419 -2.925692189 0.0037163935 -2758.424106 -539.5441078
returns -11.60620709 10.9988590161 -1.055219189 0.2922282907 -33.256492073 10.044077886
s 1.4558353203 0.22425866574 6.4917684027 3.810553E-10 1.01440189383 1.8972687467
i -618.4524475 1213.93774811 -0.509459771 0.6108284217 -3007.9819574 1771.0770623
h -2647.808997 4840.60094937 -0.547000057 0.5848112814 -12176.105511 6880.4875174
size 63429.637733 14018.8254586 4.5246042845 8.927151E-06 35834.8148697 91024.460597
Lower 95,0% Upper 95,0%
-54866458.65 93285921.786
433.10834128 2703.600613
-2758.424106 -539.5441078
-33.25649207 10.044077886
1.0144018938 1.8972687467
-3007.981957 1771.0770623
-12176.10551 6880.4875174
35834.81487 91024.460597
prod_des sup_code product_id city w_price p_price price p_sales returns s
San miguel 26012 2697 1 27 27 29 62208 0 42115
CAFE BAQ 4183 4993 1 143 146 149 3080 245 8605
Leche Sam 12020 2841 1 70 72 72 570648 0 21002
Baque Coff 4183 5789 1 143 146 148 9720 144 22363
Nescafe de 20024 520 1 624 610 634 450 83 978
Marbu maria 9020 7278 1 193 192 202 5552 109 5423
Mistol all 25002 8276 1 79 62 64 54220 0 7392
Cafe fortal 2133 3421 1 150 150 162 2136 268 2749
Cafe fortal 2133 7385 1 150 150 163 4944 143 1966
Leche Sam 12020 3616 1 71 72 72 164832 455 28113
San miguel 26012 2697 2 30 29 32 55800 0 34649
Nescafe de 20024 520 2 621 621 620 2586 28 2098
Mistol all 25002 8276 2 78 73 80 3700 0 14602
Leche Sam 12020 2841 2 70 71 71 289488 0 12407
CAFE BAQ 4183 4993 2 143 152 160 8960 3584 9149
Cafe fortal 2133 7385 2 150 149 171 96 140 3930
Marbu maria 9020 7278 2 193 188 189 20640 92 11051
Cafe fortal 2133 3421 2 150 149 171 48 210 2791
Leche Sam 12020 3616 2 70 71 70 81300 0 22488
Baque Coff 4183 5789 2 143 152 151 20736 78 9913
Marbu maria 9020 7278 3 193 198 210 888 0 7872
Nescafe de 20024 520 3 621 614 612 1308 3 1609
Cafe fortal 2133 7385 3 146 150 155 18984 130 3652
Leche Sam 12020 3616 3 64 70 70 70776 0 17943
Cafe fortal 2133 3421 3 146 150 153 8184 48 2671
Mistol all 25002 8276 3 78 74 74 35500 153 9215
Baque Coff 4183 5789 3 143 148 149 19656 214 1955
San miguel 26012 2697 3 29 30 31 72000 0 56153
CAFE BAQ 4183 4993 3 143 148 147 9160 0 2387
Leche Sam 12020 2841 3 64 70 70 232020 0 9366
Nescafe de 20024 520 4 621 613 616 2358 2 2901
Marbu maria 9020 7278 4 193 196 199 10704 35 9211
Leche Sam 12020 3616 4 64 65 65 95916 0 14829
Mistol all 25002 8276 4 78 76 79 7400 0 1299
CAFE BAQ 4183 4993 4 143 149 151 2320 1 6588
Cafe fortal 2133 7385 4 146 149 151 27672 0 1816
Leche Sam 12020 2841 4 64 65 65 356580 0 22985
Cafe fortal 2133 3421 4 146 149 151 11232 28 1211
San miguel 26012 2697 4 30 29 29 162240 0 76107
Baque Coff 4183 5789 4 143 149 156 3600 110 8041
Cafe fortal 2133 7385 5 140 148 155 6384 60 3964
CAFE BAQ 4183 4993 5 138 141 141 11520 99 4807
Mistol all 25002 8276 5 79 77 80 9080 0 14708
Cafe fortal 2133 3421 5 140 148 155 2640 25 3156
San miguel 26012 2697 5 30 30 33 60528 466 8989
Marbu maria 9020 7278 5 193 204 207 4904 116 3455
Nescafe de 20024 520 5 621 633 658 66 7 2158
Leche Sam 12020 3616 5 64 65 67 25752 699 27732
Leche Sam 12020 2841 5 64 65 67 70260 0 4585
Baque Coff 4183 5789 5 138 142 142 22500 12 6289
Cafe fortal 2133 7385 6 140 146 152 5760 245 2097
Cafe fortal 2133 3421 6 140 145 152 2088 50 1334
Nescafe de 20024 520 6 578 581 592 2304 8 762
Baque Coff 4183 5789 6 138 140 140 16776 0 2756
CAFE BAQ 4183 4993 6 138 140 139 6960 0 1485
San miguel 26012 2697 6 30 31 33 64944 0 41064
Mistol all 25002 8276 6 79 77 78 31380 0 5711
Leche Sam 12020 2841 6 64 65 67 40932 214 -5593
Leche Sam 12020 3616 6 64 65 68 12720 378 6402
Marbu maria 9020 7278 6 209 193 221 632 2 1065
San miguel 26012 2697 7 29 31 34 61656 0 45050
Nescafe de 20024 520 7 615 590 596 3954 12 1428
CAFE BAQ 4183 4993 7 136 140 141 5760 40 9245
Marbu maria 9020 7278 7 193 188 193 15680 3 13884
Cafe fortal 2133 3421 7 138 140 141 20472 1241 1495
Baque Coff 4183 5789 7 136 140 141 13032 102 11894
Leche Sam 12020 2841 7 62 63 66 17520 521 122260
Cafe fortal 2133 7385 7 138 140 141 40368 0 5791
Mistol all 25002 8276 7 76 67 69 43900 5 19516
Leche Sam 12020 3616 7 62 56 59 59388 419 56213
CAFE BAQ 4183 4993 8 135 139 140 9800 40 7485
Leche Sam 12020 3616 8 62 64 65 71064 0 35122
Leche Sam 12020 2841 8 62 64 65 192984 0 1846
Marbu maria 9020 7278 8 193 189 200 5432 0 5882
Cafe fortal 2133 3421 8 138 138 140 8184 24 -569
Cafe fortal 2133 7385 8 131 138 141 18336 63 -866
Baque Coff 4183 5789 8 135 139 140 22860 79 8193
San miguel 26012 2697 8 29 30 30 276480 0 65879
Mistol all 25002 8276 8 76 68 69 39940 0 10603
Nescafe de 20024 520 8 615 600 608 1980 0 2081
Cafe fortal 2133 7385 9 131 133 133 33888 0 2898
Nescafe de 20024 520 9 605 594 594 2328 0 1806
Marbu maria 9020 7278 9 193 188 216 936 3 1805
Mistol all 25002 8276 9 76 69 81 1400 10 9493
Leche Sam 12020 2841 9 67 65 65 303528 1108 28118
CAFE BAQ 4183 4993 9 134 139 143 2600 0 6165
Cafe fortal 2133 3421 9 131 133 133 14472 123 1474
San miguel 26012 2697 9 30 30 32 90456 2180 55891
Baque Coff 4183 5789 9 134 139 144 4752 10 5323
Leche Sam 12020 3616 9 65 65 65 98856 233 15123
Mistol all 25002 8276 10 69 71 79 11940 0 26223
San miguel 26012 2697 10 30 30 35 31824 2179 32678
Marbu maria 9020 7278 10 197 188 202 4944 0 3531
Cafe fortal 2133 3421 10 131 135 140 6264 27 5533
Leche Sam 12020 2841 10 65 64 68 138744 0 5868
CAFE BAQ 4183 4993 10 134 138 139 4760 0 7205
Nescafe de 20024 520 10 556 567 586 1812 0 6305
Cafe fortal 2133 7385 10 131 134 140 11568 0 3536
Baque Coff 4183 5789 10 134 138 141 11232 0 8498
Leche Sam 12020 3616 10 64 65 67 28308 0 -2728
San miguel 26012 2697 11 29 29 32 62448 0 716
Mistol all 25002 8276 11 79 71 72 45500 250 14393
Leche Sam 12020 2841 11 71 65 65 319068 0 -4218
Cafe fortal 2133 7385 11 131 133 133 48600 0 3216
CAFE BAQ 4183 4993 11 134 133 132 12920 365 4610
Marbu maria 9020 7278 11 192 188 188 20784 80 11179
Nescafe de 20024 520 11 576 564 568 4482 41 6262
Leche Sam 12020 3616 11 64 65 65 71532 109 3309
Baque Coff 4183 5789 11 134 133 133 33876 111 1409
Cafe fortal 2133 3421 11 131 134 134 17088 305 1350
Marbu maria 9020 7278 12 192 188 198 5936 140 2919
Cafe fortal 2133 3421 12 119 122 122 15024 0 9628
Cafe fortal 2133 7385 12 119 122 122 43776 244 18916
San miguel 26012 2697 12 29 29 30 196992 0 310
Mistol all 25002 8276 12 67 71 72 32540 0 25157
Nescafe de 20024 520 12 576 567 567 4434 0 2578
Baque Coff 4183 5789 12 116 121 121 33408 535 7776
Leche Sam 12020 2841 12 73 71 79 2592 3800 66986
CAFE BAQ 4183 4993 12 116 120 120 12920 0 6336
Leche Sam 12020 3616 12 69 71 73 864 0 9343
Leche Sam 12020 2841 13 76 71 72 505488 0 56881
Mistol all 25002 8276 13 81 68 69 71980 0 8565
San miguel 26012 2697 13 34 29 34 52632 0 52157
Cafe fortal 2133 3421 13 120 122 123 15960 204 7000
Nescafe de 20024 520 13 573 565 593 756 84 8308
Marbu maria 9020 7278 13 193 190 208 3576 37 10188
Cafe fortal 2133 7385 13 120 122 123 37464 0 11083
Leche Sam 12020 3616 13 72 71 71 206076 0 16421
Baque Coff 4183 5789 13 120 119 125 4860 174 1722
CAFE BAQ 4183 4993 13 120 119 124 2200 184 3360
Leche Sam 12020 3616 14 72 73 75 42468 1306 36867
Leche Sam 12020 2841 14 72 73 76 134628 0 53616
Mistol all 25002 8276 14 81 84 86 1900 58 6643
CAFE BAQ 4183 4993 14 120 122 121 9480 89 5769
Baque Coff 4183 5789 14 120 122 122 23292 70 6040
Nescafe de 20024 520 14 573 566 566 6270 47 2007
San miguel 26012 2697 14 32 34 37 33984 0 27793
Cafe fortal 2133 7385 14 123 124 127 14304 66 4861
Marbu maria 9020 7278 14 193 188 194 10872 122 12310
Cafe fortal 2133 3421 14 123 123 126 4128 37 2021
Marbu maria 9020 7278 15 193 194 207 1560 182 8804
San miguel 26012 2697 15 32 34 34 174504 0 35296
Leche Sam 12020 2841 15 67 71 72 146640 0 22957
Cafe fortal 2133 7385 15 123 123 126 17016 12 4537
Nescafe de 20024 520 15 573 578 592 396 0 1047
Cafe fortal 2133 3421 15 123 123 127 5784 175 2916
Mistol all 25002 8276 15 86 80 90 4060 0 3259
CAFE BAQ 4183 4993 15 120 122 123 3440 124 6213
Baque Coff 4183 5789 15 120 122 124 9612 10 13106
Leche Sam 12020 3616 15 67 71 72 64860 0 13671
Leche Sam 12020 2841 16 66 66 66 456924 0 1513
Nescafe de 20024 520 16 571 574 602 402 0 675
Leche Sam 12020 3616 16 66 66 66 174948 776 5411
San miguel 26012 2697 16 34 33 34 127176 218 26010
Marbu maria 9020 7278 16 193 191 211 2184 0 2437
Mistol all 25002 8276 16 88 85 94 700 1 4660
Cafe fortal 2133 7385 16 130 123 137 3912 116 621
Cafe fortal 2133 3421 16 130 123 135 2520 0 361
Baque Coff 4183 5789 16 120 124 126 27252 0 4044
CAFE BAQ 4183 4993 16 120 124 125 10840 0 2533
CAFE BAQ 4183 4993 17 120 123 129 2280 67 1760
Leche Sam 12020 3616 17 63 64 69 4956 0 28572
Leche Sam 12020 2841 17 63 63 66 124980 0 -13596
Cafe fortal 2133 3421 17 125 128 138 4200 95 1680
Nescafe de 20024 520 17 571 586 608 156 27 2790
Cafe fortal 2133 7385 17 125 128 136 13272 0 -2064
Baque Coff 4183 5789 17 120 123 133 5112 1788 1656
San miguel 26012 2697 17 32 33 35 89616 0 131544
Mistol all 25002 8276 17 84 85 95 1620 0 5820
Marbu maria 9020 7278 17 194 192 212 2248 0 11880
CAFE BAQ 4183 4993 18 124 129 130 6440 38 2398
Cafe fortal 2133 7385 18 128 130 132 28536 31 5647
Cafe fortal 2133 3421 18 128 130 131 11496 0 2205
Mistol all 25002 8276 18 84 79 91 3260 0 4840
San miguel 26012 2697 18 32 33 35 43416 1429 50197
Marbu maria 9020 7278 18 208 188 193 11344 32 1912
Baque Coff 4183 5789 18 124 129 131 14544 47 6779
Leche Sam 12020 3616 18 64 63 62 45672 0 21224
Leche Sam 12020 2841 18 64 63 62 230916 0 19658
Nescafe de 20024 520 18 571 594 607 108 0 1746
Cafe fortal 2133 3421 19 125 128 140 1008 1 11254
Cafe fortal 2133 7385 19 125 128 139 4608 46 33485
Leche Sam 12020 2841 19 60 61 63 147864 866 13444
Marbu maria 9020 7278 19 203 204 233 720 34 12586
Baque Coff 4183 5789 19 124 130 131 14652 0 12152
CAFE BAQ 4183 4993 19 124 130 130 5120 81 5039
Nescafe de 20024 520 19 571 586 591 2328 21 39
Leche Sam 12020 3616 19 60 61 63 56316 785 9253
Mistol all 25002 8276 19 81 81 91 660 0 3732
San miguel 26012 2697 19 32 34 36 68760 0 142163
Nescafe de 20024 520 20 571 566 570 3282 28 907
Cafe fortal 2133 3421 20 125 128 130 12552 43 4241
Marbu maria 9020 7278 20 203 206 209 11520 0 14679
Leche Sam 12020 2841 20 60 63 63 230064 0 54380
Cafe fortal 2133 7385 20 125 128 131 30216 0 3660
Mistol all 25002 8276 20 81 82 84 15600 19 42591
Leche Sam 12020 3616 20 60 63 64 76728 0 44459
Baque Coff 4183 5789 20 123 126 130 12204 16 6480
San miguel 26012 2697 20 32 34 35 130032 0 21030
CAFE BAQ 4183 4993 20 123 125 128 5400 0 4758
Cafe fortal 2133 7385 21 125 128 135 9720 81 2637
CAFE BAQ 4183 4993 21 123 125 128 3280 105 4863
Baque Coff 4183 5789 21 123 125 129 9612 0 2694
Leche Sam 12020 3616 21 66 62 64 36396 0 1529
Mistol all 25002 8276 21 81 80 85 4600 22 32813
Marbu maria 9020 7278 21 203 205 229 872 118 11797
San miguel 26012 2697 21 32 30 31 172272 0 39518
Nescafe de 20024 520 21 571 565 605 108 54 253
Cafe fortal 2133 3421 21 125 128 134 3528 8 1489
Leche Sam 12020 2841 21 66 62 64 61392 0 -2499
Leche Sam 12020 3616 22 69 70 73 2532 0 16122
Nescafe de 20024 520 22 571 565 571 3948 61 2570
Mistol all 25002 8276 22 81 80 80 30640 20 633
CAFE BAQ 4183 4993 22 123 124 131 4360 317 4380
San miguel 26012 2697 22 29 30 32 89736 0 67611
Cafe fortal 2133 3421 22 128 129 133 8808 222 1783
Cafe fortal 2133 7385 22 128 128 133 25224 0 8484
Marbu maria 9020 7278 22 203 207 210 10736 0 12725
Baque Coff 4183 5789 22 123 125 133 10296 0 4671
Leche Sam 12020 2841 22 69 70 72 6756 0 11645
Baque Coff 4183 5789 23 122 126 127 23184 9 8280
Leche Sam 12020 3616 23 73 72 74 66000 0 59022
Leche Sam 12020 2841 23 73 72 74 158208 0 58511
CAFE BAQ 4183 4993 23 122 126 127 9960 39 3579
San miguel 26012 2697 23 32 31 33 50256 0 17772
Cafe fortal 2133 3421 23 128 129 131 9912 0 4542
Marbu maria 9020 7278 23 203 203 226 1360 9 8854
Nescafe de 20024 520 23 591 546 600 186 0 2273
Mistol all 25002 8276 23 80 79 80 21040 169 17362
Cafe fortal 2133 7385 23 128 129 130 23856 606 6330
CAFE BAQ 4183 4993 24 116 117 118 12840 601 6541
Nescafe de 20024 520 24 591 598 630 30 0 964
Baque Coff 4183 5789 24 116 118 119 33840 0 13286
Cafe fortal 2133 7385 24 128 132 145 216 42 6233
Marbu maria 9020 7278 24 203 212 216 4400 0 3654
San miguel 26012 2697 24 32 32 33 100368 0 145405
Leche Sam 12020 3616 24 73 72 74 43980 0 7059
Cafe fortal 2133 3421 24 128 133 159 144 2 2654
Mistol all 25002 8276 24 80 83 89 1040 216 9018
Leche Sam 12020 2841 24 73 72 74 120552 0 53304
San miguel 26012 2697 25 32 32 34 51624 0 17686
Cafe fortal 2133 3421 25 128 129 141 1488 0 2303
Baque Coff 4183 5789 25 109 113 114 28872 0 13544
Marbu maria 9020 7278 25 215 212 239 360 0 10756
Leche Sam 12020 2841 25 73 72 73 297420 0 82028
Mistol all 25002 8276 25 80 72 74 31800 233 13271
Cafe fortal 2133 7385 25 128 128 138 7536 0 6564
Leche Sam 12020 3616 25 73 72 73 107280 0 46242
Nescafe de 20024 520 25 601 607 633 204 2 1470
CAFE BAQ 4183 4993 25 109 113 113 13200 905 7766
San miguel 26012 2697 26 32 33 34 124248 1594 83120
Baque Coff 4183 5789 26 109 113 128 1296 541 9369
Leche Sam 12020 3616 26 71 73 73 77424 1914 34068
Nescafe de 20024 520 26 601 608 633 384 0 1500
CAFE BAQ 4183 4993 26 109 113 136 640 635 7121
Leche Sam 12020 2841 26 71 73 73 209040 0 89196
Cafe fortal 2133 3421 26 128 129 148 24 154 921
Marbu maria 9020 7278 26 215 219 242 488 0 6634
Mistol all 25002 8276 26 80 79 85 3600 260 2151
Cafe fortal 2133 7385 26 117 119 120 33840 1482 7734
Nescafe de 20024 520 27 601 609 641 42 0 2220
CAFE BAQ 4183 4993 27 120 118 126 880 160 7961
Mistol all 25002 8276 27 83 79 89 1360 0 13491
Leche Sam 12020 2841 27 68 72 73 290796 0 28547
Cafe fortal 2133 3421 27 126 131 133 10200 0 3441
San miguel 26012 2697 27 32 33 34 120744 0 103149
Baque Coff 4183 5789 27 120 118 126 1800 0 10845
Leche Sam 12020 3616 27 68 72 73 112212 0 25200
Cafe fortal 2133 7385 27 126 131 132 22800 168 4686
Marbu maria 9020 7278 27 215 216 242 640 1 9395
Leche Sam 12020 3616 28 68 66 67 144792 0 2261
Cafe fortal 2133 3421 28 126 128 137 3120 0 2361
Baque Coff 4183 5789 28 120 127 127 23904 0 11925
CAFE BAQ 4183 4993 28 120 127 127 10560 12 9173
Mistol all 25002 8276 28 83 79 80 32380 40 20751
Cafe fortal 2133 7385 28 126 128 135 10248 24 6030
Leche Sam 12020 2841 28 68 66 67 373632 0 423
Nescafe de 20024 520 28 601 609 641 24 12 990
San miguel 26012 2697 28 32 35 36 57144 0 16090
Marbu maria 9020 7278 28 215 215 240 736 16 5323
Cafe fortal 2133 7385 29 126 128 139 4680 0 2358
Mistol all 25002 8276 29 83 84 90 600 1 40512
Nescafe de 20024 520 29 601 605 634 294 6 1416
San miguel 26012 2697 29 32 30 32 167016 0 58870
Baque Coff 4183 5789 29 120 122 126 10836 8 9917
Leche Sam 12020 3616 29 64 67 67 127392 331 4896
Cafe fortal 2133 3421 29 126 128 142 936 0 585
CAFE BAQ 4183 4993 29 120 122 125 4040 0 6773
Leche Sam 12020 2841 29 64 67 67 280944 0 5688
Marbu maria 9020 7278 29 215 215 242 408 8 2131
size sales markup i h
0 137160 0 30992 2
0 4000 0 30992 2
1 572316 0 30992 2
0 12024 0 30992 2
0 1002 0 30992 2
1 9616 0 30992 2
1 61580 0 30992 2
0 5160 0 30992 2
0 13704 0 30992 2
1 165204 0 30992 2
0 174888 0 30998 3
0 3402 0 30998 3
1 17740 0 30998 3
1 305244 0 30998 3
0 9040 0 30998 3
0 12576 0 30998 3
1 21896 0 30998 3
0 4968 0 30998 3
1 86340 0 30998 3
0 21528 0 30998 3
1 3136 0 30999 3
0 1692 0 30999 3
0 27768 0 30999 3
1 79020 0 30999 3
0 10968 0 30999 3
1 40100 0 30999 3
0 20772 0 30999 3
0 169536 0 30999 3
0 9840 0 30999 3
1 278028 0 30999 3
0 2550 0 30997 3
1 11904 0 30997 3
1 104592 0 30997 3
1 16180 0 30997 3
0 3000 0 30997 3
0 30456 0 30997 3
1 384420 0 30997 3
0 12288 0 30997 3
0 181776 0 30997 3
0 6624 0 30997 3
0 10056 0 31000 3
0 11880 0 31000 3
1 17520 0 31000 3
0 4080 0 31000 3
0 169968 0 31000 3
1 5872 0 31000 3
0 750 0 31000 3
1 48084 0 31000 3
1 138996 0 31000 3
0 23364 0 31000 3
0 11712 0 30999 4
0 4272 0 30999 4
0 2904 0 30999 4
0 17928 0 30999 4
0 7320 0 30999 4
0 166608 0 30999 4
1 37040 0 30999 4
1 112344 0 30999 4
1 36552 0 30999 4
1 4264 0 30999 4
0 188856 0 31000 2
0 4446 0 31000 2
0 6280 0 31000 2
1 17664 0 31000 2
0 21480 0 31000 2
0 14364 0 31000 2
1 92400 0 31000 2
0 43608 0 31000 2
1 48120 0 31000 2
1 83724 0 31000 2
0 9880 0 30999 3
1 84024 0 30999 3
1 235284 0 30999 3
1 7976 0 30999 3
0 9264 0 30999 3
0 21120 0 30999 3
0 23580 0 30999 3
0 317328 0 30999 3
1 42800 0 30999 3
0 2346 0 30999 3
0 34632 0 31004 2
0 2364 0 31004 2
1 4080 0 31004 2
1 7600 0 31004 2
1 315252 0 31004 2
0 3320 0 31004 2
0 14880 0 31004 2
0 175464 0 31004 2
0 6480 0 31004 2
1 105768 0 31004 2
1 20480 0 31000 2
0 131712 0 31000 2
1 8168 0 31000 2
0 9888 0 31000 2
1 251304 0 31000 2
0 5680 0 31000 2
0 2376 0 31000 2
0 19152 0 31000 2
0 14580 0 31000 2
1 76128 0 31000 2
0 148488 0 31001 1
1 49920 0 31001 1
1 348168 0 31001 1
0 49608 0 31001 1
0 12960 0 31001 1
1 21232 0 31001 1
0 4884 0 31001 1
1 72180 0 31001 1
0 34200 0 31001 1
0 17448 0 31001 1
1 8400 0 31007 3
0 15672 0 31007 3
0 45144 0 31007 3
0 219096 0 31007 3
1 35460 0 31007 3
0 4500 0 31007 3
0 33732 0 31007 3
1 61284 0 31007 3
0 12960 0 31007 3
1 21084 0 31007 3
1 570252 0 31005 1
1 79160 0 31005 1
0 115224 0 31005 1
0 17232 0 31005 1
0 1566 0 31005 1
1 8008 0 31005 1
0 41424 0 31005 1
1 232008 0 31005 1
0 8028 0 31005 1
0 3160 0 31005 1
1 76884 0 30993 0
1 228612 0 30993 0
1 9180 0 30993 0
0 9680 0 30993 0
0 24552 0 30993 0
0 6348 0 30993 0
0 94968 0 30993 0
0 19968 0 30993 0
1 13240 0 30993 0
0 5736 0 30993 0
1 3688 0 30996 2
0 200928 0 30996 2
1 175704 0 30996 2
0 20736 0 30996 2
0 936 0 30996 2
0 7200 0 30996 2
1 13120 0 30996 2
0 3680 0 30996 2
0 10944 0 30996 2
1 79104 0 30996 2
1 457908 0 31003 0
0 1572 0 31003 0
1 175596 0 31003 0
0 175392 0 31003 0
1 6320 0 31003 0
1 10120 0 31003 0
0 12912 0 31003 0
0 6216 0 31003 0
0 30492 0 31003 0
0 11600 0 31003 0
0 4040 0 31005 2
1 37128 0 31005 2
1 224220 0 31005 2
0 7896 0 31005 2
0 1512 0 31005 2
0 23904 0 31005 2
0 11736 0 31005 2
0 178920 0 31005 2
1 8640 0 31005 2
1 6480 0 31005 2
0 7400 0 31003 3
0 31920 0 31003 3
0 12672 0 31003 3
1 14620 0 31003 3
0 83256 0 31003 3
1 12976 0 31003 3
0 18324 0 31003 3
1 64440 0 31003 3
1 242748 0 31003 3
0 1038 0 31003 3
0 2952 0 30997 3
0 10608 0 30997 3
1 201108 0 30997 3
1 4600 0 30997 3
0 16200 0 30997 3
0 5440 0 30997 3
0 2928 0 30997 3
1 75828 0 30997 3
1 9020 0 30997 3
0 161352 0 30997 3
0 3660 0 31007 3
0 14256 0 31007 3
1 13144 0 31007 3
1 264696 0 31007 3
0 35808 0 31007 3
1 20920 0 31007 3
1 90360 0 31007 3
0 16488 0 31007 3
0 175704 0 31007 3
0 6280 0 31007 3
0 15504 0 30999 1
0 4000 0 30999 1
0 12708 0 30999 1
1 50760 0 30999 1
1 9800 0 30999 1
1 3000 0 30999 1
0 209496 0 30999 1
0 708 0 30999 1
0 5160 0 30999 1
1 96468 0 30999 1
1 64836 0 31004 1
0 4644 0 31004 1
1 32200 0 31004 1
0 6800 0 31004 1
0 141864 0 31004 1
0 11928 0 31004 1
0 33744 0 31004 1
1 12240 0 31004 1
0 17820 0 31004 1
1 179532 0 31004 1
0 25200 0 31005 1
1 118920 0 31005 1
1 282912 0 31005 1
0 10840 0 31005 1
0 100920 0 31005 1
0 10536 0 31005 1
1 3880 0 31005 1
0 894 0 31005 1
1 23040 0 31005 1
0 26160 0 31005 1
0 13639 0 30999 3
0 1128 0 30999 3
0 36174 0 30999 3
0 7339 0 30999 3
1 5200 0 30999 3
0 144552 0 30999 3
1 72192 0 30999 3
0 2490 0 30999 3
1 8560 0 30999 3
1 202692 0 30999 3
0 123552 0 30999 1
0 4469 0 30999 1
0 30449 0 30999 1
1 4064 0 30999 1
1 390504 0 30999 1
1 39080 0 30999 1
0 16440 0 30999 1
1 138756 0 30999 1
0 1596 0 30999 1
0 13680 0 30999 1
0 152592 0 30995 0
0 4716 0 30995 0
1 89256 0 30995 0
0 1524 0 30995 0
0 1280 0 30995 0
1 242220 0 30995 0
0 2736 0 30995 0
1 4088 0 30995 0
1 11380 0 30995 0
0 36312 0 30995 0
0 1284 0 30996 2
0 3320 0 30996 2
1 9560 0 30996 2
1 370272 0 30996 2
0 11880 0 30996 2
0 140520 0 30996 2
0 9324 0 30996 2
1 138912 0 30996 2
0 24816 0 30996 2
1 4352 0 30996 2
1 160920 0 30995 3
0 5880 0 30995 3
0 25884 0 30995 3
0 10800 0 30995 3
1 35260 0 30995 3
0 16680 0 30995 3
1 427344 0 30995 3
0 1302 0 30995 3
0 86976 0 30995 3
1 4088 0 30995 3
0 13248 0 31000 2
1 5920 0 31000 2
0 1380 0 31000 2
0 220536 0 31000 2
0 14616 0 31000 2
1 136464 0 31000 2
0 3696 0 31000 2
0 4800 0 31000 2
1 328944 0 31000 2
1 3200 0 31000 2
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9738274599
R Square 0.9483399216
Adjusted R 0.9464883059
Standard E 22536.574477
Observatio 290

ANOVA
df SS MS F Significance F
Regression 10 2.6E+12 2.60129E+11 512.168867097 4.1932347E-173
Residual 279 1.42E+11 507897189
Total 289 2.74E+12

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%Lower 95,0%
Intercept -12437993.614 10508545 -1.1836076 0.23757590887 -33124097.0626 8248110 -3.3E+07
w_price 946.45506071 302.356 3.130266684 0.00193179851 351.266236768 1541.644 351.2662
price -717.67981579 268.0816 -2.67709428 0.00786619124 -1245.39935545 -189.9603 -1245.399
p_price -232.49697136 303.4778 -0.76610873 0.44425928431 -829.893918349 364.9 -829.8939
p_sales 1.0787098686 0.018859 57.1976488 3.904584E-156 1.04158520009 1.115835 1.041585
returns 0.2611231802 3.08244 0.084713155 0.93255019187 -5.80666874132 6.328915 -5.806669
s 0.456820395 0.065266 6.99941407 1.9147903E-11 0.32834501597 0.585296 0.328345
i 401.24434065 338.9787 1.183685864 0.23754496744 -266.036365628 1068.525 -266.0364
h -374.53519982 1378.327 -0.27173184 0.7860291832 -3087.77529666 2338.705 -3087.775
size 4778.185966 4325.988 1.104530469 0.27031474042 -3737.53566688 13293.91 -3737.536
markup 191257.9095 41311.6 4.629641992 5.620077E-06 109935.899406 272579.9 109935.9
Upper 95,0%
8248110
1541.644
-189.9603
364.9
1.115835
6.328915
0.585296
1068.525
2338.705
13293.91
272579.9
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9717876545
R Square 0.9443712454
Adjusted R Square 0.9425831782
Standard Error 23344.422195
Observations 290

ANOVA
df SS MS F
Regression 9 2590405222094 287822802455 528.15201299
Residual 280 152589373334 544962047.62
Total 289 2742994595428

Coefficients Standard Error t Stat P-value


Intercept -10815774.01 10879181.9955 -0.994171622 0.3209976865
Unit wholesale price for each brand(w_price) 137.37160462 255.578255548 0.5374933181 0.5913538041
Unit retail price (price) 130.30151297 202.769095995 0.6426103166 0.5210028206
promotional_price(p_price) -301.512883 313.976767413 -0.960303164 0.3377311693
promotional_sales(p_sales) 1.0638987465 0.01925224749 55.261015472 1.22416E-152
returns (returns) 1.3275847904 3.18400451629 0.4169544307 0.6770312224
Inventories in physical units (s) 0.4963203247 0.06702487348 7.4050169578 1.546182E-12
Average real income (i) 349.20720109 350.936712246 0.9950717292 0.3205605254
Average household size (h) 192.94589786 1422.07718201 0.1356789212 0.8921726025
Size of the product (size) 577.79612304 4381.39810521 0.1318748283 0.8951780093
Significance F Tcrit from (Two Tailed test)
5.315518E-170 1.9684725

Lower 95% Upper 95% Lower 95,0% Upper 95,0%


-32231144.59 10599596.57 -32231144.59 10599596.57
-365.72716296 640.4703722 -365.727163 640.4703722
-268.84387629 529.4469022 -268.8438763 529.4469022
-919.56751522 316.5417492 -919.5675152 316.5417492
1.02600122675 1.101796266 1.0260012267 1.101796266
-4.940040539 7.59521012 -4.940040539 7.59521012
0.36438370446 0.628256945 0.3643837045 0.628256945
-341.60206612 1040.016468 -341.6020661 1040.016468
-2606.3739274 2992.265723 -2606.373927 2992.265723
-8046.8655575 9202.457804 -8046.865557 9202.457804
sales Unit wholesale price for each brand(w_price) Unit retail price (price) promotional_price(p_price)
137160 27 29 27
4000 143 149 146
572316 70 72 72
12024 143 148 146
1002 624 634 610
9616 193 202 192
61580 79 64 62
5160 150 162 150
13704 150 163 150
165204 71 72 72
174888 30 32 29
3402 621 620 621
17740 78 80 73
305244 70 71 71
9040 143 160 152
12576 150 171 149
21896 193 189 188
4968 150 171 149
86340 70 70 71
21528 143 151 152
3136 193 210 198
1692 621 612 614
27768 146 155 150
79020 64 70 70
10968 146 153 150
40100 78 74 74
20772 143 149 148
169536 29 31 30
9840 143 147 148
278028 64 70 70
2550 621 616 613
11904 193 199 196
104592 64 65 65
16180 78 79 76
3000 143 151 149
30456 146 151 149
384420 64 65 65
12288 146 151 149
181776 30 29 29
6624 143 156 149
10056 140 155 148
11880 138 141 141
17520 79 80 77
4080 140 155 148
169968 30 33 30
5872 193 207 204
750 621 658 633
48084 64 67 65
138996 64 67 65
23364 138 142 142
11712 140 152 146
4272 140 152 145
2904 578 592 581
17928 138 140 140
7320 138 139 140
166608 30 33 31
37040 79 78 77
112344 64 67 65
36552 64 68 65
4264 209 221 193
188856 29 34 31
4446 615 596 590
6280 136 141 140
17664 193 193 188
21480 138 141 140
14364 136 141 140
92400 62 66 63
43608 138 141 140
48120 76 69 67
83724 62 59 56
9880 135 140 139
84024 62 65 64
235284 62 65 64
7976 193 200 189
9264 138 140 138
21120 131 141 138
23580 135 140 139
317328 29 30 30
42800 76 69 68
2346 615 608 600
34632 131 133 133
2364 605 594 594
4080 193 216 188
7600 76 81 69
315252 67 65 65
3320 134 143 139
14880 131 133 133
175464 30 32 30
6480 134 144 139
105768 65 65 65
20480 69 79 71
131712 30 35 30
8168 197 202 188
9888 131 140 135
251304 65 68 64
5680 134 139 138
2376 556 586 567
19152 131 140 134
14580 134 141 138
76128 64 67 65
148488 29 32 29
49920 79 72 71
348168 71 65 65
49608 131 133 133
12960 134 132 133
21232 192 188 188
4884 576 568 564
72180 64 65 65
34200 134 133 133
17448 131 134 134
8400 192 198 188
15672 119 122 122
45144 119 122 122
219096 29 30 29
35460 67 72 71
4500 576 567 567
33732 116 121 121
61284 73 79 71
12960 116 120 120
21084 69 73 71
570252 76 72 71
79160 81 69 68
115224 34 34 29
17232 120 123 122
1566 573 593 565
8008 193 208 190
41424 120 123 122
232008 72 71 71
8028 120 125 119
3160 120 124 119
76884 72 75 73
228612 72 76 73
9180 81 86 84
9680 120 121 122
24552 120 122 122
6348 573 566 566
94968 32 37 34
19968 123 127 124
13240 193 194 188
5736 123 126 123
3688 193 207 194
200928 32 34 34
175704 67 72 71
20736 123 126 123
936 573 592 578
7200 123 127 123
13120 86 90 80
3680 120 123 122
10944 120 124 122
79104 67 72 71
457908 66 66 66
1572 571 602 574
175596 66 66 66
175392 34 34 33
6320 193 211 191
10120 88 94 85
12912 130 137 123
6216 130 135 123
30492 120 126 124
11600 120 125 124
4040 120 129 123
37128 63 69 64
224220 63 66 63
7896 125 138 128
1512 571 608 586
23904 125 136 128
11736 120 133 123
178920 32 35 33
8640 84 95 85
6480 194 212 192
7400 124 130 129
31920 128 132 130
12672 128 131 130
14620 84 91 79
83256 32 35 33
12976 208 193 188
18324 124 131 129
64440 64 62 63
242748 64 62 63
1038 571 607 594
2952 125 140 128
10608 125 139 128
201108 60 63 61
4600 203 233 204
16200 124 131 130
5440 124 130 130
2928 571 591 586
75828 60 63 61
9020 81 91 81
161352 32 36 34
3660 571 570 566
14256 125 130 128
13144 203 209 206
264696 60 63 63
35808 125 131 128
20920 81 84 82
90360 60 64 63
16488 123 130 126
175704 32 35 34
6280 123 128 125
15504 125 135 128
4000 123 128 125
12708 123 129 125
50760 66 64 62
9800 81 85 80
3000 203 229 205
209496 32 31 30
708 571 605 565
5160 125 134 128
96468 66 64 62
64836 69 73 70
4644 571 571 565
32200 81 80 80
6800 123 131 124
141864 29 32 30
11928 128 133 129
33744 128 133 128
12240 203 210 207
17820 123 133 125
179532 69 72 70
25200 122 127 126
118920 73 74 72
282912 73 74 72
10840 122 127 126
100920 32 33 31
10536 128 131 129
3880 203 226 203
894 591 600 546
23040 80 80 79
26160 128 130 129
13639 116 118 117
1128 591 630 598
36174 116 119 118
7339 128 145 132
5200 203 216 212
144552 32 33 32
72192 73 74 72
2490 128 159 133
8560 80 89 83
202692 73 74 72
123552 32 34 32
4469 128 141 129
30449 109 114 113
4064 215 239 212
390504 73 73 72
39080 80 74 72
16440 128 138 128
138756 73 73 72
1596 601 633 607
13680 109 113 113
152592 32 34 33
4716 109 128 113
89256 71 73 73
1524 601 633 608
1280 109 136 113
242220 71 73 73
2736 128 148 129
4088 215 242 219
11380 80 85 79
36312 117 120 119
1284 601 641 609
3320 120 126 118
9560 83 89 79
370272 68 73 72
11880 126 133 131
140520 32 34 33
9324 120 126 118
138912 68 73 72
24816 126 132 131
4352 215 242 216
160920 68 67 66
5880 126 137 128
25884 120 127 127
10800 120 127 127
35260 83 80 79
16680 126 135 128
427344 68 67 66
1302 601 641 609
86976 32 36 35
4088 215 240 215
13248 126 139 128
5920 83 90 84
1380 601 634 605
220536 32 32 30
14616 120 126 122
136464 64 67 67
3696 126 142 128
4800 120 125 122
328944 64 67 67
3200 215 242 215
promotional_sales(p_sales) returns (returns) Inventories in physical units (s) Average real income (i)
62208 0 42115 30992
3080 245 8605 30992
570648 0 21002 30992
9720 144 22363 30992
450 83 978 30992
5552 109 5423 30992
54220 0 7392 30992
2136 268 2749 30992
4944 143 1966 30992
164832 455 28113 30992
55800 0 34649 30998
2586 28 2098 30998
3700 0 14602 30998
289488 0 12407 30998
8960 3584 9149 30998
96 140 3930 30998
20640 92 11051 30998
48 210 2791 30998
81300 0 22488 30998
20736 78 9913 30998
888 0 7872 30999
1308 3 1609 30999
18984 130 3652 30999
70776 0 17943 30999
8184 48 2671 30999
35500 153 9215 30999
19656 214 1955 30999
72000 0 56153 30999
9160 0 2387 30999
232020 0 9366 30999
2358 2 2901 30997
10704 35 9211 30997
95916 0 14829 30997
7400 0 1299 30997
2320 1 6588 30997
27672 0 1816 30997
356580 0 22985 30997
11232 28 1211 30997
162240 0 76107 30997
3600 110 8041 30997
6384 60 3964 31000
11520 99 4807 31000
9080 0 14708 31000
2640 25 3156 31000
60528 466 8989 31000
4904 116 3455 31000
66 7 2158 31000
25752 699 27732 31000
70260 0 4585 31000
22500 12 6289 31000
5760 245 2097 30999
2088 50 1334 30999
2304 8 762 30999
16776 0 2756 30999
6960 0 1485 30999
64944 0 41064 30999
31380 0 5711 30999
40932 214 -5593 30999
12720 378 6402 30999
632 2 1065 30999
61656 0 45050 31000
3954 12 1428 31000
5760 40 9245 31000
15680 3 13884 31000
20472 1241 1495 31000
13032 102 11894 31000
17520 521 122260 31000
40368 0 5791 31000
43900 5 19516 31000
59388 419 56213 31000
9800 40 7485 30999
71064 0 35122 30999
192984 0 1846 30999
5432 0 5882 30999
8184 24 -569 30999
18336 63 -866 30999
22860 79 8193 30999
276480 0 65879 30999
39940 0 10603 30999
1980 0 2081 30999
33888 0 2898 31004
2328 0 1806 31004
936 3 1805 31004
1400 10 9493 31004
303528 1108 28118 31004
2600 0 6165 31004
14472 123 1474 31004
90456 2180 55891 31004
4752 10 5323 31004
98856 233 15123 31004
11940 0 26223 31000
31824 2179 32678 31000
4944 0 3531 31000
6264 27 5533 31000
138744 0 5868 31000
4760 0 7205 31000
1812 0 6305 31000
11568 0 3536 31000
11232 0 8498 31000
28308 0 -2728 31000
62448 0 716 31001
45500 250 14393 31001
319068 0 -4218 31001
48600 0 3216 31001
12920 365 4610 31001
20784 80 11179 31001
4482 41 6262 31001
71532 109 3309 31001
33876 111 1409 31001
17088 305 1350 31001
5936 140 2919 31007
15024 0 9628 31007
43776 244 18916 31007
196992 0 310 31007
32540 0 25157 31007
4434 0 2578 31007
33408 535 7776 31007
2592 3800 66986 31007
12920 0 6336 31007
864 0 9343 31007
505488 0 56881 31005
71980 0 8565 31005
52632 0 52157 31005
15960 204 7000 31005
756 84 8308 31005
3576 37 10188 31005
37464 0 11083 31005
206076 0 16421 31005
4860 174 1722 31005
2200 184 3360 31005
42468 1306 36867 30993
134628 0 53616 30993
1900 58 6643 30993
9480 89 5769 30993
23292 70 6040 30993
6270 47 2007 30993
33984 0 27793 30993
14304 66 4861 30993
10872 122 12310 30993
4128 37 2021 30993
1560 182 8804 30996
174504 0 35296 30996
146640 0 22957 30996
17016 12 4537 30996
396 0 1047 30996
5784 175 2916 30996
4060 0 3259 30996
3440 124 6213 30996
9612 10 13106 30996
64860 0 13671 30996
456924 0 1513 31003
402 0 675 31003
174948 776 5411 31003
127176 218 26010 31003
2184 0 2437 31003
700 1 4660 31003
3912 116 621 31003
2520 0 361 31003
27252 0 4044 31003
10840 0 2533 31003
2280 67 1760 31005
4956 0 28572 31005
124980 0 -13596 31005
4200 95 1680 31005
156 27 2790 31005
13272 0 -2064 31005
5112 1788 1656 31005
89616 0 131544 31005
1620 0 5820 31005
2248 0 11880 31005
6440 38 2398 31003
28536 31 5647 31003
11496 0 2205 31003
3260 0 4840 31003
43416 1429 50197 31003
11344 32 1912 31003
14544 47 6779 31003
45672 0 21224 31003
230916 0 19658 31003
108 0 1746 31003
1008 1 11254 30997
4608 46 33485 30997
147864 866 13444 30997
720 34 12586 30997
14652 0 12152 30997
5120 81 5039 30997
2328 21 39 30997
56316 785 9253 30997
660 0 3732 30997
68760 0 142163 30997
3282 28 907 31007
12552 43 4241 31007
11520 0 14679 31007
230064 0 54380 31007
30216 0 3660 31007
15600 19 42591 31007
76728 0 44459 31007
12204 16 6480 31007
130032 0 21030 31007
5400 0 4758 31007
9720 81 2637 30999
3280 105 4863 30999
9612 0 2694 30999
36396 0 1529 30999
4600 22 32813 30999
872 118 11797 30999
172272 0 39518 30999
108 54 253 30999
3528 8 1489 30999
61392 0 -2499 30999
2532 0 16122 31004
3948 61 2570 31004
30640 20 633 31004
4360 317 4380 31004
89736 0 67611 31004
8808 222 1783 31004
25224 0 8484 31004
10736 0 12725 31004
10296 0 4671 31004
6756 0 11645 31004
23184 9 8280 31005
66000 0 59022 31005
158208 0 58511 31005
9960 39 3579 31005
50256 0 17772 31005
9912 0 4542 31005
1360 9 8854 31005
186 0 2273 31005
21040 169 17362 31005
23856 606 6330 31005
12840 601 6541 30999
30 0 964 30999
33840 0 13286 30999
216 42 6233 30999
4400 0 3654 30999
100368 0 145405 30999
43980 0 7059 30999
144 2 2654 30999
1040 216 9018 30999
120552 0 53304 30999
51624 0 17686 30999
1488 0 2303 30999
28872 0 13544 30999
360 0 10756 30999
297420 0 82028 30999
31800 233 13271 30999
7536 0 6564 30999
107280 0 46242 30999
204 2 1470 30999
13200 905 7766 30999
124248 1594 83120 30995
1296 541 9369 30995
77424 1914 34068 30995
384 0 1500 30995
640 635 7121 30995
209040 0 89196 30995
24 154 921 30995
488 0 6634 30995
3600 260 2151 30995
33840 1482 7734 30995
42 0 2220 30996
880 160 7961 30996
1360 0 13491 30996
290796 0 28547 30996
10200 0 3441 30996
120744 0 103149 30996
1800 0 10845 30996
112212 0 25200 30996
22800 168 4686 30996
640 1 9395 30996
144792 0 2261 30995
3120 0 2361 30995
23904 0 11925 30995
10560 12 9173 30995
32380 40 20751 30995
10248 24 6030 30995
373632 0 423 30995
24 12 990 30995
57144 0 16090 30995
736 16 5323 30995
4680 0 2358 31000
600 1 40512 31000
294 6 1416 31000
167016 0 58870 31000
10836 8 9917 31000
127392 331 4896 31000
936 0 585 31000
4040 0 6773 31000
280944 0 5688 31000
408 8 2131 31000
Average household size (h) Size of the product (size) markup
2 0 0
2 0 0
2 1 0
2 0 0
2 0 0
2 1 0
2 1 0
2 0 0
2 0 0
2 1 0
3 0 0
3 0 0
3 1 0
3 1 0
3 0 0
3 0 0
3 1 0
3 0 0
3 1 0
3 0 0
3 1 0
3 0 0
3 0 0
3 1 0
3 0 0
3 1 0
3 0 0
3 0 0
3 0 0
3 1 0
3 0 0
3 1 0
3 1 0
3 1 0
3 0 0
3 0 0
3 1 0
3 0 0
3 0 0
3 0 0
3 0 0
3 0 0
3 1 0
3 0 0
3 0 0
3 1 0
3 0 0
3 1 0
3 1 0
3 0 0
4 0 0
4 0 0
4 0 0
4 0 0
4 0 0
4 0 0
4 1 0
4 1 0
4 1 0
4 1 0
2 0 0
2 0 0
2 0 0
2 1 0
2 0 0
2 0 0
2 1 0
2 0 0
2 1 0
2 1 0
3 0 0
3 1 0
3 1 0
3 1 0
3 0 0
3 0 0
3 0 0
3 0 0
3 1 0
3 0 0
2 0 0
2 0 0
2 1 0
2 1 0
2 1 0
2 0 0
2 0 0
2 0 0
2 0 0
2 1 0
2 1 0
2 0 0
2 1 0
2 0 0
2 1 0
2 0 0
2 0 0
2 0 0
2 0 0
2 1 0
1 0 0
1 1 0
1 1 0
1 0 0
1 0 0
1 1 0
1 0 0
1 1 0
1 0 0
1 0 0
3 1 0
3 0 0
3 0 0
3 0 0
3 1 0
3 0 0
3 0 0
3 1 0
3 0 0
3 1 0
1 1 0
1 1 0
1 0 0
1 0 0
1 0 0
1 1 0
1 0 0
1 1 0
1 0 0
1 0 0
0 1 0
0 1 0
0 1 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 1 0
0 0 0
2 1 0
2 0 0
2 1 0
2 0 0
2 0 0
2 0 0
2 1 0
2 0 0
2 0 0
2 1 0
0 1 0
0 0 0
0 1 0
0 0 0
0 1 0
0 1 0
0 0 0
0 0 0
0 0 0
0 0 0
2 0 0
2 1 0
2 1 0
2 0 0
2 0 0
2 0 0
2 0 0
2 0 0
2 1 0
2 1 0
3 0 0
3 0 0
3 0 0
3 1 0
3 0 0
3 1 0
3 0 0
3 1 0
3 1 0
3 0 0
3 0 0
3 0 0
3 1 0
3 1 0
3 0 0
3 0 0
3 0 0
3 1 0
3 1 0
3 0 0
3 0 0
3 0 0
3 1 0
3 1 0
3 0 0
3 1 0
3 1 0
3 0 0
3 0 0
3 0 0
1 0 0
1 0 0
1 0 0
1 1 0
1 1 0
1 1 0
1 0 0
1 0 0
1 0 0
1 1 0
1 1 0
1 0 0
1 1 0
1 0 0
1 0 0
1 0 0
1 0 0
1 1 0
1 0 0
1 1 0
1 0 0
1 1 0
1 1 0
1 0 0
1 0 0
1 0 0
1 1 0
1 0 0
1 1 0
1 0 0
3 0 0
3 0 0
3 0 0
3 0 0
3 1 0
3 0 0
3 1 0
3 0 0
3 1 0
3 1 0
1 0 0
1 0 0
1 0 0
1 1 0
1 1 0
1 1 0
1 0 0
1 1 0
1 0 0
1 0 0
0 0 0
0 0 0
0 1 0
0 0 0
0 0 0
0 1 0
0 0 0
0 1 0
0 1 0
0 0 0
2 0 0
2 0 0
2 1 0
2 1 0
2 0 0
2 0 0
2 0 0
2 1 0
2 0 0
2 1 0
3 1 0
3 0 0
3 0 0
3 0 0
3 1 0
3 0 0
3 1 0
3 0 0
3 0 0
3 1 0
2 0 0
2 1 0
2 0 0
2 0 0
2 0 0
2 1 0
2 0 0
2 0 0
2 1 0
2 1 0
prod_des
San miguel beer
CAFE BAQUE SUPER.GRANO 250 G
Leche Sam whole milk
Baque Coffee (mild)
Nescafe decaf
Marbu maria tea biscuits
Mistol all purpose cleaner
Cafe fortaleza coffee(intense)
Cafe fortaleza coffee (mild)
Leche Sam low fat milk
San miguel beer
Nescafe decaf
Mistol all purpose cleaner
Leche Sam whole milk
CAFE BAQUE SUPER.GRANO 250 G
Cafe fortaleza coffee (mild)
Marbu maria tea biscuits
Cafe fortaleza coffee(intense)
Leche Sam low fat milk
Baque Coffee (mild)
Marbu maria tea biscuits
Nescafe decaf
Cafe fortaleza coffee (mild)
Leche Sam low fat milk
Cafe fortaleza coffee(intense)
Mistol all purpose cleaner
Baque Coffee (mild)
San miguel beer
CAFE BAQUE SUPER.GRANO 250 G
Leche Sam whole milk
Nescafe decaf
Marbu maria tea biscuits
Leche Sam low fat milk
Mistol all purpose cleaner
CAFE BAQUE SUPER.GRANO 250 G
Cafe fortaleza coffee (mild)
Leche Sam whole milk
Cafe fortaleza coffee(intense)
San miguel beer
Baque Coffee (mild)
Cafe fortaleza coffee (mild)
CAFE BAQUE SUPER.GRANO 250 G
Mistol all purpose cleaner
Cafe fortaleza coffee(intense)
San miguel beer
Marbu maria tea biscuits
Nescafe decaf
Leche Sam low fat milk
Leche Sam whole milk
Baque Coffee (mild)
Cafe fortaleza coffee (mild)
Cafe fortaleza coffee(intense)
Nescafe decaf
Baque Coffee (mild)
CAFE BAQUE SUPER.GRANO 250 G
San miguel beer
Mistol all purpose cleaner
Leche Sam whole milk
Leche Sam low fat milk
Marbu maria tea biscuits
San miguel beer
Nescafe decaf
CAFE BAQUE SUPER.GRANO 250 G
Marbu maria tea biscuits
Cafe fortaleza coffee(intense)
Baque Coffee (mild)
Leche Sam whole milk
Cafe fortaleza coffee (mild)
Mistol all purpose cleaner
Leche Sam low fat milk
CAFE BAQUE SUPER.GRANO 250 G
Leche Sam low fat milk
Leche Sam whole milk
Marbu maria tea biscuits
Cafe fortaleza coffee(intense)
Cafe fortaleza coffee (mild)
Baque Coffee (mild)
San miguel beer
Mistol all purpose cleaner
Nescafe decaf
Cafe fortaleza coffee (mild)
Nescafe decaf
Marbu maria tea biscuits
Mistol all purpose cleaner
Leche Sam whole milk
CAFE BAQUE SUPER.GRANO 250 G
Cafe fortaleza coffee(intense)
San miguel beer
Baque Coffee (mild)
Leche Sam low fat milk
Mistol all purpose cleaner
San miguel beer
Marbu maria tea biscuits
Cafe fortaleza coffee(intense)
Leche Sam whole milk
CAFE BAQUE SUPER.GRANO 250 G
Nescafe decaf
Cafe fortaleza coffee (mild)
Baque Coffee (mild)
Leche Sam low fat milk
San miguel beer
Mistol all purpose cleaner
Leche Sam whole milk
Cafe fortaleza coffee (mild)
CAFE BAQUE SUPER.GRANO 250 G
Marbu maria tea biscuits
Nescafe decaf
Leche Sam low fat milk
Baque Coffee (mild)
Cafe fortaleza coffee(intense)
Marbu maria tea biscuits
Cafe fortaleza coffee(intense)
Cafe fortaleza coffee (mild)
San miguel beer
Mistol all purpose cleaner
Nescafe decaf
Baque Coffee (mild)
Leche Sam whole milk
CAFE BAQUE SUPER.GRANO 250 G
Leche Sam low fat milk
Leche Sam whole milk
Mistol all purpose cleaner
San miguel beer
Cafe fortaleza coffee(intense)
Nescafe decaf
Marbu maria tea biscuits
Cafe fortaleza coffee (mild)
Leche Sam low fat milk
Baque Coffee (mild)
CAFE BAQUE SUPER.GRANO 250 G
Leche Sam low fat milk
Leche Sam whole milk
Mistol all purpose cleaner
CAFE BAQUE SUPER.GRANO 250 G
Baque Coffee (mild)
Nescafe decaf
San miguel beer
Cafe fortaleza coffee (mild)
Marbu maria tea biscuits
Cafe fortaleza coffee(intense)
Marbu maria tea biscuits
San miguel beer
Leche Sam whole milk
Cafe fortaleza coffee (mild)
Nescafe decaf
Cafe fortaleza coffee(intense)
Mistol all purpose cleaner
CAFE BAQUE SUPER.GRANO 250 G
Baque Coffee (mild)
Leche Sam low fat milk
Leche Sam whole milk
Nescafe decaf
Leche Sam low fat milk
San miguel beer
Marbu maria tea biscuits
Mistol all purpose cleaner
Cafe fortaleza coffee (mild)
Cafe fortaleza coffee(intense)
Baque Coffee (mild)
CAFE BAQUE SUPER.GRANO 250 G
CAFE BAQUE SUPER.GRANO 250 G
Leche Sam low fat milk
Leche Sam whole milk
Cafe fortaleza coffee(intense)
Nescafe decaf
Cafe fortaleza coffee (mild)
Baque Coffee (mild)
San miguel beer
Mistol all purpose cleaner
Marbu maria tea biscuits
CAFE BAQUE SUPER.GRANO 250 G
Cafe fortaleza coffee (mild)
Cafe fortaleza coffee(intense)
Mistol all purpose cleaner
San miguel beer
Marbu maria tea biscuits
Baque Coffee (mild)
Leche Sam low fat milk
Leche Sam whole milk
Nescafe decaf
Cafe fortaleza coffee(intense)
Cafe fortaleza coffee (mild)
Leche Sam whole milk
Marbu maria tea biscuits
Baque Coffee (mild)
CAFE BAQUE SUPER.GRANO 250 G
Nescafe decaf
Leche Sam low fat milk
Mistol all purpose cleaner
San miguel beer
Nescafe decaf
Cafe fortaleza coffee(intense)
Marbu maria tea biscuits
Leche Sam whole milk
Cafe fortaleza coffee (mild)
Mistol all purpose cleaner
Leche Sam low fat milk
Baque Coffee (mild)
San miguel beer
CAFE BAQUE SUPER.GRANO 250 G
Cafe fortaleza coffee (mild)
CAFE BAQUE SUPER.GRANO 250 G
Baque Coffee (mild)
Leche Sam low fat milk
Mistol all purpose cleaner
Marbu maria tea biscuits
San miguel beer
Nescafe decaf
Cafe fortaleza coffee(intense)
Leche Sam whole milk
Leche Sam low fat milk
Nescafe decaf
Mistol all purpose cleaner
CAFE BAQUE SUPER.GRANO 250 G
San miguel beer
Cafe fortaleza coffee(intense)
Cafe fortaleza coffee (mild)
Marbu maria tea biscuits
Baque Coffee (mild)
Leche Sam whole milk
Baque Coffee (mild)
Leche Sam low fat milk
Leche Sam whole milk
CAFE BAQUE SUPER.GRANO 250 G
San miguel beer
Cafe fortaleza coffee(intense)
Marbu maria tea biscuits
Nescafe decaf
Mistol all purpose cleaner
Cafe fortaleza coffee (mild)
CAFE BAQUE SUPER.GRANO 250 G
Nescafe decaf
Baque Coffee (mild)
Cafe fortaleza coffee (mild)
Marbu maria tea biscuits
San miguel beer
Leche Sam low fat milk
Cafe fortaleza coffee(intense)
Mistol all purpose cleaner
Leche Sam whole milk
San miguel beer
Cafe fortaleza coffee(intense)
Baque Coffee (mild)
Marbu maria tea biscuits
Leche Sam whole milk
Mistol all purpose cleaner
Cafe fortaleza coffee (mild)
Leche Sam low fat milk
Nescafe decaf
CAFE BAQUE SUPER.GRANO 250 G
San miguel beer
Baque Coffee (mild)
Leche Sam low fat milk
Nescafe decaf
CAFE BAQUE SUPER.GRANO 250 G
Leche Sam whole milk
Cafe fortaleza coffee(intense)
Marbu maria tea biscuits
Mistol all purpose cleaner
Cafe fortaleza coffee (mild)
Nescafe decaf
CAFE BAQUE SUPER.GRANO 250 G
Mistol all purpose cleaner
Leche Sam whole milk
Cafe fortaleza coffee(intense)
San miguel beer
Baque Coffee (mild)
Leche Sam low fat milk
Cafe fortaleza coffee (mild)
Marbu maria tea biscuits
Leche Sam low fat milk
Cafe fortaleza coffee(intense)
Baque Coffee (mild)
CAFE BAQUE SUPER.GRANO 250 G
Mistol all purpose cleaner
Cafe fortaleza coffee (mild)
Leche Sam whole milk
Nescafe decaf
San miguel beer
Marbu maria tea biscuits
Cafe fortaleza coffee (mild)
Mistol all purpose cleaner
Nescafe decaf
San miguel beer
Baque Coffee (mild)
Leche Sam low fat milk
Cafe fortaleza coffee(intense)
CAFE BAQUE SUPER.GRANO 250 G
Leche Sam whole milk
Marbu maria tea biscuits
sup_code product_id city
26012 2697 1
4183 4993 1
12020 2841 1
4183 5789 1
20024 520 1
9020 7278 1
25002 8276 1
2133 3421 1
2133 7385 1
12020 3616 1
26012 2697 2
20024 520 2
25002 8276 2
12020 2841 2
4183 4993 2
2133 7385 2
9020 7278 2
2133 3421 2
12020 3616 2
4183 5789 2
9020 7278 3
20024 520 3
2133 7385 3
12020 3616 3
2133 3421 3
25002 8276 3
4183 5789 3
26012 2697 3
4183 4993 3
12020 2841 3
20024 520 4
9020 7278 4
12020 3616 4
25002 8276 4
4183 4993 4
2133 7385 4
12020 2841 4
2133 3421 4
26012 2697 4
4183 5789 4
2133 7385 5
4183 4993 5
25002 8276 5
2133 3421 5
26012 2697 5
9020 7278 5
20024 520 5
12020 3616 5
12020 2841 5
4183 5789 5
2133 7385 6
2133 3421 6
20024 520 6
4183 5789 6
4183 4993 6
26012 2697 6
25002 8276 6
12020 2841 6
12020 3616 6
9020 7278 6
26012 2697 7
20024 520 7
4183 4993 7
9020 7278 7
2133 3421 7
4183 5789 7
12020 2841 7
2133 7385 7
25002 8276 7
12020 3616 7
4183 4993 8
12020 3616 8
12020 2841 8
9020 7278 8
2133 3421 8
2133 7385 8
4183 5789 8
26012 2697 8
25002 8276 8
20024 520 8
2133 7385 9
20024 520 9
9020 7278 9
25002 8276 9
12020 2841 9
4183 4993 9
2133 3421 9
26012 2697 9
4183 5789 9
12020 3616 9
25002 8276 10
26012 2697 10
9020 7278 10
2133 3421 10
12020 2841 10
4183 4993 10
20024 520 10
2133 7385 10
4183 5789 10
12020 3616 10
26012 2697 11
25002 8276 11
12020 2841 11
2133 7385 11
4183 4993 11
9020 7278 11
20024 520 11
12020 3616 11
4183 5789 11
2133 3421 11
9020 7278 12
2133 3421 12
2133 7385 12
26012 2697 12
25002 8276 12
20024 520 12
4183 5789 12
12020 2841 12
4183 4993 12
12020 3616 12
12020 2841 13
25002 8276 13
26012 2697 13
2133 3421 13
20024 520 13
9020 7278 13
2133 7385 13
12020 3616 13
4183 5789 13
4183 4993 13
12020 3616 14
12020 2841 14
25002 8276 14
4183 4993 14
4183 5789 14
20024 520 14
26012 2697 14
2133 7385 14
9020 7278 14
2133 3421 14
9020 7278 15
26012 2697 15
12020 2841 15
2133 7385 15
20024 520 15
2133 3421 15
25002 8276 15
4183 4993 15
4183 5789 15
12020 3616 15
12020 2841 16
20024 520 16
12020 3616 16
26012 2697 16
9020 7278 16
25002 8276 16
2133 7385 16
2133 3421 16
4183 5789 16
4183 4993 16
4183 4993 17
12020 3616 17
12020 2841 17
2133 3421 17
20024 520 17
2133 7385 17
4183 5789 17
26012 2697 17
25002 8276 17
9020 7278 17
4183 4993 18
2133 7385 18
2133 3421 18
25002 8276 18
26012 2697 18
9020 7278 18
4183 5789 18
12020 3616 18
12020 2841 18
20024 520 18
2133 3421 19
2133 7385 19
12020 2841 19
9020 7278 19
4183 5789 19
4183 4993 19
20024 520 19
12020 3616 19
25002 8276 19
26012 2697 19
20024 520 20
2133 3421 20
9020 7278 20
12020 2841 20
2133 7385 20
25002 8276 20
12020 3616 20
4183 5789 20
26012 2697 20
4183 4993 20
2133 7385 21
4183 4993 21
4183 5789 21
12020 3616 21
25002 8276 21
9020 7278 21
26012 2697 21
20024 520 21
2133 3421 21
12020 2841 21
12020 3616 22
20024 520 22
25002 8276 22
4183 4993 22
26012 2697 22
2133 3421 22
2133 7385 22
9020 7278 22
4183 5789 22
12020 2841 22
4183 5789 23
12020 3616 23
12020 2841 23
4183 4993 23
26012 2697 23
2133 3421 23
9020 7278 23
20024 520 23
25002 8276 23
2133 7385 23
4183 4993 24
20024 520 24
4183 5789 24
2133 7385 24
9020 7278 24
26012 2697 24
12020 3616 24
2133 3421 24
25002 8276 24
12020 2841 24
26012 2697 25
2133 3421 25
4183 5789 25
9020 7278 25
12020 2841 25
25002 8276 25
2133 7385 25
12020 3616 25
20024 520 25
4183 4993 25
26012 2697 26
4183 5789 26
12020 3616 26
20024 520 26
4183 4993 26
12020 2841 26
2133 3421 26
9020 7278 26
25002 8276 26
2133 7385 26
20024 520 27
4183 4993 27
25002 8276 27
12020 2841 27
2133 3421 27
26012 2697 27
4183 5789 27
12020 3616 27
2133 7385 27
9020 7278 27
12020 3616 28
2133 3421 28
4183 5789 28
4183 4993 28
25002 8276 28
2133 7385 28
12020 2841 28
20024 520 28
26012 2697 28
9020 7278 28
2133 7385 29
25002 8276 29
20024 520 29
26012 2697 29
4183 5789 29
12020 3616 29
2133 3421 29
4183 4993 29
12020 2841 29
9020 7278 29
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.97178765446
R Square 0.94437124536
Adjusted R Squ 0.94258317824
Standard Error 23344.4221951
Observations 290

ANOVA
df SS MS F Significance F
Regression 9 2590405222094 2.87823E+11 528.15201299 5.3155182E-170
Residual 280 152589373334 544962047.6
Total 289 2742994595428

Coefficients Standard Error t Stat P-value Lower 95%


Intercept -10815774.012 10879181.9955 -0.99417162 0.3209976865 -32231144.58998
w_price 137.371604619 255.578255548 0.537493318 0.5913538041 -365.7271629573
p_price -301.51288302 313.976767413 -0.96030316 0.3377311693 -919.5675152236
p_sales 1.06389874649 0.01925224749 55.26101547 1.22416E-152 1.026001226745
price 130.30151297 202.769095995 0.642610317 0.5210028206 -268.8438762926
returns 1.3275847904 3.18400451629 0.416954431 0.6770312224 -4.940040538954
s 0.4963203247 0.06702487348 7.405016958 1.546182E-12 0.364383704458
i 349.207201085 350.936712246 0.995071729 0.3205605254 -341.6020661196
h 192.945897858 1422.07718201 0.135678921 0.8921726025 -2606.373927431
size 577.796123038 4381.39810521 0.131874828 0.8951780093 -8046.865557464
Upper 95% Lower 95,0% Upper 95,0%
10599596.5656 -32231144.59 10599596.56559
640.470372195 -365.727162957 640.4703721955
316.541749193 -919.567515224 316.5417491932
1.10179626623 1.026001226745 1.101796266235
529.446902232 -268.843876293 529.4469022317
7.59521011975 -4.94004053895 7.595210119754
0.62825694494 0.364383704458 0.628256944938
1040.01646829 -341.60206612 1040.01646829
2992.26572315 -2606.37392743 2992.265723148
9202.45780354 -8046.86555746 9202.457803539
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9738274599
R Square 0.9483399216
Adjusted R Sq 0.9464883059
Standard Erro 22536.574477
Observations 290

ANOVA
df SS MS F Significance F
Regression 10 2601291279657 260129127966 512.168867 4.1932347E-173
Residual 279 141703315771 507897189.14
Total 289 2742994595428

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%


Intercept -12437993.614 10508544.87835 -1.183607603 0.23757591 -33124097.0626 8248110
w_price 946.45506071 302.3560470445 3.1302666838 0.0019318 351.2662367683 1541.644
p_price -232.49697136 303.4777740182 -0.7661087278 0.44425928 -829.893918349 364.9
p_sales 1.0787098686 0.018859339347 57.197648799 3.905E-156 1.041585200093 1.115835
price -717.67981579 268.0816365178 -2.6770942804 0.00786619 -1245.39935545 -189.9603
returns 0.2611231802 3.082439565218 0.0847131549 0.93255019 -5.80666874132 6.328915
s 0.456820395 0.065265519434 6.9994140702 1.9148E-11 0.328345015967 0.585296
i 401.24434065 338.9787383524 1.1836858636 0.23754497 -266.036365628 1068.525
h -374.53519982 1378.326536668 -0.2717318356 0.78602918 -3087.77529666 2338.705
size 4778.185966 4325.988370564 1.1045304695 0.27031474 -3737.53566688 13293.91
markup 191257.9095 41311.59813522 4.6296419923 5.6201E-06 109935.8994056 272579.9
Lower 95,0%
Upper 95,0%
-3.3E+07 8248110
351.2662 1541.644
-829.8939 364.9
1.041585 1.115835
-1245.399 -189.9603
-5.806669 6.328915
0.328345 0.585296
-266.0364 1068.525
-3087.775 2338.705
-3737.536 13293.91
109935.9 272579.9

You might also like