Приложения
ПРИЛОЖЕНИЕ 1. Контрольная выборка исходных данных для моделирования
Таблица 1
Статистика рекламных кампаний
№ | Издатель | Носитель | BVIS | BCONT | BF | BTECH | BC | BDIM | BPOS | AP | CTR |
1. | 1 | 120x600 Flash | 0,1 | 0,09 | 0,12 | 0,19 | 0,12 | 0,21 | 0,0239 | 7 у.е. за 1000 | 0,0031 |
2. | 3 | 468x60 GIF | 0,11 | 0,09 | 0,12 | 0,19 | 0,12 | 0,21 | 0,0301 | 15 у.е. за 1000 | 0,004 |
3. | 5 | Pop-up | 0,27 | 0,2 | 0,14 | 0,19 | 0,2 | 0,21 | 0,06 | 12 у.е. за 1000 | 0,0101 |
4. | 8 | 120x120 Статика | 0,27 | 0,21 | 0,15 | 0,19 | 0,21 | 0,21 | 0,0796 | 6 у.е. за 1000 | 0,0117 |
5. | 8 | Текст | 0,28 | 0,21 | 0,15 | 0,19 | 0,22 | 0,21 | 0,0841 | 26 у.е. за 1000 | 0,0131 |
6. | 4 | 468x60 GIF | 0,37 | 0,3 | 0,24 | 0,19 | 0,41 | 0,21 | 0,186 | 600 у.е. за неделю | 0,0242 |
7. | 5 | Текст | 0,46 | 0,37 | 0,28 | 0,73 | 0,49 | 0,21 | 0,2214 | 8 у.е. за 1000 | 0,034 |
8. | 10 | 120x600 Flash | 0,47 | 0,38 | 0,33 | 0,6 | 0,51 | 0,44 | 0,23 | 26 у.е. за 1000 | 0,0357 |
9. | 11 | Текстовая вставка в письмо | 0,48 | 0,42 | 0,32 | 0,6 | 0,55 | 0,21 | 0,2931 | 35 у.е. за 1000 | 0,041 |
10. | 12 | Динамический баннер в письме | 0,55 | 0,44 | 0,33 | 0,6 | 0,57 | 0,21 | 0,3341 | 60 у.е. за 1000 | 0,045 |
11. | 2 | 120x600 Flash | 0,61 | 0,53 | 0,35 | 0,6 | 0,63 | 0,37 | 0,322 | 15 у.е. за 1000 | 0,0522 |
12. | 6 | 120x120 Статика | 0,62 | 0,54 | 0,35 | 0,19 | 0,63 | 0,37 | 0,346 | 7 у.е. за 1000 | 0,0525 |
13. | 7 | 468x60 Статика | 0,62 | 0,55 | 0,36 | 0,6 | 0,65 | 0,37 | 0,343 | 9 у.е. за 1000 | 0,054 |
14. | 9 | Текст | 0,65 | 0,61 | 0,38 | 0,73 | 0,68 | 0,37 | 0,3754 | 5 у.е. за 1000 | 0,0592 |
15. | 3 | Pop-up | 0,61 | 0,63 | 0,45 | 0,73 | 0,67 | 0,44 | 0,4045 | 27 у.е. за 1000 | 0,061 |
16. | 7 | Pop-up | 0,69 | 0,66 | 0,49 | 0,73 | 0,77 | 0,44 | 0,4465 | 22 у.е. за 1000 | 0,0693 |
17. | 4 | Pop-under | 0,74 | 0,61 | 0,44 | 0,73 | 0,88 | 0,44 | 0,4739 | 25 у.е. за 1000 | 0,071 |
18. | 9 | 120x600 GIF | 0,76 | 0,68 | 0,45 | 0,73 | 0,9 | 0,44 | 0,4822 | 17 у.е. за 1000 | 0,0729 |
19. | 6 | 120x120 Статика | 0,87 | 0,68 | 0,62 | 0,6 | 0,88 | 0,44 | 0,5543 | 7 у.е. за 1000 | 0,0831 |
20. | 1 | 468x60 GIF | 0,89 | 0,69 | 0,65 | 0,6 | 0,9 | 0,44 | 0,5712 | 10 у.е. за 1000 | 0,0876 |
21. | 2 | 120x600 Flash | 0,91 | 0,74 | 0,69 | 0,73 | 0,91 | 0,44 | 0,58 | 5 у.е. за 1000 | 0,0891 |
22. | 9 | Pop-up | 0,92 | 0,79 | 0,64 | 0,73 | 0,93 | 0,44 | 0,7243 | 15 у.е. за 1000 | 0,101 |
Таблица 2
Перечень издателей и статистика показателей AF
№ | Издатель | Страница | Распределение показов | |||
1 | 2 | 3 | 4+ | |||
1. | Chat.ru | Главная | 18% | 21% | 31% | 30% |
2. | Chat.ru | Гл. страница раздела «Чаты» | 15% | 19% | 25% | 41% |
3. | Gazeta.ru | Главная | 48% | 31% | 14% | 7% |
4. | Gazeta.ru | Гл. страница раздела «Общество» | 68% | 19% | 10% | 3% |
5. | Auto.ru | Главная | 58% | 25% | 13% | 4% |
6. | Auto.ru | Гл. страница раздела «WWW-конференции» | 35% | 19% | 20% | 24% |
7. | Yandex.ru | Главная | 44% | 22% | 15% | 19% |
8. | Yandex.ru | Результаты поиска | 18% | 21% | 31% | 30% |
9. | Rambler.ru | Главная | 40% | 26% | 18% | 16% |
10. | Rambler.ru | Гл. страница раздела «Связь» | 59% | 24% | 12% | 5% |
И. | Subscribe.ru | Рассылка «Новые технологии в строительстве» | 89% | 5% | - | |
12. | Subscribe.ru | Рассылка «Изучение языков» | 91% | 3% | - | - |
ПРИЛОЖЕНИЕ 2. Результаты построения регрессионной модели
Descriptive Statistics
Mean | Std. Deviation | N | |
CTR | 4,885455 | 2,939808 | 22 |
Bvis | 55,6818 | 24,7644 | 22 |
Bcont | 47,3636 | 21,5441 | 22 |
BI | 36,5909 | 17,6518 | 22 |
Bdim | 51,6818 | 23,4995 | 22 |
Bpos | 58,3182 | 27,2299 | 22 |
Btech | 33,3182 | 10,7941 | 22 |
Be | 32,5709 | 19,7027 | 22 |
Correlations
CTR | Bvis | Bcont | Bf | Bdim | Bpos | Btech | Be | ||
Pearson Correlation | CTR | 1,000 | ,989 | ,983 | ,976 | ,780 | ,982 | ,851 | ,996 |
Bvis | ,989 | 1,000 | ,981 | ,966 | ,767 | ,984 | ,835 | ,980 | |
Bcont | ,983 | ,981 | 1,000 | ,942 | ,805 | ,981 | ,862 | ,972 | |
BI | ,976 | ,966 | ,942 | 1,000 | ,741 | ,944 | ,834 | ,971 | |
Bdim | ,780 | ,767 | ,805 | ,741 | 1,000 | ,814 | ,676 | ,767 | |
Bpos | ,982 | ,984 | ,981 | ,944 | ,814 | 1,000 | ,850 | ,973 | |
Btech | ,851 | ,835 | ,862 | ,834 | ,676 | ,850 | 1,000 | ,821 | |
Be | ,996 | ,980 | ,972 | ,971 | ,767 | ,973 | ,821 | 1,000 | |
Sig. (1- tailed) | CTR | 1 | ,000 | ,000 | ,000 | ,000 | ,000 | ,000 | ,000 |
Bvis | ,000 | » | ,000 | ,000 | ,000 | ,000 | ,000 | ,000 | |
Bcont | ,000 | ,000 | » | ,000 | ,000 | ,000 | ,000 | ,000 | |
Bf | ,000 | ,000 | ,000 | 1 | ,000 | ,000 | ,000 | ,000 | |
Bdim | ,000 | ,000 | ,000 | ,000 | 1 | ,000 | ,000 | ,000 | |
Bpos | ,000 | ,000 | ,000 | ,000 | ,000 | ,000 | ,000 | ||
Btech | ,000 | ,000 | ,000 | ,000 | ,000 | ,000 | ,000 | ||
Be | ,000 | ,000 | ,000 | ,000 | ,000 | ,000 | ,000 | ||
N | CTR | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 |
Bvis | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | |
Bcont | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | |
Bf | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | |
Bdim | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | |
Bpos | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | |
Btech | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | |
Be | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 |
Variables Entered/Removed
Model | Variables Entered | Variables Removed | Method |
1 | Be, Bdim, Btech, Bf, Bpos, Bcont, Bvisi | Enter | |
2 | t | Bpos | Backward {criterion: Probability of F-to-remove >= ,100). |
3 | f | Bdim | Backward {criterion: Probability of F-to-remove >=,100). |
a All requested variables entered, b Dependent Variable: CTR
Model Summary
Model | R | R Square | Adjusted R Square | Std. Error of the Estimate | Change Statistics | Durbin- Watson | ||||
R Square Change | F Change | df1 | df2 | Sig.F Change | ||||||
1 | ,999 | ,998 | ,998 | ,142570 | ,998 | 1273,573 | 7 | 14 | ,000 | |
2 | ,999 | ,998 | .998 | ,137737 | ,000 | ,000 | 1 | 16 | ,987 | |
3 | ,999 | ,998 | ,998 | ,135001 | ,000 | ,371 | 1 | 17 | ,552 | 2,560 |
a Predictors: (Constant), Be, Bdim, Btech, Bf, Bpos, Bcont, Bvis b Predictors: (Constant), Be, Bdim, Btech, Bf, Bcont, Bvis c Predictors: (Constant), Be, Btech, Bf, Bcont, Bvis d Dependent Variable: CTR
ANOVA
Model | Sum of Squares | df | Mean Square | F | Sig. | |
1 | Regression | 181,207 | 7 | 25,887 | 1273,573 | ,000 |
Residual | ,285 | 14 | 2.033E-02 | |||
Total | 181,492 | 21 | ||||
2 | Regression | 181,207 | 6 | 30,201 | 1591,933 | ,000 |
Residual | ,285 | 15 | 1.897E-02 | |||
Total | 181,492 | 21 | ||||
3 | Regression | 181,2oq | 5 | 36,240 | 1988,441 | ,000 |
Residual | ,292 | 16 | 1.823E-02 | |||
Total | 181,492 | 21 |
a Predictors: (Constant), Be, Bdim, Btech, Bf, Bpos, Bcont, Bvis b Predictors: (Constant), Be, Bdim, Btech, Bf, Bcont, Bvis c Predictors: (Constant), Be, Btech, Bf, Bcont, Bvis d Dependent Variable: CTR
Coefficients
Unstand. Coeff-s | Stand. Coeff-s | t | Sig. | 95% Conf. Int for В | Correlations | Collinear Statistics | |||||||
Mod | В | Std. Error | Beta | Lower Bound | Upper Bound | Zero- order | Partial | Part | Tolera nee | VIF | |||
1 | Constant | -.9007 | ,142 | 6,353 | ,000 | -1,205 | -,597 | ||||||
Bvis | ,0188 | ,011 | ,159 | 1,657 | ,120 | -,006 | ,043 | ,989 | ,405 | ,018 | ,012 | 81,920 | |
Bcont | ,0174 | ,010 | ,128 | 1,709 | ,110 | -,004 | ,039 | ,983 | ,415 | ,018 | ,020 | 49,780 | |
Bf | ,0171 | ,009 | ,103 | 1,851 | ,085 | -,003 | ,037 | ,976 | ,443 | ,020 | ,036 | 27,425 | |
Bdim | ,0013 | ,003 | ,011 | ,508 | ,619 | -.004 | ,007 | ,780 | ,135 | ,005 | ,256 | 3,912 | |
Bpos | ,0001 | ,009 | ,001 | ,017 | ,987 | -,018 | ,019 | ,982 | ,005 | ,000 | ,017 | 57,294 | |
Btech | ,0139 | ,007 | ,051 | 2,113 | ,053 | ,000 | ,028 | ,851 | ,492 | ,022 | ,192 | 5,221 | |
Be | ,0843 | ,011 | ,565 | 7,709 | ,000 | ,061 | ,108 | ,996 | ,900 | ,082 | ,021 | 47,968 | |
2 | Constant | -.9011 | ,135 | 6,660 | ,000 | -1,189 | -,613 | ||||||
Bvis | ,0190 | ,009 | ,160 | 2,177 | ,046 | ,000 | ,038 | ,989 | ,490 | ,022 | ,019 | 51,496 | |
Bcont | ,0174 | ,010 | ,128 | 1,768 | ,097 | -.004 | ,038 | ,983 | ,415 | ,018 | ,020 | 49,779 | |
Bf | ,0170 | ,008 | ,102 | 2,046 | ,059 | -,001 | ,035 | ,976 | ,467 | ,021 | ,042 | 23,900 | |
Bdim | ,0014 | ,002 | ,011 | ,609 | ,552 | -,003 | ,006 | ,780 | ,155 | ,006 | ,332 | 3,014 | |
Btech | ,0140 | ,006 | ,051 | 2,321 | ,035 | ,001 | ,027 | ,851 | ,514 | ,024 | ,215 | 4,660 | |
Be | ,0844 | ,010 | ,565 | 8,552 | ,000 | ,063 | ,105 | ,996 | ,911 | .087] | ,024 | 41,828 | |
3 | Constant | -.8829 | ,129 | 6,826 | ,000 | -1,157 | -,609 |
Bvis | ,0179 | ,008 | ,151 | 2,141 | ,048 | ,000 | ,036 | ,989 | ,472 | ,021 | ,020 | 49,513 | |
Bcont | ,0199 | ,009 | ,146 | 2,258 | ,038 | ,001 | ,039 | ,983 | ,492 | ,023 | ,024 | 41,403 | |
BI | ,0175 | ,008 | ,105 | 2,157 | ,047 | ,000 | ,035 | ,976 | ,475 | ,022 | ,042 | 23,681 | |
Btech | ,0135 | ,006 | ,050 | 2,312 | ,034 | ,001 | ,026 | ,851 | ,500 | ,023 | ,217 | 4,599 | |
Be | ,0840 | ,010 | ,563 | 8,704 | ,000 | ,064 | ,105 | ,996 | ,909 | ,087 | ,024 | 41,703 |
a Dependent Variable: CTR
Coefficient Correlations
Mo del | Be | Bdim | Btech | Bf | Bpos | Bcont | Bvis | ||
1 | Correlations | Be | 1,000 | ,216 | ,375 | -,626 | -,358 | -,404 | ,088 |
Bdim | ,216 | 1,000 | ,252 | -.250 | -,479 | -,363 | ,429 | ||
Btech | ,375 | ,252 | 1,000 | -,446 | -,328 | -.473 | ,346 | ||
Bf | -,626 | -,250 | -,446 | 1,000 | ,359 | ,380 | -.539 | ||
Bpos | -,358 | -,479 | -,328 | ,359 | 1,000 | ,005 | -,609 | ||
Bcont | -.404 | -,363 | -.473 | ,380 | ,005 | 1,000 | -.518 | ||
Bvis | ,088 | ,429 | ,346 | -,539 | -,609 | -.518 | 1,000 | ||
Covariances | Be | 1.196E-04 | 6.194E-06 | 2,701 E-05 | -6.323E-05 | -3.384E-05 | -4.503E-05 | 1.093E-05 | |
Bdim | 6.194E-06 | 6.857E-06 | 4.339E-06 | -6.048E-06 | -1.085E-05 | -9.675E-06 | 1.276E-05 | ||
Btech | 2,701 E-05 | 4.339E-06 | 4.337E-05 | -2.709E-05 | -1.868E-05 | -3.174E-05 | 2.592E-05 | ||
Bf | -6.323E-05 | -6,048E-06 | -2.709E- 05 | 8.519E-05 | 2.862E-05 | 3.576E-05 | -5.654E-05 | ||
Bpos | -3.384E-05 | -1.085E-05 | -1.868E- 05 | 2.862E-05 | 7.479E-05 | 4.808E-07 | -5.993E-05 | ||
Bcont | -4.503E-05 | -9.675E-06 | -3.174E- 05 | 3.576E-05 | 4.808E-07 | 1.038E-04 | -6,001 E-05 | ||
Bvis | 1.093E-05 | 1.276E-05 | 2.592E-05 | -5.654E-05 | -5.993E-05 | -6,001 E-05 | 1.293E-04 | ||
2 | Correlations | Be | 1,000 | ,055 | ,292 | -,571 | -.431 | -.176 | |
Bdim | ,055 | 1,000 | ,114 | -,096 | -.410 | ,196 | |||
Btech | ,292 | ,114 | 1,000 | -,372 | -.499 | ,195 | |||
Bf | -,571 | -,096 | -,372 | 1,000 | ,405 | -,433 | |||
Bcont | -,431 | -,410 | -,499 | ,405 | 1,000 | -.649 | |||
Bvis | -.176 | ,196 | ,195 | -,433 | -.649 | 1,000 | |||
Covariances | Be | 9.734E-05 | 1.198E-06 | 1.732E-05 | -4.693E-05 | -4.183E-05 | -1,510E-05 | ||
Bdim | 1.198E-06 | 4.930E-06 | 1.520E-06 | -1.769E-06 | ґ8,965Е-06 | 3.795E-06 | |||
Btech | 1.732E-05 | 1.520E-06 | 3.613E-05 | -1,861 E-05 | -2,951 E-05 | 1.023E-05 | |||
Bf | -4.693E-05 | -1.769E-06 | -1.861E- 05 | 6.930E-05 | 3,321 E-05 | -3.137E-05 | |||
Bcont | -4.183E-05 | -8.965E-06 | -2,951 E- 05 | 3,321 E-05 | 9.689E-05 | -5.565E-05 | |||
Bvis | -1.510E-05 | 3.795E-06 | 1.023E-05 | -3.137E-05 | -5.565E-05 | 7.586E-05 | |||
3 | Correlations | Be | 1,000 | ,288 | -,570 | -,448 | -,190 | ||
Btech | ,288 | 1,000 | -,365 | -,499 | ,178 | ||||
Bf | -,570 | -.365 | 1,000 | ,403 | -.424 | ||||
Bcont | -.448 | -,499 | ,403 | 1,000 | -,636 | ||||
Bvis | -.190 | ,178 | -,424 | -,636 | 1,000 | ||||
Covariances | Be | 9.323E-05 | 1.629E-05 | -4.467E-05 | -3.809E-05 | -1.540E-05 | |||
Btech | 1,629E-05 | 3,426E-05 | -1.735E-05 | -2,570E-05 | 8.700E-06 | ||||
Bf | -4.467E-05 | -1.735E- 05 | 6.596E-05 | 2,881 E-05 | -2.882E-05 | ||||
Bcont | -3.809E-05 | -2.570E- 05 | 2,881 E-05 | 7.742E-05 | -4.683E-05 | ||||
Bvis | -1.540E-05 | 8.700E-06 | -2.882E-05 | -4.683E-05 | 7.007E-05 |
a Dependent Variable: CTR
Collinearity Diagnostics
Eigenvalue | Condition Index | Variance Proportions | |||||||||
Mode 1 | Dimen sion | Constant | Bvis | Bcont | Bf | Bdim | Bpos | Btech | Be | ||
1 | 1 | 7,724 | 1,000 | ,00 | ,00 | ,00 | ,00 | ,00 | ,00 | ,00 | ,00 |
2 | ,179 | 6,575 | ,17 | ,00 | ,00 | ,00 | ,00 | ,00 | ,01 | ,01 | |
3 | 5.676E-02 | 11,665 | ,02 | ,00 | ,00 | ,01 | ,62 | ,00 | ,01 | ,00 | |
4 | 2.086E-02 | 19,245 | .39 | ,00 | ,00 | ,01 | ,00 | ,00 | ,61 | ,01 | |
5 | 1.104E-02 | 26,452 | ,00 | ,01 | .05 | .35 | ,09 | ,04 | ,02 | ,00 | |
6 | 4.020E-03 | 43,834 | ,31 | ,11 | ,01 | ,15 | ,00 | ,07 | ,04 | ,73 | |
7 | 3.120E-03 | 49,756 | ,03 | ,01 | ,57 | ,03 | ,00 | ,37 | ,05 | ,08 | |
8 | 1.165E-03 | 81,415 | ,08 | ,88 | ,37 | ,46 | ,28 | ,51 | ,26 | ,17 | |
2 | 1 | 6,734 | 1,000 | ,00 | ,00 | ,00 | ,00 | ,00 | ,00 | ,00 | |
2 | ,173 | 6,235 | ,17 | ,00 | ,00 | ,00 | ,00 | ,01 | ,01 | ||
3 | 5.676E-02 | 10,892 | ,02 | ,00 | ,00 | ,01 | ,81 | ,01 | ,00 | ||
4 | 2.085E-02 | 17,970 | ,40 | .00 | ,00 | ,01 | ,00 | ,68 | ,01 | ||
5 | 9.449E-03 | 26,696 | ,01 | ,02 | 72 | .46 | ,08 | ,02 | ,00 | ||
6 | 3.848E-03 | 41,833 | ,35 | ,23 | ,04 | ,15 | ,00 | ,07 | ,89 | ||
7 | 1.746E-03 | 62,097 | ,04 | 74 | ,85 | ,37 | ,11 | ,21 | ,09 | ||
3 | 1 | 5,790 | 1,000 | ,00 | ,00 | ,00 | ,00 | ,00 | ,00 | ||
2 | ,173 | 5,784 | ,18 | ,00 | ,00 | ,00 | ,01 | ,01 | |||
3 | 2.087E-02 | 16,656 | ,42 | ,00 | ,00 | ,01 | ,70 | ,01 | |||
4 | 1.022E-02 | 23,799 | ,00 | ,01 | ,14 | ,44 | ,02 | ,00 | |||
5 | 3.850E-03 | 38,779 | ,38 | ,23 | ,05 | ,16 | ,08 | ,80 | |||
6 | 1.948E-03 | 54,525 | ,02 | 75 | ,79 | ,39 | ,20| ,08 | ||||
a De | pendent Variable: Cl | rR |
Excluded Variables
Beta In | t | Sig. | Partial Correlation | Collinearity Statistics | ||||
Model | Tolerance | VIF | Minimum Tolerance | |||||
2 | Bpos | ,001 | ,017 | ,987 | .005 | 1.745E-02 | 57,294 | 1.221E-02 |
3 | Bpos | ,021 | ,305 | ,765 | ,078 | 2.266E-02 | 44,133 | 1.495E-02 |
Bdim | ,011 | ,609 | ,552 | ,155 | .332 | 3,014 | 1.942E-02 |
a Predictors in the Model: (Constant), Be, Bdim, Btech, Bf, Bcont, Bvis b Predictors in the Model: (Constant), Be, Btech, Bf, Bcont, Bvis c Dependent Variable: CTR
Residuals Statistics
Min | Max | Mean | Std. Deviation | N | |
Predicted Value | ,170417 | 10,139658 | 4,885455 | 2,937446 | 22 |
Residual | -,251073 | ,159549 | 2,56108E-16 | ,117839 | 22 |
Std. Predicted Value | -1,605 | 1,789 | ,000 | 1,000 | 22 |
Std. Residual | -1,860 | 1,182 | ,000 | ,873 | 22 |
a Dependent Variable: CTR
ПРИЛОЖЕНИЕ 3. Программный код модулей показа PC
Модуль Click.php
&bid=" target=_blank> height=
Еще по теме Приложения:
- Приложения Приложение 1 Нормативно-правовые акты, регламентирующие инвестиционную деятельность на территории Калининградской области
- Приложения Приложение 1 Налоговые последствия управления задолженностью
- Приложения Приложение 1 Теоретические основы
- Приложения Приложение 1 Гражданский кодекс Российской Федерации (часть вторая) Глава 34. Аренда § 6. Финансовая аренда (лизинг)
- Приложения
- Приложения
- Приложения
- Приложения
- Приложения
- Приложения
- Приложения
- Приложение
- Содержание и техника составления приложения к бухгалтерскому балансу
- Приложения
- Приложения
- Приложения