
. 
. * TRADIT2.DO *
. 
. * Compares regressions from our methodology to traditional methodology in lit
> erature *
. * That is, naive estimators that don't try to purge prediction effect        
>         *
. 
. * Revision for second revision of JIE paper *
. 
. set more 1

. set mat 200

. set mem 20m
(20480k)

. 
. use movie

. 
. gen oscar  = 0

. replace oscar = 1 if oscarmaj > 0 | oscarmin > 0
(27 real changes made)

. 
. gen lwk1cpi  = ln(wk1cpi)

. gen wk1per   = wk1cpi / openscr

. gen lwk1per  = ln(wk1per)

. gen boxres   = grosscpi - wk1cpi

. gen lboxres  = ln(boxres)

. gen boxresp  = boxres / openscr

. gen lboxresp = ln(boxresp) 

. gen openper  = wk1cpi / grosscpi

. gen lgross   = ln(grosscpi)

. 
. drop if pre == 1
(39 observations deleted)

. 
. 
. * create variable for date of first Friday movie shown on. This will
. * allow clustering on opening weekend.
. 
. gen weekend = opendate + 6 - openwday

. 
. 
. *-------------------------------
. * Regression (1): 
. * opening weekend box office 
. * omitting quality proxies 
. * clustering on weekend
. * traditional methodology
. * all movies
. *-------------------------------
. 
. reg lwk1cpi ou uu advent animated children comedy crime document drama fantas
> y noir horror musical mystery romance scifi thrill war western disney fox son
> y mgm_ua gram orion univers warner paramnt year2-year9 openscr fourday month1
> -month11, robust cluster(weekend)

Regression with robust standard errors                 Number of obs =     609
                                                       F( 47,   346) =    8.64
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.7615
Number of clusters (weekend) = 347                     Root MSE      =  .49546

------------------------------------------------------------------------------
         |               Robust
 lwk1cpi |      Coef.   Std. Err.       t     P>|t|       [95% Conf. Interval]
---------+--------------------------------------------------------------------
      ou |   .2178237   .0475903      4.577   0.000       .1242211    .3114263
      uu |   .3707363    .057414      6.457   0.000       .2578119    .4836607
  advent |    -.16783   .0641266     -2.617   0.009       -.293957    -.041703
animated |  -.2486254   .1732008     -1.435   0.152      -.5892843    .0920335
children |   -.279725   .1267166     -2.207   0.028      -.5289568   -.0304931
  comedy |   .0284586   .0537743      0.529   0.597       -.077307    .1342243
   crime |   .2869374   .0830295      3.456   0.001       .1236314    .4502434
document |  -.7951303   .1393917     -5.704   0.000      -1.069292   -.5209687
   drama |   .1161661   .0521903      2.226   0.027        .013516    .2188162
 fantasy |    .304063   .1100755      2.762   0.006       .0875617    .5205643
    noir |  -.4564384   .1383381     -3.299   0.001      -.7285279   -.1843489
  horror |  -.0177692   .0899887     -0.197   0.844      -.1947629    .1592245
 musical |  -.2349068   .2069555     -1.135   0.257      -.6419559    .1721423
 mystery |   .1595962   .0880416      1.813   0.071      -.0135678    .3327603
 romance |   .1918155   .0576047      3.330   0.001        .078516     .305115
   scifi |   .0914352   .0764541      1.196   0.233       -.058938    .2418085
  thrill |   .1517716    .056321      2.695   0.007        .040997    .2625461
     war |   .0870431   .1186818      0.733   0.464      -.1463854    .3204716
 western |   .0430576   .1216026      0.354   0.723      -.1961157     .282231
  disney |   .6182985   .1512998      4.087   0.000       .3207154    .9158816
     fox |    .539333   .1598471      3.374   0.001       .2249388    .8537272
    sony |   .4723685   .1492252      3.165   0.002       .1788658    .7658711
  mgm_ua |   .1071716   .1656241      0.647   0.518      -.2185852    .4329283
    gram |   .4362906   .2004049      2.177   0.030       .0421255    .8304557
   orion |   .1473121   .1686275      0.874   0.383      -.1843518     .478976
 univers |   .5626128   .1517264      3.708   0.000       .2641905     .861035
  warner |   .4604923   .1459993      3.154   0.002       .1733345    .7476501
 paramnt |   .5003035   .1500737      3.334   0.001       .2051321     .795475
   year2 |   .1222266   .0978283      1.249   0.212      -.0701865    .3146396
   year3 |   .1084486   .1012999      1.071   0.285      -.0907924    .3076896
   year4 |   .1462608   .0873125      1.675   0.095      -.0254693     .317991
   year5 |   .2039434   .0972731      2.097   0.037       .0126225    .3952644
   year6 |    .028123   .0835469      0.337   0.737      -.1362007    .1924467
   year7 |     .04904   .0938079      0.523   0.601      -.1354656    .2335455
   year8 |  -.0973238   .0881609     -1.104   0.270      -.2707226    .0760749
   year9 |  -.2128638   .1058475     -2.011   0.045      -.4210493   -.0046783
 openscr |   .0012184   .0000482     25.252   0.000       .0011235    .0013133
 fourday |   .0695238   .0634376      1.096   0.274      -.0552479    .1942956
  month1 |   .1241584   .0978514      1.269   0.205         -.0683    .3166167
  month2 |   .1137735   .0825254      1.379   0.169      -.0485412    .2760881
  month3 |   .1182068   .0795752      1.485   0.138      -.0383052    .2747187
  month4 |  -.1243128   .0794945     -1.564   0.119       -.280666    .0320404
  month5 |  -.0773548   .0732153     -1.057   0.291      -.2213578    .0666482
  month6 |   .2007552   .1001971      2.004   0.046       .0036832    .3978272
  month7 |   .2873315   .0952053      3.018   0.003       .1000776    .4745854
  month8 |  -.0218016   .0909871     -0.240   0.811       -.200759    .1571559
  month9 |  -.1006664   .0966885     -1.041   0.299      -.2908377    .0895048
 month10 |  -.0572999   .0879695     -0.651   0.515      -.2303222    .1157225
 month11 |   .1587615    .119225      1.332   0.184      -.0757354    .3932585
   _cons |   12.64775   .1635049     77.354   0.000       12.32616    12.96934
