Table 10.
1 Data on advertisement revenue of programs along with CTRP and P
Serial CTRP P R Residulas SUMMARY OUTPUT
1 133 111600 1197576 1179938 17637.82
2 111 104400 1053648 1026857 26790.74 Regression Statistics
3 129 97200 1124172 1111050 13121.64 Multiple R 0.9121020395
4 117 79200 987144 983417.6 3726.374 R Square 0.8319301305
5 130 126000 1283616 1207303 76312.95 Adjusted R Square 0.8223261379
6 154 108000 1295100 1293217 1883.075 Standard Error 57548.382107
7 149 147600 1407444 1387749 19695.17 Observations 38
8 90 104400 922416 902288.4 20127.59
9 118 169200 1272012 1271602 409.8856 ANOVA
10 131 75600 1064856 1055173 9682.578 df
11 141 133200 1269960 1295134 -25173.61 Regression 2
12 119 133200 1064760 1164633 -99872.91 Residual 35
13 115 176400 1207488 1276387 -68898.78 Total 37
14 102 180000 1186284 1210563 -24278.83
15 129 133200 1231464 1223951 7512.59 Coefficients
16 144 147600 1296708 1358090 -61381.58 Intercept 41008.840348
17 153 122400 1320648 1332445 -11797.5 CTRP 5931.8501201
18 96 158400 1102704 1107231 -4527.095 P 3.1361404251
19 104 165600 1184316 1177266 7049.893
156 104400 1326360 1293791 32569.48
21 119 136800 1162596 1175923 -13327
22 125 115200 1195116 1143773 51342.52
23 130 115200 1134768 1173433 -38664.73
24 123 151200 1269024 1244811 24213.16
25 128 97200 1118688 1105119 13569.49
26 97 122400 904776 1000262 -95485.89
27 124 208800 1357644 1431384 -73740.38
28 138 93600 1027308 1153147 -125839
29 137 115200 1181976 1214956 -32979.68
30 129 118800 1221636 1178791 42845.01
31 97 129600 1060452 1022842 37609.9
32 133 100800 1229028 1146068 82960.14
33 145 147600 1406196 1364021 42174.57
34 149 126000 1293936 1320008 -26072.2
35 122 108000 1056384 1103398 -47013.72
36 120 194400 1415316 1362497 52819.45
37 128 176400 1338060 1353501 -15440.83
38 117 172800 1457400 1276960 180439.6
SS MS F Significance F
573761326866.65 286880663433.33 86.62336280339 2.7930107083E-14
115913569910.19 3311816283.1483
689674896776.84
Standard Error t Stat P-value Lower 95% Upper 95%
90958.919627967 0.4508501257071 0.6548784211505 -143647.58353337 225665.26423027
576.62190755252 10.28724375951 4.0198661045E-12 4761.2454139412 7102.4548261916
0.3031855822402 10.343962934852 3.4735206664E-12 2.5206409708371 3.7516398793112
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9121020395128
R Square 0.8319301304834
Adjusted R Square 0.8223261379395
Standard Error 57548.38210713
Observations 38
ANOVA
df SS MS F
Regression 2 573761326866.65 286880663433.33 86.62336280339
Residual 35 115913569910.19 3311816283.1483
Total 37 689674896776.84
Coefficients Standard Error t Stat P-value
Intercept 41008.840348449 90958.919627967 0.4508501257071 0.6548784211505
CTRP 5931.8501200664 576.62190755252 10.28724375951 4.0198661045E-12
P 3.1361404250741 0.3031855822402 10.343962934852 3.4735206664E-12
RESIDUAL OUTPUT PROBABILITY OUTPUT
Observation Predicted R Residuals Percentile
1 1179938.1777556 17637.822244442 1.3157894736842
2 1026857.2640536 26790.735946437 3.9473684210526
3 1111050.3551542 13121.644845775 6.5789473684211
4 983417.62606209 3726.3739379068 9.2105263157895
5 1207303.0495164 76312.950483573 11.842105263158
6 1293216.9247467 1883.0752533139 14.473684210526
7 1387748.8349793 19695.16502071 17.105263157895
8 902288.41153217 20127.588467832 19.736842105263
9 1271602.1144388 409.88556116726 22.368421052632
10 1055173.4222128 9682.5777872438 25
11 1295133.6118977 -25173.611897691 27.631578947368
12 1164632.9092562 -99872.90925623 30.263157894737
13 1276386.7751392 -68898.775139167 32.894736842105
14 1210562.8291086 -24278.829108571 35.526315789474
15 1223951.4104569 7512.5895431058 38.157894736842
16 1358089.584379 -61381.584378958 40.789473684211
17 1332445.4967477 -11797.496747687 43.421052631579
18 1107231.0952066 -4527.0952065706 46.052631578947
19 1177266.1072276 7049.892772364 48.684210526316
20 1293790.5194566 32569.480543448 51.315789473684
21 1175923.0147865 -13327.014786497 53.947368421053
22 1143773.4823253 51342.517674706 56.578947368421
23 1173432.7329256 -38664.732925626 59.210526315789
24 1244810.8373878 24213.16261217 61.842105263158
25 1105118.5050342 13569.494965842 64.473684210526
26 1000261.890024 -95485.890023968 67.105263157895
27 1431384.3759922 -73740.375992168 69.736842105263
28 1153146.9007046 -125838.90070456 72.368421052632
29 1214955.6837661 -32979.683766091 75
30 1178790.9883358 42845.011664174 77.631578947368
31 1022842.1010845 37609.898915498 80.263157894737
32 1146067.8611648 82960.138835242 82.894736842105
33 1364021.434499 42174.565500975 85.526315789474
34 1320008.2017977 -26072.201797689 88.157894736842
35 1103397.7209046 -47013.720904561 90.789473684211
36 1362496.5533908 52819.446609166 93.421052631579
37 1353500.8267 -15440.826700031 96.052631578947
38 1276960.369849 180439.63015097 98.684210526316
Lower 95.0% Upper 95.0%
-143647.58353337 225665.26423
4761.2454139412 7102.4548262
2.5206409708371 3.7516398793
CTRP Residual Plot Normal Probabilit
200000 2000000
150000
100000 1500000
Residuals
50000 f(x) = 4596.4824948025 x
1000000 R² = 0.969411775601467
0
R
f(x) =80
-50000 − 3.54483932002366E-13
90 100 110 120 x − 5.03613898368333E-11
130 140 150 160 500000
R² = 0
-100000 0
-150000 0 20 40 60
CTRP Sample Percentil
Significance F
2.7930107083E-14
P Residual Plot
200000
150000
100000
Residuals
Lower 95% Upper 95% Lower 95.0% Upper 95.0% 50000
0
-143647.58353337 225665.26423 -143647.58353 225665.26423 f(x)50000
-50000 = 1.4300334235469E-15
100000 x − 2.834186933786
150000 200000
4761.2454139412 7102.4548262 4761.2454139 7102.4548262 R² = 1.11022302462516E-16
-100000
2.5206409708371 3.7516398793 2.5206409708 3.7516398793 -150000
P
BILITY OUTPUT
R
904776
922416
987144
1027308
1053648
1056384
1060452
1064760
1064856
1102704
1118688
1124172
1134768
1162596
1181976
1184316
1186284
1195116
1197576
1207488
1221636
1229028
1231464
1269024
1269960
1272012
1283616
1293936
1295100
1296708
1320648
1326360
1338060
1357644
1406196
1407444
1415316
1457400
Normal Probability Plot
0
0
f(x) = 4596.4824948025 x + 970938.506838823
0 R² = 0.969411775601467
0
0
0 20 40 60 80 100 120
Sample Percentile
sidual Plot
35469E-15
000 x − 2.83418693378643E-10
150000 200000 250000
62516E-16