------------------------------------------------------------------------------

. 
. test year2 year3 year4 year5 year6 year7 year8 year9

 ( 1)  year2 = 0.0
 ( 2)  year3 = 0.0
 ( 3)  year4 = 0.0
 ( 4)  year5 = 0.0
 ( 5)  year6 = 0.0
 ( 6)  year7 = 0.0
 ( 7)  year8 = 0.0
 ( 8)  year9 = 0.0

       F(  8,   346) =    3.85
            Prob > F =    0.0002


. test month1 month2 month3 month4 month5 month6 month7 month8 month9 month10 m
> onth11

 ( 1)  month1 = 0.0
 ( 2)  month2 = 0.0
 ( 3)  month3 = 0.0
 ( 4)  month4 = 0.0
 ( 5)  month5 = 0.0
 ( 6)  month6 = 0.0
 ( 7)  month7 = 0.0
 ( 8)  month8 = 0.0
 ( 9)  month9 = 0.0
 (10)  month10 = 0.0
 (11)  month11 = 0.0

       F( 11,   346) =    3.75
            Prob > F =    0.0000


. test advent animated children comedy crime document drama fantasy noir horror
>  musical mystery romance scifi thrill war western

 ( 1)  advent = 0.0
 ( 2)  animated = 0.0
 ( 3)  children = 0.0
 ( 4)  comedy = 0.0
 ( 5)  crime = 0.0
 ( 6)  document = 0.0
 ( 7)  drama = 0.0
 ( 8)  fantasy = 0.0
 ( 9)  noir = 0.0
 (10)  horror = 0.0
 (11)  musical = 0.0
 (12)  mystery = 0.0
 (13)  romance = 0.0
 (14)  scifi = 0.0
 (15)  thrill = 0.0
 (16)  war = 0.0
 (17)  western = 0.0

       F( 17,   346) =    5.38
            Prob > F =    0.0000


. test disney fox sony mgm_ua gram orion univers warner paramnt

 ( 1)  disney = 0.0
 ( 2)  fox = 0.0
 ( 3)  sony = 0.0
 ( 4)  mgm_ua = 0.0
 ( 5)  gram = 0.0
 ( 6)  orion = 0.0
 ( 7)  univers = 0.0
 ( 8)  warner = 0.0
 ( 9)  paramnt = 0.0

       F(  9,   346) =    5.47
            Prob > F =    0.0000


. 
. 
. *-------------------------------
. * Regression (2): 
. * opening weekend box office 
. * including quality proxies 
. * clustering on weekend
. * traditional methodology
. * all movies
. *-------------------------------
. 
. reg lwk1cpi ou uu advent animated children comedy crime document drama fantas
> y noir horror musical mystery romance scifi thrill war western disney fox son
> y mgm_ua gram orion univers warner paramnt maltin year2-year9 openscr fourday
>  month1-month11, robust cluster(weekend)

Regression with robust standard errors                 Number of obs =     609
                                                       F( 48,   346) =    6.86
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.7786
Number of clusters (weekend) = 347                     Root MSE      =  .47782

------------------------------------------------------------------------------
         |               Robust
 lwk1cpi |      Coef.   Std. Err.       t     P>|t|       [95% Conf. Interval]
---------+--------------------------------------------------------------------
      ou |   .1544022    .045638      3.383   0.001       .0646394    .2441649
      uu |     .24807   .0578641      4.287   0.000       .1342603    .3618798
  advent |  -.2163049   .0617773     -3.501   0.001      -.3378111   -.0947986
animated |  -.1955916   .1818258     -1.076   0.283      -.5532146    .1620314
children |  -.2822593   .1263367     -2.234   0.026      -.5307438   -.0337748
  comedy |   .0139722   .0511952      0.273   0.785      -.0867206    .1146651
   crime |   .2605922   .0806086      3.233   0.001       .1020477    .4191367
document |  -.6413162   .1402278     -4.573   0.000      -.9171224   -.3655099
   drama |   .0778413   .0497013      1.566   0.118      -.0199134    .1755961
 fantasy |   .3659553   .1048204      3.491   0.001         .15979    .5721206
    noir |  -.4788627   .1320129     -3.627   0.000      -.7385115   -.2192138
  horror |   -.058685   .0884566     -0.663   0.507      -.2326654    .1152954
 musical |  -.2809309   .1958473     -1.434   0.152      -.6661319    .1042701
 mystery |   .1218421   .0800587      1.522   0.129      -.0356209     .279305
 romance |   .1791728   .0569891      3.144   0.002       .0670842    .2912614
   scifi |   .0926867   .0762139      1.216   0.225      -.0572142    .2425877
  thrill |   .1238795   .0522793      2.370   0.018       .0210542    .2267048
     war |   .0406006   .1250421      0.325   0.746      -.2053377    .2865388
 western |    .045561   .1158031      0.393   0.694      -.1822056    .2733276
  disney |   .5266542    .146386      3.598   0.000       .2387358    .8145727
     fox |   .4450266   .1546042      2.878   0.004       .1409443    .7491088
    sony |   .3958985   .1454372      2.722   0.007       .1098462    .6819507
  mgm_ua |    .083666   .1618556      0.517   0.606      -.2346787    .4020106
    gram |   .3437266   .2045481      1.680   0.094      -.0585875    .7460407
   orion |   .0885613   .1649605      0.537   0.592      -.2358902    .4130128
 univers |   .4640039    .150556      3.082   0.002       .1678838    .7601241
  warner |   .3697629   .1440708      2.567   0.011       .0863982    .6531276
 paramnt |   .4273166   .1483879      2.880   0.004       .1354609    .7191724
  maltin |   .2605022   .0390926      6.664   0.000       .1836132    .3373912
   year2 |   .1187265   .0924251      1.285   0.200      -.0630592    .3005123
   year3 |   .1001102   .0940473      1.064   0.288      -.0848661    .2850865
   year4 |   .1148499   .0822703      1.396   0.164      -.0469629    .2766627
   year5 |   .1709391   .0917687      1.863   0.063      -.0095555    .3514338
   year6 |   .0229427   .0773039      0.297   0.767      -.1291021    .1749874
   year7 |   .0500285   .0878646      0.569   0.569      -.1227873    .2228444
   year8 |  -.1033752   .0829483     -1.246   0.214      -.2665216    .0597711
   year9 |  -.2207907   .0991802     -2.226   0.027      -.4158627   -.0257187
 openscr |   .0012187   .0000466     26.126   0.000        .001127    .0013105
 fourday |   .1282691   .0639914      2.004   0.046       .0024079    .2541302
  month1 |   .2480274   .0983311      2.522   0.012       .0546255    .4414293
  month2 |   .1936775   .0842906      2.298   0.022        .027891     .359464
  month3 |   .2025161   .0772193      2.623   0.009       .0506378    .3543943
  month4 |  -.0060343   .0757445     -0.080   0.937      -.1550119    .1429432
  month5 |  -.0338517   .0721796     -0.469   0.639      -.1758178    .1081143
  month6 |   .2246429   .0944133      2.379   0.018       .0389468    .4103391
  month7 |   .3433338   .0922639      3.721   0.000       .1618651    .5248025
  month8 |   .0411492    .090157      0.456   0.648      -.1361757     .218474
  month9 |  -.0185979   .1032982     -0.180   0.857      -.2217694    .1845737
 month10 |   .0110761   .0835108      0.133   0.895      -.1531767    .1753288
 month11 |   .2213752   .1179613      1.877   0.061      -.0106363    .4533867
   _cons |   12.14939   .1740687     69.797   0.000       11.80703    12.49176
------------------------------------------------------------------------------

. 
. test year2 year3 year4 year5 year6 year7 year8 year9

 ( 1)  year2 = 0.0
 ( 2)  year3 = 0.0
 ( 3)  year4 = 0.0
 ( 4)  year5 = 0.0
 ( 5)  year6 = 0.0
 ( 6)  year7 = 0.0
 ( 7)  year8 = 0.0
 ( 8)  year9 = 0.0

       F(  8,   346) =    3.68
            Prob > F =    0.0004


. test month1 month2 month3 month4 month5 month6 month7 month8 month9 month10 m
> onth11

 ( 1)  month1 = 0.0
 ( 2)  month2 = 0.0
 ( 3)  month3 = 0.0
 ( 4)  month4 = 0.0
 ( 5)  month5 = 0.0
 ( 6)  month6 = 0.0
 ( 7)  month7 = 0.0
 ( 8)  month8 = 0.0
 ( 9)  month9 = 0.0
 (10)  month10 = 0.0
 (11)  month11 = 0.0

       F( 11,   346) =    4.08
            Prob > F =    0.0000


. test advent animated children comedy crime document drama fantasy noir horror
>  musical mystery romance scifi thrill war western

 ( 1)  advent = 0.0
 ( 2)  animated = 0.0
 ( 3)  children = 0.0
 ( 4)  comedy = 0.0
 ( 5)  crime = 0.0
 ( 6)  document = 0.0
 ( 7)  drama = 0.0
 ( 8)  fantasy = 0.0
 ( 9)  noir = 0.0
 (10)  horror = 0.0
 (11)  musical = 0.0
 (12)  mystery = 0.0
 (13)  romance = 0.0
 (14)  scifi = 0.0
 (15)  thrill = 0.0
 (16)  war = 0.0
 (17)  western = 0.0

       F( 17,   346) =    5.17
            Prob > F =    0.0000


. test disney fox sony mgm_ua gram orion univers warner paramnt

 ( 1)  disney = 0.0
 ( 2)  fox = 0.0
 ( 3)  sony = 0.0
 ( 4)  mgm_ua = 0.0
 ( 5)  gram = 0.0
 ( 6)  orion = 0.0
 ( 7)  univers = 0.0
 ( 8)  warner = 0.0
 ( 9)  paramnt = 0.0

       F(  9,   346) =    4.38
            Prob > F =    0.0000


. 
. 
. *-------------------------------
. * Regression (3): 
. * opening weekend box office 
. * omitting quality proxies 
. * clustering on weekend
. * traditional methodology
. * just movies reviewed during
. * not after
. *-------------------------------
. 
. reg lwk1cpi ou uu advent animated children comedy crime document drama fantas
> y noir horror musical mystery romance scifi thrill war western disney fox son
> y mgm_ua gram orion univers warner paramnt year2-year9 openscr fourday month1
> -month11 if aft~=1, robust cluster(weekend)

Regression with robust standard errors                 Number of obs =     492
                                                       F( 47,   284) =    8.56
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.7554
Number of clusters (weekend) = 285                     Root MSE      =  .49758

------------------------------------------------------------------------------
         |               Robust
 lwk1cpi |      Coef.   Std. Err.       t     P>|t|       [95% Conf. Interval]
---------+--------------------------------------------------------------------
      ou |    .249796   .0531315      4.701   0.000       .1452146    .3543774
      uu |   .4045592   .0637528      6.346   0.000       .2790713    .5300471
  advent |  -.2216967   .0714012     -3.105   0.002      -.3622394    -.081154
animated |  -.3142413   .2122707     -1.480   0.140      -.7320648    .1035821
children |  -.2332831   .1641477     -1.421   0.156      -.5563835    .0898174
  comedy |  -.0039721   .0585728     -0.068   0.946       -.119264    .1113198
   crime |   .3248238   .0982069      3.308   0.001        .131518    .5181295
document |  (dropped)
   drama |   .1024042   .0583896      1.754   0.081       -.012527    .2173355
 fantasy |   .2414768   .1279488      1.887   0.060      -.0103715    .4933251
    noir |  -.6229093   .1424479     -4.373   0.000      -.9032969   -.3425217
  horror |   .0449618   .0949213      0.474   0.636      -.1418767    .2318004
 musical |  -.2799423   .2338636     -1.197   0.232      -.7402682    .1803835
 mystery |   .1271721   .0929013      1.369   0.172      -.0556904    .3100347
 romance |    .168048   .0652714      2.575   0.011       .0395709    .2965251
   scifi |   .1008412   .0913878      1.103   0.271      -.0790422    .2807245
  thrill |    .150055   .0610788      2.457   0.015       .0298304    .2702796
     war |   .1551477   .1398298      1.110   0.268      -.1200866    .4303819
 western |    .068367   .1500406      0.456   0.649      -.2269656    .3636997
  disney |   .6983023   .2039952      3.423   0.001       .2967679    1.099837
     fox |   .7188576   .2089207      3.441   0.001        .307628    1.130087
    sony |   .5862381   .2007726      2.920   0.004       .1910468    .9814293
  mgm_ua |   .2098003   .2221305      0.944   0.346      -.2274307    .6470313
    gram |   .5451134   .2616396      2.083   0.038       .0301145    1.060112
   orion |   .2685423   .2247778      1.195   0.233      -.1738996    .7109841
 univers |   .6712362   .2027633      3.310   0.001       .2721265    1.070346
  warner |   .5769084    .198466      2.907   0.004       .1862574    .9675594
 paramnt |   .5704825   .2030066      2.810   0.005        .170894     .970071
   year2 |   .0758699   .1156634      0.656   0.512      -.1517964    .3035361
   year3 |   .1040875   .1220972      0.852   0.395      -.1362428    .3444179
   year4 |   .0466008   .1108727      0.420   0.675      -.1716357    .2648373
   year5 |    .160616    .118177      1.359   0.175      -.0719979    .3932299
   year6 |  -.0347283   .1048479     -0.331   0.741       -.241106    .1716493
   year7 |   .0222388   .1094353      0.203   0.839      -.1931685     .237646
   year8 |  -.1287642   .1035542     -1.243   0.215      -.3325954     .075067
   year9 |   -.205871   .1211154     -1.700   0.090      -.4442688    .0325269
 openscr |   .0011692   .0000518     22.562   0.000       .0010672    .0012712
 fourday |   .0687077   .0830376      0.827   0.409      -.0947395     .232155
  month1 |  -.0523716   .1266251     -0.414   0.679      -.3016144    .1968711
  month2 |   .0561045    .091062      0.616   0.538      -.1231376    .2353467
  month3 |   .1259448   .0818175      1.539   0.125      -.0351008    .2869904
  month4 |  -.1138311    .074481     -1.528   0.128      -.2604359    .0327736
  month5 |   -.091254    .084451     -1.081   0.281      -.2574833    .0749752
  month6 |   .2457115   .1008383      2.437   0.015       .0472263    .4441968
  month7 |   .2790357   .0962108      2.900   0.004       .0896589    .4684125
  month8 |  -.0927321   .1001278     -0.926   0.355      -.2898189    .1043547
  month9 |  -.1303235    .103988     -1.253   0.211      -.3350085    .0743614
 month10 |  -.0604124   .0984035     -0.614   0.540      -.2541051    .1332803
 month11 |   .1584909   .1280327      1.238   0.217      -.0935225    .4105042
   _cons |   12.67645   .2124279     59.674   0.000       12.25831    13.09458
------------------------------------------------------------------------------

. 
. test year2 year3 year4 year5 year6 year7 year8 year9

 ( 1)  year2 = 0.0
 ( 2)  year3 = 0.0
 ( 3)  year4 = 0.0
 ( 4)  year5 = 0.0
 ( 5)  year6 = 0.0
 ( 6)  year7 = 0.0
 ( 7)  year8 = 0.0
 ( 8)  year9 = 0.0

       F(  8,   284) =    2.72
            Prob > F =    0.0066


. test month1 month2 month3 month4 month5 month6 month7 month8 month9 month10 m
> onth11

 ( 1)  month1 = 0.0
 ( 2)  month2 = 0.0
 ( 3)  month3 = 0.0
 ( 4)  month4 = 0.0
 ( 5)  month5 = 0.0
 ( 6)  month6 = 0.0
 ( 7)  month7 = 0.0
 ( 8)  month8 = 0.0
 ( 9)  month9 = 0.0
 (10)  month10 = 0.0
 (11)  month11 = 0.0

       F( 11,   284) =    3.73
            Prob > F =    0.0001


. test advent animated children comedy crime document drama fantasy noir horror
>  musical mystery romance scifi thrill war western

 ( 1)  advent = 0.0
 ( 2)  animated = 0.0
 ( 3)  children = 0.0
 ( 4)  comedy = 0.0
 ( 5)  crime = 0.0
 ( 6)  document = 0.0
 ( 7)  drama = 0.0
 ( 8)  fantasy = 0.0
 ( 9)  noir = 0.0
 (10)  horror = 0.0
 (11)  musical = 0.0
 (12)  mystery = 0.0
 (13)  romance = 0.0
 (14)  scifi = 0.0
 (15)  thrill = 0.0
 (16)  war = 0.0
 (17)  western = 0.0
       Constraint 6 dropped

       F( 16,   284) =    4.00
            Prob > F =    0.0000


. test disney fox sony mgm_ua gram orion univers warner paramnt

 ( 1)  disney = 0.0
 ( 2)  fox = 0.0
 ( 3)  sony = 0.0
 ( 4)  mgm_ua = 0.0
 ( 5)  gram = 0.0
 ( 6)  orion = 0.0
 ( 7)  univers = 0.0
 ( 8)  warner = 0.0
 ( 9)  paramnt = 0.0

       F(  9,   284) =    4.10
            Prob > F =    0.0001


. 
. *-------------------------------
. * Regression (4): 
. * opening weekend box office 
. * including quality proxies 
. * clustering on weekend
. * traditional methodology
. * just movies reviewed during 
. * not after
. *-------------------------------
. 
. reg lwk1cpi ou uu advent animated children comedy crime document drama fantas
> y noir horror musical mystery romance scifi thrill war western disney fox son
> y mgm_ua gram orion univers warner paramnt maltin year2-year9 openscr fourday
>  month1-month11 if aft~=1, robust cluster(weekend)

Regression with robust standard errors                 Number of obs =     492
                                                       F( 48,   284) =    9.58
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.7733
Number of clusters (weekend) = 285                     Root MSE      =  .47961

------------------------------------------------------------------------------
         |               Robust
 lwk1cpi |      Coef.   Std. Err.       t     P>|t|       [95% Conf. Interval]
---------+--------------------------------------------------------------------
      ou |   .1764782   .0535687      3.294   0.001       .0710362    .2819203
      uu |   .2836623   .0658137      4.310   0.000       .1541177    .4132069
  advent |  -.2793479   .0685644     -4.074   0.000      -.4143068    -.144389
animated |  -.3128277   .2122681     -1.474   0.142      -.7306461    .1049908
children |  -.2058413   .1644961     -1.251   0.212      -.5296276    .1179449
  comedy |   -.008443   .0562427     -0.150   0.881      -.1191485    .1022624
   crime |   .2855376   .0969675      2.945   0.004       .0946715    .4764038
document |  (dropped)
   drama |   .0738833   .0559901      1.320   0.188      -.0363249    .1840915
 fantasy |   .3036191   .1157825      2.622   0.009       .0757185    .5315198
    noir |  -.6295375   .1361932     -4.622   0.000      -.8976136   -.3614613
  horror |   .0147325   .0960588      0.153   0.878      -.1743451    .2038101
 musical |  -.3002023   .2175494     -1.380   0.169      -.7284161    .1280116
 mystery |   .0955243   .0828122      1.154   0.250      -.0674791    .2585278
 romance |   .1519073   .0660817      2.299   0.022       .0218352    .2819794
   scifi |   .1086757   .0905177      1.201   0.231       -.069495    .2868463
  thrill |   .1261781   .0552781      2.283   0.023       .0173714    .2349849
     war |   .1094653   .1552019      0.705   0.481      -.1960267    .4149574
 western |   .0929841   .1440813      0.645   0.519      -.1906185    .3765868
  disney |   .6270893   .1965527      3.190   0.002       .2402043    1.013974
     fox |   .6565744   .2011075      3.265   0.001       .2607242    1.052425
    sony |   .5370696   .1938254      2.771   0.006       .1555529    .9185862
  mgm_ua |   .2333928   .2152485      1.084   0.279      -.1902921    .6570777
    gram |   .4795725   .2633691      1.821   0.070      -.0388305    .9979756
   orion |   .2407847   .2165217      1.112   0.267      -.1854062    .6669756
 univers |   .5961084   .1985317      3.003   0.003       .2053281    .9868886
  warner |    .508349   .1934657      2.628   0.009       .1275403    .8891577
 paramnt |   .5127844   .1986065      2.582   0.010       .1218568    .9037119
  maltin |   .2671652   .0466932      5.722   0.000       .1752565    .3590739
   year2 |   .0548559   .1088652      0.504   0.615      -.1594291    .2691409
   year3 |   .1135339   .1125362      1.009   0.314       -.107977    .3350448
   year4 |  -.0099857   .1052943     -0.095   0.925       -.217242    .1972706
   year5 |   .1360581   .1101162      1.236   0.218      -.0806894    .3528055
   year6 |  -.0366699   .0974509     -0.376   0.707      -.2284876    .1551478
   year7 |   .0276322   .1017537      0.272   0.786      -.1726549    .2279193
   year8 |  -.1350907   .0973561     -1.388   0.166      -.3267217    .0565404
   year9 |   -.203067   .1133382     -1.792   0.074      -.4261565    .0200225
 openscr |   .0011702    .000051     22.958   0.000       .0010699    .0012705
 fourday |   .1246399   .0779329      1.599   0.111      -.0287595    .2780393
  month1 |   .0779093   .1278941      0.609   0.543      -.1738314    .3296499
  month2 |   .1193018   .0941308      1.267   0.206      -.0659807    .3045844
  month3 |   .2105707   .0793852      2.653   0.008       .0543127    .3668288
  month4 |  -.0099616   .0715596     -0.139   0.889       -.150816    .1308928
  month5 |  -.0778601   .0850164     -0.916   0.361      -.2452023    .0894821
  month6 |   .2737429   .0948375      2.886   0.004       .0870693    .4604165
  month7 |    .316783   .0934592      3.390   0.001       .1328223    .5007437
  month8 |  -.0370676   .1021476     -0.363   0.717        -.23813    .1639948
  month9 |  -.0338988   .1126214     -0.301   0.764      -.2555773    .1877797
 month10 |  -.0118321   .0917287     -0.129   0.897      -.1923864    .1687223
 month11 |   .2286261   .1247947      1.832   0.068      -.0170137     .474266
   _cons |   12.13158   .2282644     53.147   0.000       11.68228    12.58089
------------------------------------------------------------------------------

. 
. test year2 year3 year4 year5 year6 year7 year8 year9

 ( 1)  year2 = 0.0
 ( 2)  year3 = 0.0
 ( 3)  year4 = 0.0
 ( 4)  year5 = 0.0
 ( 5)  year6 = 0.0
 ( 6)  year7 = 0.0
 ( 7)  year8 = 0.0
 ( 8)  year9 = 0.0

       F(  8,   284) =    2.74
            Prob > F =    0.0063


. test month1 month2 month3 month4 month5 month6 month7 month8 month9 month10 m
> onth11

 ( 1)  month1 = 0.0
 ( 2)  month2 = 0.0
 ( 3)  month3 = 0.0
 ( 4)  month4 = 0.0
 ( 5)  month5 = 0.0
 ( 6)  month6 = 0.0
 ( 7)  month7 = 0.0
 ( 8)  month8 = 0.0
 ( 9)  month9 = 0.0
 (10)  month10 = 0.0
 (11)  month11 = 0.0

       F( 11,   284) =    3.90
            Prob > F =    0.0000


. test advent animated children comedy crime document drama fantasy noir horror
>  musical mystery romance scifi thrill war western

 ( 1)  advent = 0.0
 ( 2)  animated = 0.0
 ( 3)  children = 0.0
 ( 4)  comedy = 0.0
 ( 5)  crime = 0.0
 ( 6)  document = 0.0
 ( 7)  drama = 0.0
 ( 8)  fantasy = 0.0
 ( 9)  noir = 0.0
 (10)  horror = 0.0
 (11)  musical = 0.0
 (12)  mystery = 0.0
 (13)  romance = 0.0
 (14)  scifi = 0.0
 (15)  thrill = 0.0
 (16)  war = 0.0
 (17)  western = 0.0
       Constraint 6 dropped

       F( 16,   284) =    4.35
            Prob > F =    0.0000


. test disney fox sony mgm_ua gram orion univers warner paramnt

 ( 1)  disney = 0.0
 ( 2)  fox = 0.0
 ( 3)  sony = 0.0
 ( 4)  mgm_ua = 0.0
 ( 5)  gram = 0.0
 ( 6)  orion = 0.0
 ( 7)  univers = 0.0
 ( 8)  warner = 0.0
 ( 9)  paramnt = 0.0

       F(  9,   284) =    3.31
            Prob > F =    0.0007


. 
. *-------------------------------
. * Regression (5): 
. * opening weekend box office 
. * omitting quality proxies 
. * clustering on weekend
. * traditional methodology
. * dramas
. *-------------------------------
. 
. reg lwk1cpi ou uu advent disney fox sony mgm_ua gram orion univers warner par
> amnt year2-year9 openscr fourday month1-month11 if drama==1, robust cluster(w
> eekend)

Regression with robust standard errors                 Number of obs =     198
                                                       F( 33,   168) =   22.77
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.7693
Number of clusters (weekend) = 169                     Root MSE      =  .53936

------------------------------------------------------------------------------
         |               Robust
 lwk1cpi |      Coef.   Std. Err.       t     P>|t|       [95% Conf. Interval]
---------+--------------------------------------------------------------------
      ou |   .1968197    .104388      1.885   0.061      -.0092617     .402901
      uu |   .2726479   .1080974      2.522   0.013       .0592437    .4860521
  advent |  -.1836034   .1799211     -1.020   0.309       -.538801    .1715942
  disney |   .9570977   .2531168      3.781   0.000       .4573984    1.456797
     fox |   .5897882   .3086275      1.911   0.058      -.0194996    1.199076
    sony |   .8557001    .244241      3.504   0.001       .3735232    1.337877
  mgm_ua |   .8390375   .2668493      3.144   0.002       .3122277    1.365847
    gram |   .7930459   .3423859      2.316   0.022       .1171128    1.468979
   orion |   .3687283   .3576968      1.031   0.304      -.3374315    1.074888
 univers |   1.268927    .264919      4.790   0.000       .7459273    1.791926
  warner |   .9105238   .2546794      3.575   0.000       .4077395    1.413308
 paramnt |   1.012632   .2586511      3.915   0.000       .5020067    1.523257
   year2 |   .1423919   .1901011      0.749   0.455      -.2329028    .5176867
   year3 |   .2175212   .2249384      0.967   0.335      -.2265488    .6615912
   year4 |   .2255526     .14044      1.606   0.110      -.0517021    .5028072
   year5 |   .3696759   .1642104      2.251   0.026       .0454943    .6938576
   year6 |   .2207779   .1419239      1.556   0.122      -.0594062     .500962
   year7 |   .3464502   .1341647      2.582   0.011       .0815842    .6113162
   year8 |   .0258711   .1530651      0.169   0.866      -.2763077      .32805
   year9 |  -.0373312   .1846334     -0.202   0.840      -.4018318    .3271694
 openscr |   .0011775   .0000783     15.043   0.000        .001023     .001332
 fourday |   .1489014   .1361588      1.094   0.276      -.1199012     .417704
  month1 |   .0532072   .2792369      0.191   0.849      -.4980581    .6044726
  month2 |  -.1741533   .2301622     -0.757   0.450      -.6285362    .2802295
  month3 |  -.0509801   .2263268     -0.225   0.822      -.4977911    .3958308
  month4 |  -.2578348   .2404166     -1.072   0.285      -.7324616     .216792
  month5 |  -.4307807    .232606     -1.852   0.066       -.889988    .0284266
  month6 |  -.3602156   .2954199     -1.219   0.224      -.9434292    .2229979
  month7 |   .4704435   .2678091      1.757   0.081      -.0582612    .9991482
  month8 |  -.1204157   .2661654     -0.452   0.652      -.6458755    .4050442
  month9 |  -.2442865   .2434428     -1.003   0.317      -.7248876    .2363146
 month10 |  -.1493393   .2602057     -0.574   0.567      -.6630336     .364355
 month11 |  -.0863635   .2688687     -0.321   0.748      -.6171602    .4444331
   _cons |   12.54879    .276865     45.325   0.000        12.0022    13.09537
------------------------------------------------------------------------------

. 
. test year2 year3 year4 year5 year6 year7 year8 year9

 ( 1)  year2 = 0.0
 ( 2)  year3 = 0.0
 ( 3)  year4 = 0.0
 ( 4)  year5 = 0.0
 ( 5)  year6 = 0.0
 ( 6)  year7 = 0.0
 ( 7)  year8 = 0.0
 ( 8)  year9 = 0.0

       F(  8,   168) =    1.58
            Prob > F =    0.1346


. test month1 month2 month3 month4 month5 month6 month7 month8 month9 month10 m
> onth11

 ( 1)  month1 = 0.0
 ( 2)  month2 = 0.0
 ( 3)  month3 = 0.0
 ( 4)  month4 = 0.0
 ( 5)  month5 = 0.0
 ( 6)  month6 = 0.0
 ( 7)  month7 = 0.0
 ( 8)  month8 = 0.0
 ( 9)  month9 = 0.0
 (10)  month10 = 0.0
 (11)  month11 = 0.0

       F( 11,   168) =    2.26
            Prob > F =    0.0137


. test disney fox sony mgm_ua gram orion univers warner paramnt

 ( 1)  disney = 0.0
 ( 2)  fox = 0.0
 ( 3)  sony = 0.0
 ( 4)  mgm_ua = 0.0
 ( 5)  gram = 0.0
 ( 6)  orion = 0.0
 ( 7)  univers = 0.0
 ( 8)  warner = 0.0
 ( 9)  paramnt = 0.0

       F(  9,   168) =    3.57
            Prob > F =    0.0004


. 
. *-------------------------------
. * Regression (6): 
. * opening weekend box office 
. * including quality proxies 
. * clustering on weekend
. * traditional methodology
. * dramas
. *-------------------------------
. 
. reg lwk1cpi ou uu disney fox sony mgm_ua gram orion univers warner paramnt ma
> ltin year2-year9 openscr fourday month1-month11 if drama==1, robust cluster(w
> eekend)

Regression with robust standard errors                 Number of obs =     198
                                                       F( 33,   168) =   22.90
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.7804
Number of clusters (weekend) = 169                     Root MSE      =  .52622

------------------------------------------------------------------------------
         |               Robust
 lwk1cpi |      Coef.   Std. Err.       t     P>|t|       [95% Conf. Interval]
---------+--------------------------------------------------------------------
      ou |   .1434897   .1023293      1.402   0.163      -.0585273    .3455067
      uu |    .143853   .1115394      1.290   0.199      -.0763465    .3640524
  disney |   .8672581   .2535919      3.420   0.001       .3666207    1.367895
     fox |   .4434718   .3046079      1.456   0.147      -.1578805    1.044824
    sony |   .7508233   .2454748      3.059   0.003       .2662106    1.235436
  mgm_ua |   .8036573   .2769315      2.902   0.004       .2569432    1.350371
    gram |   .6856977   .3528699      1.943   0.054      -.0109328    1.382328
   orion |    .258736   .3309216      0.782   0.435      -.3945646    .9120365
 univers |   1.137632    .273905      4.153   0.000       .5968932    1.678372
  warner |   .8436133   .2538492      3.323   0.001       .3424679    1.344759
 paramnt |    .910434   .2612649      3.485   0.001       .3946487    1.426219
  maltin |   .2447998   .0833621      2.937   0.004       .0802276     .409372
   year2 |   .1345744   .1800374      0.747   0.456      -.2208528    .4900016
   year3 |   .2034592   .2021369      1.007   0.316      -.1955964    .6025149
   year4 |   .2015059   .1321193      1.525   0.129      -.0593221     .462334
   year5 |   .3276238   .1582407      2.070   0.040       .0152274    .6400203
   year6 |   .2031719   .1351808      1.503   0.135      -.0637001    .4700439
   year7 |   .2922242   .1295005      2.257   0.025       .0365662    .5478823
   year8 |    .023236   .1385954      0.168   0.867       -.250377    .2968489
   year9 |   -.063153   .1666123     -0.379   0.705      -.3920766    .2657705
 openscr |   .0011687   .0000789     14.810   0.000       .0010129    .0013245
 fourday |   .1456883     .13251      1.099   0.273       -.115911    .4072877
  month1 |   .1397566   .2716226      0.515   0.608      -.3964767      .67599
  month2 |  -.1702033   .2256568     -0.754   0.452      -.6156917    .2752851
  month3 |  -.0231587   .2255358     -0.103   0.918      -.4684081    .4220908
  month4 |  -.1821257   .2436073     -0.748   0.456      -.6630517    .2988003
  month5 |  -.4125557   .2292082     -1.800   0.074      -.8650551    .0399437
  month6 |   -.392681    .283122     -1.387   0.167      -.9516163    .1662543
  month7 |    .508198   .2722432      1.867   0.064      -.0292604    1.045656
  month8 |  -.0646113   .2529512     -0.255   0.799      -.5639839    .4347612
  month9 |  -.1902888   .2394249     -0.795   0.428      -.6629578    .2823803
 month10 |  -.1430187   .2478948     -0.577   0.565       -.632409    .3463716
 month11 |  -.0172989   .2649879     -0.065   0.948       -.540434    .5058362
   _cons |   12.10157    .358011     33.802   0.000       11.39479    12.80835
------------------------------------------------------------------------------

. 
. test year2 year3 year4 year5 year6 year7 year8 year9

 ( 1)  year2 = 0.0
 ( 2)  year3 = 0.0
 ( 3)  year4 = 0.0
 ( 4)  year5 = 0.0
 ( 5)  year6 = 0.0
 ( 6)  year7 = 0.0
 ( 7)  year8 = 0.0
 ( 8)  year9 = 0.0

       F(  8,   168) =    1.35
            Prob > F =    0.2218


. test month1 month2 month3 month4 month5 month6 month7 month8 month9 month10 m
> onth11

 ( 1)  month1 = 0.0
 ( 2)  month2 = 0.0
 ( 3)  month3 = 0.0
 ( 4)  month4 = 0.0
 ( 5)  month5 = 0.0
 ( 6)  month6 = 0.0
 ( 7)  month7 = 0.0
 ( 8)  month8 = 0.0
 ( 9)  month9 = 0.0
 (10)  month10 = 0.0
 (11)  month11 = 0.0

       F( 11,   168) =    2.68
            Prob > F =    0.0034


. test disney fox sony mgm_ua gram orion univers warner paramnt

 ( 1)  disney = 0.0
 ( 2)  fox = 0.0
 ( 3)  sony = 0.0
 ( 4)  mgm_ua = 0.0
 ( 5)  gram = 0.0
 ( 6)  orion = 0.0
 ( 7)  univers = 0.0
 ( 8)  warner = 0.0
 ( 9)  paramnt = 0.0

       F(  9,   168) =    3.11
            Prob > F =    0.0017


. 
. 
. 
end of do-file

. exit, clear
