. . * REVISION4.DO * . . * Program for analyzing data for second revision of movie project with David > Reinstein * . * Plays around with specifications for the second revisions for JIE * . . 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 . * including quality proxies . * clustering on weekend . *------------------------------- . . reg lwk1cpi dur ou uu oudur uudur maltin advent animated children comedy crim > e document drama fantasy noir horror musical mystery romance scifi thrill war > western disney fox sony 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( 51, 346) = 6.96 Prob > F = 0.0000 R-squared = 0.7800 Number of clusters (weekend) = 347 Root MSE = .47756 ------------------------------------------------------------------------------ | Robust lwk1cpi | Coef. Std. Err. t P>|t| [95% Conf. Interval] ---------+-------------------------------------------------------------------- dur | -.1028177 .0680485 -1.511 0.132 -.2366586 .0310231 ou | .0671432 .1023822 0.656 0.512 -.1342267 .2685131 uu | .0382197 .1433768 0.267 0.790 -.2437801 .3202194 oudur | .1102886 .1166708 0.945 0.345 -.1191847 .3397618 uudur | .2546025 .1539807 1.653 0.099 -.0482535 .5574584 maltin | .2658419 .0399533 6.654 0.000 .18726 .3444238 advent | -.2151296 .0616726 -3.488 0.001 -.33643 -.0938293 animated | -.2088721 .1810962 -1.153 0.250 -.56506 .1473158 children | -.2876619 .1292502 -2.226 0.027 -.5418769 -.0334469 comedy | .0127472 .0510095 0.250 0.803 -.0875805 .113075 crime | .269768 .0801031 3.368 0.001 .1122177 .4273183 document | -.6257994 .1576162 -3.970 0.000 -.9358059 -.315793 drama | .0740062 .0503567 1.470 0.143 -.0250376 .1730501 fantasy | .3655927 .1020308 3.583 0.000 .1649141 .5662713 noir | -.5096491 .1330578 -3.830 0.000 -.771353 -.2479453 horror | -.0640929 .0874898 -0.733 0.464 -.2361716 .1079858 musical | -.2846104 .1936792 -1.469 0.143 -.6655471 .0963263 mystery | .1198487 .0807115 1.485 0.138 -.0388983 .2785957 romance | .1772109 .0573562 3.090 0.002 .0644001 .2900217 scifi | .0854228 .0773754 1.104 0.270 -.0667626 .2376082 thrill | .1352466 .0525015 2.576 0.010 .0319843 .2385089 war | .051096 .1268444 0.403 0.687 -.1983872 .3005791 western | .036157 .1165299 0.310 0.757 -.193039 .2653531 disney | .5311162 .1444824 3.676 0.000 .2469419 .8152905 fox | .4647563 .1545318 3.008 0.003 .1608164 .7686962 sony | .4075689 .1440418 2.830 0.005 .1242611 .6908767 mgm_ua | .1010671 .1597286 0.633 0.527 -.213094 .4152283 gram | .3795347 .2039987 1.860 0.064 -.0216989 .7807684 orion | .1060618 .1609933 0.659 0.510 -.210587 .4227106 univers | .4737957 .1497562 3.164 0.002 .1792487 .7683427 warner | .3815551 .1416456 2.694 0.007 .1029602 .6601499 paramnt | .4500025 .1467716 3.066 0.002 .1613257 .7386794 year2 | .1110598 .0917999 1.210 0.227 -.0694962 .2916159 year3 | .0882587 .0946042 0.933 0.352 -.0978129 .2743303 year4 | .1066684 .0822849 1.296 0.196 -.0551731 .2685099 year5 | .1658353 .0916815 1.809 0.071 -.0144879 .3461585 year6 | .0299942 .0783347 0.383 0.702 -.124078 .1840664 year7 | .0486678 .088871 0.548 0.584 -.1261276 .2234631 year8 | -.1008125 .0846334 -1.191 0.234 -.2672733 .0656483 year9 | -.2149794 .1022808 -2.102 0.036 -.4161497 -.0138091 openscr | .0012156 .0000462 26.297 0.000 .0011247 .0013065 fourday | .117602 .0638454 1.842 0.066 -.0079719 .2431759 month1 | .2362202 .1005561 2.349 0.019 .0384422 .4339983 month2 | .1754316 .0833532 2.105 0.036 .0114888 .3393743 month3 | .1964022 .0766831 2.561 0.011 .0455784 .3472259 month4 | -.0087157 .0735618 -0.118 0.906 -.1534002 .1359687 month5 | -.0438016 .0737261 -0.594 0.553 -.1888093 .101206 month6 | .2161998 .0934232 2.314 0.021 .0324509 .3999486 month7 | .3345343 .0913252 3.663 0.000 .1549119 .5141568 month8 | .0239731 .0898446 0.267 0.790 -.1527371 .2006833 month9 | -.0234479 .1028246 -0.228 0.820 -.2256879 .178792 month10 | .0079569 .0836666 0.095 0.924 -.1566023 .1725161 month11 | .2227605 .117841 1.890 0.060 -.0090144 .4545354 _cons | 12.21934 .1785994 68.418 0.000 11.86807 12.57062 ------------------------------------------------------------------------------ . . 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.27 Prob > F = 0.0013 . 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.93 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.36 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.41 Prob > F = 0.0000 . . *------------------------------- . * Regression (2): . * opening weekend box office . * including quality proxies . * clustering on opening weekend . * split sample of large movies . * measured by OPENSCR . *------------------------------- . . reg lwk1cpi dur ou uu oudur uudur maltin advent animated children comedy crim > e document drama fantasy noir horror musical mystery romance scifi thrill war > western disney fox sony mgm_ua gram orion univers warner paramnt year2-year9 > openscr fourday month1-month11 if openscr>1533, robust cluster(weekend) Regression with robust standard errors Number of obs = 304 F( 50, 226) = 7.60 Prob > F = 0.0000 R-squared = 0.6850 Number of clusters (weekend) = 227 Root MSE = .43016 ------------------------------------------------------------------------------ | Robust lwk1cpi | Coef. Std. Err. t P>|t| [95% Conf. Interval] ---------+-------------------------------------------------------------------- dur | -.0956453 .0883037 -1.083 0.280 -.2696491 .0783585 ou | .2569017 .1251945 2.052 0.041 .0102039 .5035994 uu | .3508743 .1886482 1.860 0.064 -.02086 .7226086 oudur | -.0575678 .1448787 -0.397 0.691 -.3430535 .227918 uudur | -.0378192 .2021538 -0.187 0.852 -.4361666 .3605283 maltin | .2377054 .0540081 4.401 0.000 .1312815 .3441292 advent | -.2865564 .0801524 -3.575 0.000 -.444498 -.1286149 animated | -.1651591 .1712936 -0.964 0.336 -.502696 .1723777 children | -.3181292 .1349095 -2.358 0.019 -.5839705 -.0522879 comedy | .0215537 .0627704 0.343 0.732 -.1021364 .1452438 crime | .2544444 .1358751 1.873 0.062 -.0132997 .5221885 document | -.6475832 .2211804 -2.928 0.004 -1.083423 -.2117436 drama | .0886032 .0732926 1.209 0.228 -.055821 .2330274 fantasy | .3849519 .1235027 3.117 0.002 .1415878 .6283161 noir | -.4618799 .2085363 -2.215 0.028 -.872804 -.0509557 horror | -.0855851 .0918373 -0.932 0.352 -.2665521 .0953818 musical | -.1245232 .2879205 -0.432 0.666 -.6918752 .4428289 mystery | .1391902 .1348334 1.032 0.303 -.1265012 .4048815 romance | .2077276 .0767359 2.707 0.007 .0565183 .3589369 scifi | .1271313 .0950117 1.338 0.182 -.0600907 .3143534 thrill | .1543879 .0669056 2.308 0.022 .0225493 .2862265 war | .0901408 .1802323 0.500 0.617 -.2650098 .4452914 western | -.0654021 .0835785 -0.783 0.435 -.2300949 .0992907 disney | .2084684 .1355339 1.538 0.125 -.0586034 .4755402 fox | .096356 .1492228 0.646 0.519 -.1976898 .3904019 sony | .1129952 .1362242 0.829 0.408 -.1554367 .3814272 mgm_ua | -.1707476 .2078311 -0.822 0.412 -.5802821 .2387869 gram | .4769566 .1848997 2.580 0.011 .1126088 .8413044 orion | -.3964254 .2507797 -1.581 0.115 -.890591 .0977401 univers | .1333167 .139062 0.959 0.339 -.1407072 .4073406 warner | .1958734 .1335559 1.467 0.144 -.0673007 .4590476 paramnt | .1123725 .1540561 0.729 0.466 -.1911976 .4159425 year2 | .1203505 .1888135 0.637 0.525 -.2517095 .4924105 year3 | .0911271 .1618988 0.563 0.574 -.2278972 .4101514 year4 | -.0163741 .1696755 -0.097 0.923 -.3507223 .3179742 year5 | .0730615 .1705002 0.429 0.669 -.2629119 .4090348 year6 | -.0881567 .1585114 -0.556 0.579 -.4005059 .2241925 year7 | -.0329994 .1619246 -0.204 0.839 -.3520744 .2860756 year8 | -.1210988 .1554216 -0.779 0.437 -.4273596 .185162 year9 | -.2537625 .1673457 -1.516 0.131 -.5835199 .0759949 openscr | .0011467 .000097 11.819 0.000 .0009555 .0013379 fourday | .0761671 .0801777 0.950 0.343 -.0818244 .2341586 month1 | .1441977 .1260948 1.144 0.254 -.1042742 .3926696 month2 | .3586628 .1274385 2.814 0.005 .1075431 .6097824 month3 | .2915749 .136276 2.140 0.033 .0230408 .560109 month4 | .0835961 .1182726 0.707 0.480 -.1494619 .3166541 month5 | .0517967 .1260161 0.411 0.681 -.19652 .3001135 month6 | .365479 .1171508 3.120 0.002 .1346314 .5963266 month7 | .3502797 .1296841 2.701 0.007 .094735 .6058244 month8 | .0402627 .1111564 0.362 0.718 -.1787728 .2592983 month9 | -.0163147 .1486005 -0.110 0.913 -.3091343 .276505 month10 | -.078103 .1179637 -0.662 0.509 -.3105525 .1543464 month11 | .1894954 .1326696 1.428 0.155 -.0719321 .450923 _cons | 12.664 .2911541 43.496 0.000 12.09028 13.23772 ------------------------------------------------------------------------------ . . 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, 226) = 1.60 Prob > F = 0.1260 . 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, 226) = 3.33 Prob > F = 0.0003 . 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, 226) = 3.36 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, 226) = 2.57 Prob > F = 0.0079 . . *------------------------------- . * Regression (3): . * opening weekend box office . * including quality proxies . * clustering on opening weekend . * split sample of small movies . * measured by OPENSCR . *------------------------------- . . reg lwk1cpi dur ou uu oudur uudur maltin advent animated children comedy crim > e document drama fantasy noir horror musical mystery romance scifi thrill war > western disney fox sony mgm_ua gram orion univers warner paramnt year2-year9 > openscr fourday month1-month11 if openscr<=1533, robust cluster(weekend) Regression with robust standard errors Number of obs = 305 F( 51, 221) = 18.21 Prob > F = 0.0000 R-squared = 0.6970 Number of clusters (weekend) = 222 Root MSE = .5184 ------------------------------------------------------------------------------ | Robust lwk1cpi | Coef. Std. Err. t P>|t| [95% Conf. Interval] ---------+-------------------------------------------------------------------- dur | -.0537542 .1129094 -0.476 0.634 -.2762712 .1687627 ou | .0197201 .153546 0.128 0.898 -.2828818 .3223219 uu | -.1472578 .197592 -0.745 0.457 -.5366636 .2421479 oudur | .1331388 .1819381 0.732 0.465 -.2254168 .4916944 uudur | .369646 .2065504 1.790 0.075 -.0374145 .7767064 maltin | .332512 .0640803 5.189 0.000 .2062254 .4587987 advent | -.0813257 .1083786 -0.750 0.454 -.2949134 .1322621 animated | -.4942695 .2516494 -1.964 0.051 -.9902091 .00167 children | .1296269 .2989983 0.434 0.665 -.4596258 .7188796 comedy | -.0212298 .0883565 -0.240 0.810 -.1953589 .1528994 crime | .3264693 .1059354 3.082 0.002 .1176964 .5352421 document | (dropped) drama | .064466 .0759825 0.848 0.397 -.0852769 .2142089 fantasy | .4580228 .1511504 3.030 0.003 .1601422 .7559033 noir | (dropped) horror | -.0523613 .2163588 -0.242 0.809 -.4787517 .3740292 musical | -.5198112 .240483 -2.162 0.032 -.9937447 -.0458777 mystery | .0827876 .1483839 0.558 0.577 -.2096408 .3752161 romance | .153883 .0852026 1.806 0.072 -.0140305 .3217965 scifi | .2847484 .1893172 1.504 0.134 -.0883497 .6578464 thrill | .0551169 .0947391 0.582 0.561 -.1315908 .2418246 war | -.0551999 .1428759 -0.386 0.700 -.3367734 .2263736 western | .4423279 .4942245 0.895 0.372 -.5316682 1.416324 disney | .5193905 .196287 2.646 0.009 .1325567 .9062243 fox | .5612488 .2096687 2.677 0.008 .1480428 .9744547 sony | .4112196 .193113 2.129 0.034 .030641 .7917983 mgm_ua | .0809997 .213488 0.379 0.705 -.3397331 .5017325 gram | .3049349 .2322907 1.313 0.191 -.1528534 .7627233 orion | .2328752 .2048401 1.137 0.257 -.1708147 .6365652 univers | .5690683 .2441874 2.330 0.021 .0878344 1.050302 warner | .3034645 .1910864 1.588 0.114 -.0731201 .6800492 paramnt | .5120406 .1915617 2.673 0.008 .1345192 .8895619 year2 | .1238646 .1188384 1.042 0.298 -.1103368 .3580661 year3 | .0875233 .1357606 0.645 0.520 -.1800277 .3550743 year4 | .1259036 .1062397 1.185 0.237 -.083469 .3352763 year5 | .2453986 .1341292 1.830 0.069 -.0189374 .5097347 year6 | .054605 .1216218 0.449 0.654 -.1850819 .2942919 year7 | .1313783 .1241762 1.058 0.291 -.1133427 .3760992 year8 | -.0656409 .1346252 -0.488 0.626 -.3309544 .1996725 year9 | -.1124278 .183903 -0.611 0.542 -.4748559 .2500002 openscr | .0014369 .0001014 14.175 0.000 .0012371 .0016366 fourday | .1815203 .1177123 1.542 0.124 -.0504619 .4135024 month1 | .327637 .1584326 2.068 0.040 .0154049 .6398691 month2 | .0815264 .1224449 0.666 0.506 -.1597827 .3228356 month3 | .1878541 .1096827 1.713 0.088 -.0283037 .404012 month4 | .1149746 .1179041 0.975 0.331 -.1173857 .3473349 month5 | -.0033858 .1220097 -0.028 0.978 -.2438372 .2370655 month6 | .079647 .1687605 0.472 0.637 -.2529388 .4122328 month7 | .4019035 .1580962 2.542 0.012 .0903343 .7134727 month8 | .12576 .1406963 0.894 0.372 -.1515182 .4030381 month9 | .0992386 .1434869 0.692 0.490 -.183539 .3820163 month10 | .1208808 .1452472 0.832 0.406 -.1653661 .4071276 month11 | .4472526 .2265019 1.975 0.050 .0008726 .8936327 _cons | 11.78844 .2471448 47.699 0.000 11.30138 12.2755 ------------------------------------------------------------------------------ . . 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, 221) = 1.08 Prob > F = 0.3751 . 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, 221) = 1.21 Prob > F = 0.2787 . 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 Constraint 9 dropped F( 15, 221) = 3.06 Prob > F = 0.0002 . 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, 221) = 2.81 Prob > F = 0.0038 . . *------------------------------- . * Regression (4): . * opening weekend box office . * including quality proxies . * clustering on opening weekend . * split sample of Dramas . *------------------------------- . . reg lwk1cpi dur ou uu oudur uudur maltin disney fox sony mgm_ua gram orion un > ivers warner paramnt year2-year9 openscr fourday month1-month11 if drama == 1 > , robust cluster(weekend) Regression with robust standard errors Number of obs = 198 F( 36, 168) = 22.81 Prob > F = 0.0000 R-squared = 0.7889 Number of clusters (weekend) = 169 Root MSE = .52077 ------------------------------------------------------------------------------ | Robust lwk1cpi | Coef. Std. Err. t P>|t| [95% Conf. Interval] ---------+-------------------------------------------------------------------- dur | -.2753721 .1792637 -1.536 0.126 -.6292718 .0785277 ou | -.2669218 .2213511 -1.206 0.230 -.7039098 .1700662 uu | -.4163988 .3224371 -1.291 0.198 -1.052949 .2201518 oudur | .5081742 .2423717 2.097 0.038 .0296876 .9866609 uudur | .6498793 .3428476 1.896 0.060 -.0269654 1.326724 maltin | .2483094 .0830064 2.991 0.003 .0844393 .4121795 disney | .889916 .2515261 3.538 0.001 .3933568 1.386475 fox | .4431372 .3010525 1.472 0.143 -.1511962 1.037471 sony | .7709118 .2445168 3.153 0.002 .2881903 1.253633 mgm_ua | .8395615 .268344 3.129 0.002 .3098007 1.369322 gram | .830799 .3508967 2.368 0.019 .1380638 1.523534 orion | .3857946 .31937 1.208 0.229 -.2447009 1.01629 univers | 1.189306 .2702001 4.402 0.000 .6558808 1.722731 warner | .8852931 .2493274 3.551 0.000 .3930748 1.377511 paramnt | .9309169 .2605568 3.573 0.000 .4165296 1.445304 year2 | .0595988 .1740283 0.342 0.732 -.2839653 .4031629 year3 | .19759 .1973509 1.001 0.318 -.1920173 .5871972 year4 | .1916567 .1330255 1.441 0.152 -.0709602 .4542736 year5 | .252584 .1668194 1.514 0.132 -.0767483 .5819163 year6 | .191637 .1398235 1.371 0.172 -.0844005 .4676745 year7 | .2640766 .1296245 2.037 0.043 .0081738 .5199794 year8 | .0127765 .1388677 0.092 0.927 -.2613741 .286927 year9 | -.1358965 .1691266 -0.804 0.423 -.4697838 .1979908 openscr | .0011679 .0000786 14.862 0.000 .0010128 .001323 fourday | .238078 .1514707 1.572 0.118 -.0609532 .5371092 month1 | .2665497 .2832418 0.941 0.348 -.2926221 .8257215 month2 | -.1805119 .2235764 -0.807 0.421 -.621893 .2608693 month3 | .0164083 .2277656 0.072 0.943 -.4332431 .4660598 month4 | -.1485435 .2452296 -0.606 0.546 -.6326721 .335585 month5 | -.442308 .2375914 -1.862 0.064 -.9113574 .0267415 month6 | -.314444 .2561333 -1.228 0.221 -.8200985 .1912105 month7 | .5905528 .2759645 2.140 0.034 .0457477 1.135358 month8 | -.0552342 .2467697 -0.224 0.823 -.5424032 .4319348 month9 | -.152424 .242189 -0.629 0.530 -.63055 .3257021 month10 | -.1268216 .250262 -0.507 0.613 -.6208852 .3672419 month11 | .0257521 .2640131 0.098 0.922 -.4954586 .5469628 _cons | 12.27655 .3822616 32.116 0.000 11.52189 13.0312 ------------------------------------------------------------------------------ . . 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.32 Prob > F = 0.2350 . 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) = 3.00 Prob > F = 0.0011 . 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.21 Prob > F = 0.0013 . . *------------------------------- . * Regression (5): . * opening weekend box office . * including quality proxies . * clustering on opening weekend . * split sample of Action . *------------------------------- . . reg lwk1cpi dur ou uu oudur uudur maltin disney fox sony mgm_ua gram orion un > ivers warner paramnt year2-year9 openscr fourday month1-month11 if action == > 1, robust cluster(weekend) Regression with robust standard errors Number of obs = 148 F( 35, 134) = 16.61 Prob > F = 0.0000 R-squared = 0.8184 Number of clusters (weekend) = 135 Root MSE = .43448 ------------------------------------------------------------------------------ | Robust lwk1cpi | Coef. Std. Err. t P>|t| [95% Conf. Interval] ---------+-------------------------------------------------------------------- dur | -.0840115 .1386531 -0.606 0.546 -.3582432 .1902203 ou | .2231396 .2091279 1.067 0.288 -.1904789 .636758 uu | .1382338 .2078944 0.665 0.507 -.2729452 .5494128 oudur | .0656405 .2206037 0.298 0.767 -.3706752 .5019563 uudur | .0775162 .2448616 0.317 0.752 -.4067773 .5618097 maltin | .3151592 .0709468 4.442 0.000 .1748388 .4554795 disney | .5892358 .196278 3.002 0.003 .2010322 .9774395 fox | .5270699 .2161527 2.438 0.016 .0995576 .9545822 sony | .4560682 .2237569 2.038 0.043 .0135162 .8986203 mgm_ua | .3695989 .2308052 1.601 0.112 -.0868935 .8260912 gram | -.1114056 .2710663 -0.411 0.682 -.6475275 .4247163 orion | .4155347 .4478531 0.928 0.355 -.4702406 1.30131 univers | .61641 .2399966 2.568 0.011 .1417385 1.091082 warner | .6701853 .2157266 3.107 0.002 .2435157 1.096855 paramnt | .5698283 .216633 2.630 0.010 .1413661 .9982906 year2 | .1408402 .2320379 0.607 0.545 -.3180903 .5997706 year3 | -.074949 .2170957 -0.345 0.730 -.5043264 .3544283 year4 | -.0361742 .2165279 -0.167 0.868 -.4644287 .3920803 year5 | .1402903 .2097587 0.669 0.505 -.2745758 .5551564 year6 | .1316124 .2067877 0.636 0.526 -.2773776 .5406024 year7 | -.0372922 .2263545 -0.165 0.869 -.484982 .4103977 year8 | .2201903 .2435846 0.904 0.368 -.2615776 .7019582 year9 | -.0961524 .2317248 -0.415 0.679 -.5544637 .3621589 openscr | .0010418 .0000999 10.427 0.000 .0008442 .0012394 fourday | .1536959 .1443449 1.065 0.289 -.1317933 .439185 month1 | .5386972 .2183228 2.467 0.015 .1068928 .9705016 month2 | .2805225 .2084757 1.346 0.181 -.1318061 .6928511 month3 | .2740975 .2711745 1.011 0.314 -.2622384 .8104334 month4 | .2627622 .2288654 1.148 0.253 -.1898938 .7154181 month5 | .1797531 .2270743 0.792 0.430 -.2693602 .6288665 month6 | .470308 .2226975 2.112 0.037 .0298512 .9107649 month7 | .5992081 .20334 2.947 0.004 .1970371 1.001379 month8 | .3126168 .2080687 1.502 0.135 -.0989068 .7241404 month9 | -.106982 .2341719 -0.457 0.649 -.5701332 .3561692 month10 | .3177212 .2292912 1.386 0.168 -.1357768 .7712193 month11 | .2879965 .2304792 1.250 0.214 -.1678513 .7438442 _cons | 12.1742 .3558432 34.212 0.000 11.47041 12.878 ------------------------------------------------------------------------------ . . 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, 134) = 1.21 Prob > F = 0.2950 . 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, 134) = 3.17 Prob > F = 0.0007 . 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, 134) = 2.08 Prob > F = 0.0351 . . *------------------------------- . * Regression (6): . * opening weekend box office . * including quality proxies . * clustering on opening weekend . * split sample of Comedies . *------------------------------- . . reg lwk1cpi dur ou uu oudur uudur maltin disney fox sony mgm_ua gram orion un > ivers warner paramnt year2-year9 openscr fourday month1-month11 if comedy == > 1, robust cluster(weekend) Regression with robust standard errors Number of obs = 267 F( 36, 210) = 20.48 Prob > F = 0.0000 R-squared = 0.7473 Number of clusters (weekend) = 211 Root MSE = .46275 ------------------------------------------------------------------------------ | Robust lwk1cpi | Coef. Std. Err. t P>|t| [95% Conf. Interval] ---------+-------------------------------------------------------------------- dur | -.0626631 .102119 -0.614 0.540 -.2639727 .1386465 ou | .2316599 .122454 1.892 0.060 -.0097367 .4730566 uu | .7181261 .2781714 2.582 0.011 .16976 1.266492 oudur | -.0105134 .1421958 -0.074 0.941 -.2908274 .2698006 uudur | -.37208 .2951252 -1.261 0.209 -.9538677 .2097076 maltin | .276903 .0646548 4.283 0.000 .1494473 .4043586 disney | .2869504 .2156869 1.330 0.185 -.1382386 .7121394 fox | .3373535 .2261634 1.492 0.137 -.1084881 .7831951 sony | .1062057 .2270732 0.468 0.640 -.3414293 .5538408 mgm_ua | -.2370448 .2684832 -0.883 0.378 -.7663124 .2922227 gram | -.1399112 .2646013 -0.529 0.598 -.6615262 .3817038 orion | .1010565 .2333961 0.433 0.665 -.359043 .5611559 univers | .1851035 .2232935 0.829 0.408 -.2550806 .6252875 warner | .0713976 .2253851 0.317 0.752 -.3729096 .5157047 paramnt | .2432472 .2211584 1.100 0.273 -.1927279 .6792223 year2 | .1010741 .1278779 0.790 0.430 -.1510149 .353163 year3 | .0394818 .1249549 0.316 0.752 -.2068449 .2858085 year4 | .1058498 .1335037 0.793 0.429 -.1573295 .369029 year5 | .0481757 .12983 0.371 0.711 -.2077614 .3041127 year6 | -.0433096 .1065914 -0.406 0.685 -.2534358 .1668167 year7 | .0290078 .1295116 0.224 0.823 -.2263017 .2843173 year8 | -.1093085 .1269862 -0.861 0.390 -.3596395 .1410226 year9 | -.1833831 .1579248 -1.161 0.247 -.4947043 .127938 openscr | .0011325 .0000722 15.675 0.000 .0009901 .001275 fourday | .1478581 .108419 1.364 0.174 -.065871 .3615872 month1 | .2522267 .1814311 1.390 0.166 -.1054329 .6098864 month2 | .3365843 .1286402 2.616 0.010 .0829927 .5901759 month3 | .1597644 .1197843 1.334 0.184 -.0763694 .3958982 month4 | -.0431137 .1238039 -0.348 0.728 -.2871715 .2009441 month5 | -.114495 .1323185 -0.865 0.388 -.3753377 .1463478 month6 | .2253042 .1617955 1.393 0.165 -.0936473 .5442556 month7 | .2083603 .1297316 1.606 0.110 -.0473828 .4641035 month8 | -.0562382 .1587427 -0.354 0.723 -.3691716 .2566952 month9 | -.1933755 .1893355 -1.021 0.308 -.5666172 .1798662 month10 | .0818477 .1231841 0.664 0.507 -.1609881 .3246835 month11 | .2944074 .1768128 1.665 0.097 -.054148 .6429628 _cons | 12.60021 .2870367 43.898 0.000 12.03437 13.16605 ------------------------------------------------------------------------------ . . 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, 210) = 0.96 Prob > F = 0.4650 . 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, 210) = 3.03 Prob > F = 0.0009 . 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, 210) = 2.15 Prob > F = 0.0270 . . ************ Now the regressions just for Dramas *************** . . *------------------------------- . * Regression (7): . * opening weekend box office . * omitting quality proxies . * clustering on opening weekend . * split sample of Dramas . *------------------------------- . . reg lwk1cpi dur ou uu oudur uudur disney fox sony mgm_ua gram orion univers w > arner paramnt year2-year9 openscr fourday month1-month11 if drama == 1, robus > t cluster(weekend) Regression with robust standard errors Number of obs = 198 F( 35, 168) = 22.69 Prob > F = 0.0000 R-squared = 0.7767 Number of clusters (weekend) = 169 Root MSE = .53396 ------------------------------------------------------------------------------ | Robust lwk1cpi | Coef. Std. Err. t P>|t| [95% Conf. Interval] ---------+-------------------------------------------------------------------- dur | -.2077513 .1803984 -1.152 0.251 -.5638911 .1483885 ou | -.2056722 .2330082 -0.883 0.379 -.6656735 .254329 uu | -.2148535 .2975592 -0.722 0.471 -.8022905 .3725835 oudur | .5146809 .2510271 2.050 0.042 .019107 1.010255 uudur | .5608158 .328377 1.708 0.090 -.0874613 1.209093 disney | .9758249 .2552927 3.822 0.000 .4718299 1.47982 fox | .5817082 .3059976 1.901 0.059 -.0223877 1.185804 sony | .8413333 .2481973 3.390 0.001 .3513458 1.331321 mgm_ua | .8650694 .2622015 3.299 0.001 .3474351 1.382704 gram | .9268186 .3364999 2.754 0.007 .2625055 1.591132 orion | .4922894 .3512558 1.402 0.163 -.2011547 1.185733 univers | 1.307722 .2642907 4.948 0.000 .7859632 1.829481 warner | .9475712 .2545834 3.722 0.000 .4449764 1.450166 paramnt | 1.012416 .2598108 3.897 0.000 .4995013 1.525331 year2 | .0708514 .1832846 0.387 0.700 -.2909863 .4326892 year3 | .2130447 .2252373 0.946 0.346 -.2316155 .6577049 year4 | .2195302 .1391543 1.578 0.117 -.0551863 .4942466 year5 | .2883289 .1725036 1.671 0.096 -.0522252 .628883 year6 | .1978747 .1466268 1.350 0.179 -.0915937 .4873432 year7 | .3153363 .1359481 2.320 0.022 .0469495 .5837231 year8 | .006265 .1512829 0.041 0.967 -.2923954 .3049254 year9 | -.1413191 .1880167 -0.752 0.453 -.5124988 .2298606 openscr | .0011716 .0000785 14.925 0.000 .0010166 .0013266 fourday | .2429668 .1570019 1.548 0.124 -.0669839 .5529176 month1 | .2057192 .2965902 0.694 0.489 -.3798048 .7912432 month2 | -.1613802 .2254878 -0.716 0.475 -.6065349 .2837745 month3 | -.0164038 .2261097 -0.073 0.942 -.4627862 .4299786 month4 | -.2351858 .2397628 -0.981 0.328 -.708522 .2381505 month5 | -.4680141 .2384335 -1.963 0.051 -.938726 .0026977 month6 | -.2878987 .2632177 -1.094 0.276 -.8075392 .2317418 month7 | .553377 .2701803 2.048 0.042 .0199911 1.086763 month8 | -.0838774 .2558796 -0.328 0.743 -.5890311 .4212762 month9 | -.2045551 .2424686 -0.844 0.400 -.6832331 .2741228 month10 | -.1392834 .2618524 -0.532 0.595 -.6562285 .3776616 month11 | -.052995 .264921 -0.200 0.842 -.5759981 .4700082 _cons | 12.68893 .3150914 40.271 0.000 12.06688 13.31098 ------------------------------------------------------------------------------ . . 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.56 Prob > F = 0.1406 . 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.59 Prob > F = 0.0046 . 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.52 Prob > F = 0.0005 . . *------------------------------- . * Regression (8): . * opening weekend box office . * including quality proxies . * clustering on opening weekend . * split sample of Dramas . *------------------------------- . . reg lwk1cpi dur ou uu oudur uudur maltin disney fox sony mgm_ua gram orion un > ivers warner paramnt year2-year9 openscr fourday month1-month11 if drama == 1 > , robust cluster(weekend) Regression with robust standard errors Number of obs = 198 F( 36, 168) = 22.81 Prob > F = 0.0000 R-squared = 0.7889 Number of clusters (weekend) = 169 Root MSE = .52077 ------------------------------------------------------------------------------ | Robust lwk1cpi | Coef. Std. Err. t P>|t| [95% Conf. Interval] ---------+-------------------------------------------------------------------- dur | -.2753721 .1792637 -1.536 0.126 -.6292718 .0785277 ou | -.2669218 .2213511 -1.206 0.230 -.7039098 .1700662 uu | -.4163988 .3224371 -1.291 0.198 -1.052949 .2201518 oudur | .5081742 .2423717 2.097 0.038 .0296876 .9866609 uudur | .6498793 .3428476 1.896 0.060 -.0269654 1.326724 maltin | .2483094 .0830064 2.991 0.003 .0844393 .4121795 disney | .889916 .2515261 3.538 0.001 .3933568 1.386475 fox | .4431372 .3010525 1.472 0.143 -.1511962 1.037471 sony | .7709118 .2445168 3.153 0.002 .2881903 1.253633 mgm_ua | .8395615 .268344 3.129 0.002 .3098007 1.369322 gram | .830799 .3508967 2.368 0.019 .1380638 1.523534 orion | .3857946 .31937 1.208 0.229 -.2447009 1.01629 univers | 1.189306 .2702001 4.402 0.000 .6558808 1.722731 warner | .8852931 .2493274 3.551 0.000 .3930748 1.377511 paramnt | .9309169 .2605568 3.573 0.000 .4165296 1.445304 year2 | .0595988 .1740283 0.342 0.732 -.2839653 .4031629 year3 | .19759 .1973509 1.001 0.318 -.1920173 .5871972 year4 | .1916567 .1330255 1.441 0.152 -.0709602 .4542736 year5 | .252584 .1668194 1.514 0.132 -.0767483 .5819163 year6 | .191637 .1398235 1.371 0.172 -.0844005 .4676745 year7 | .2640766 .1296245 2.037 0.043 .0081738 .5199794 year8 | .0127765 .1388677 0.092 0.927 -.2613741 .286927 year9 | -.1358965 .1691266 -0.804 0.423 -.4697838 .1979908 openscr | .0011679 .0000786 14.862 0.000 .0010128 .001323 fourday | .238078 .1514707 1.572 0.118 -.0609532 .5371092 month1 | .2665497 .2832418 0.941 0.348 -.2926221 .8257215 month2 | -.1805119 .2235764 -0.807 0.421 -.621893 .2608693 month3 | .0164083 .2277656 0.072 0.943 -.4332431 .4660598 month4 | -.1485435 .2452296 -0.606 0.546 -.6326721 .335585 month5 | -.442308 .2375914 -1.862 0.064 -.9113574 .0267415 month6 | -.314444 .2561333 -1.228 0.221 -.8200985 .1912105 month7 | .5905528 .2759645 2.140 0.034 .0457477 1.135358 month8 | -.0552342 .2467697 -0.224 0.823 -.5424032 .4319348 month9 | -.152424 .242189 -0.629 0.530 -.63055 .3257021 month10 | -.1268216 .250262 -0.507 0.613 -.6208852 .3672419 month11 | .0257521 .2640131 0.098 0.922 -.4954586 .5469628 _cons | 12.27655 .3822616 32.116 0.000 11.52189 13.0312 ------------------------------------------------------------------------------ . . 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.32 Prob > F = 0.2350 . 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) = 3.00 Prob > F = 0.0011 . 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.21 Prob > F = 0.0013 . . *-------------------------------------- . * Regression (9): . * opening weekend box office per screen . * including quality proxies . * clustering on opening weekend . * split sample of Dramas . *-------------------------------------- . . reg lwk1per dur ou uu oudur uudur disney fox sony mgm_ua gram orion univers w > arner paramnt maltin year2-year9 fourday month1-month11 if drama==1, robust c > luster(weekend) Regression with robust standard errors Number of obs = 198 F( 35, 168) = 3.37 Prob > F = 0.0000 R-squared = 0.3356 Number of clusters (weekend) = 169 Root MSE = .60728 ------------------------------------------------------------------------------ | Robust lwk1per | Coef. Std. Err. t P>|t| [95% Conf. Interval] ---------+-------------------------------------------------------------------- dur | -.2406554 .1790752 -1.344 0.181 -.594183 .1128721 ou | -.112436 .215606 -0.521 0.603 -.5380821 .3132101 uu | -.3265737 .3886685 -0.840 0.402 -1.093877 .4407298 oudur | .3204989 .241431 1.327 0.186 -.1561305 .7971283 uudur | .579539 .416239 1.392 0.166 -.2421938 1.401272 disney | .7129919 .2485277 2.869 0.005 .2223522 1.203632 fox | .2758288 .2914009 0.947 0.345 -.2994506 .8511081 sony | .6678558 .2430837 2.747 0.007 .1879635 1.147748 mgm_ua | .6271251 .2674949 2.344 0.020 .0990407 1.15521 gram | .5585222 .3684052 1.516 0.131 -.1687778 1.285822 orion | .4796283 .4622079 1.038 0.301 -.4328556 1.392112 univers | 1.055838 .3357604 3.145 0.002 .3929852 1.718691 warner | .7362701 .2380138 3.093 0.002 .2663867 1.206153 paramnt | .7606908 .2688536 2.829 0.005 .2299241 1.291458 maltin | .2954041 .1010029 2.925 0.004 .0960057 .4948024 year2 | .0080537 .2304209 0.035 0.972 -.4468398 .4629473 year3 | .086202 .1708224 0.505 0.614 -.2510331 .423437 year4 | .1373266 .1766383 0.777 0.438 -.2113902 .4860434 year5 | .2867554 .2267155 1.265 0.208 -.160823 .7343339 year6 | .2147381 .1816113 1.182 0.239 -.1437962 .5732724 year7 | .2317338 .1677824 1.381 0.169 -.0994997 .5629672 year8 | .0951664 .1679905 0.566 0.572 -.236478 .4268107 year9 | .0951794 .1783204 0.534 0.594 -.2568581 .4472169 fourday | .1977422 .1577207 1.254 0.212 -.1136276 .509112 month1 | .2366308 .2946965 0.803 0.423 -.3451547 .8184163 month2 | -.1245866 .2601856 -0.479 0.633 -.6382412 .3890679 month3 | .0181119 .2669342 0.068 0.946 -.5088655 .5450894 month4 | .0221581 .280447 0.079 0.937 -.5314961 .5758123 month5 | -.1975685 .2790892 -0.708 0.480 -.7485424 .3534053 month6 | -.1146944 .2892312 -0.397 0.692 -.6856903 .4563014 month7 | .7158496 .2805159 2.552 0.012 .1620592 1.26964 month8 | .057186 .281675 0.203 0.839 -.4988925 .6132645 month9 | -.0407524 .2878754 -0.142 0.888 -.6090717 .527567 month10 | .1820801 .2883654 0.631 0.529 -.3872065 .7513667 month11 | .2122181 .3139777 0.676 0.500 -.407632 .8320681 _cons | 6.661584 .3971713 16.773 0.000 5.877494 7.445673 ------------------------------------------------------------------------------ . . 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) = 0.48 Prob > F = 0.8697 . 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.62 Prob > F = 0.0042 . 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) = 2.09 Prob > F = 0.0330 . . *------------------------------- . * Regression (10): . * total movie box office . * including quality proxies . * clustering on opening weekend . * split sample of Dramas . *------------------------------- . . reg lgross dur ou uu oudur uudur disney fox sony mgm_ua gram orion univers wa > rner paramnt maltin year2-year9 openscr fourday month1-month11 if drama==1, r > obust cluster(weekend) Regression with robust standard errors Number of obs = 198 F( 36, 168) = 16.76 Prob > F = 0.0000 R-squared = 0.7162 Number of clusters (weekend) = 169 Root MSE = .73223 ------------------------------------------------------------------------------ | Robust lgross | Coef. Std. Err. t P>|t| [95% Conf. Interval] ---------+-------------------------------------------------------------------- dur | -.4726234 .266797 -1.771 0.078 -.9993302 .0540833 ou | -.3074723 .3064803 -1.003 0.317 -.9125212 .2975767 uu | -.4017402 .5332485 -0.753 0.452 -1.454471 .650991 oudur | .7003059 .3399757 2.060 0.041 .0291309 1.371481 uudur | .8499192 .5552045 1.531 0.128 -.2461573 1.945996 disney | 1.077871 .3466132 3.110 0.002 .3935927 1.76215 fox | .5370734 .4054935 1.324 0.187 -.2634458 1.337593 sony | .862968 .342545 2.519 0.013 .1867208 1.539215 mgm_ua | 1.016531 .3673716 2.767 0.006 .2912712 1.74179 gram | .7319798 .510003 1.435 0.153 -.2748606 1.73882 orion | .5588425 .423598 1.319 0.189 -.2774185 1.395103 univers | 1.410334 .3794456 3.717 0.000 .6612382 2.15943 warner | 1.200894 .3457532 3.473 0.001 .5183127 1.883474 paramnt | 1.152079 .3805474 3.027 0.003 .4008077 1.90335 maltin | .5227555 .1129347 4.629 0.000 .2998015 .7457094 year2 | -.09587 .2711122 -0.354 0.724 -.6310958 .4393558 year3 | .4539265 .2469792 1.838 0.068 -.0336561 .9415091 year4 | .1940605 .1958597 0.991 0.323 -.1926028 .5807238 year5 | .2633827 .2451839 1.074 0.284 -.2206557 .7474211 year6 | .1209847 .2343655 0.516 0.606 -.3416963 .5836657 year7 | .1407084 .1915496 0.735 0.464 -.2374459 .5188627 year8 | -.1438185 .2026848 -0.710 0.479 -.5439559 .2563189 year9 | -.3718742 .2268436 -1.639 0.103 -.8197055 .0759571 openscr | .0012344 .0001049 11.766 0.000 .0010273 .0014415 fourday | .1271785 .2133323 0.596 0.552 -.293979 .5483359 month1 | -.0923829 .3389793 -0.273 0.786 -.7615909 .576825 month2 | -.5286372 .2895126 -1.826 0.070 -1.100189 .0429142 month3 | -.304353 .2942953 -1.034 0.303 -.8853465 .2766404 month4 | -.3159756 .3174834 -0.995 0.321 -.9427466 .3107955 month5 | -.7324817 .3162941 -2.316 0.022 -1.356905 -.1080585 month6 | -.5886657 .3188542 -1.846 0.067 -1.218143 .0408115 month7 | .5670074 .348198 1.628 0.105 -.1204 1.254415 month8 | -.1393426 .315327 -0.442 0.659 -.7618566 .4831713 month9 | -.4565729 .3086485 -1.479 0.141 -1.065902 .1527564 month10 | -.289737 .3081117 -0.940 0.348 -.8980065 .3185324 month11 | -.2304791 .3323677 -0.693 0.489 -.8866345 .4256763 _cons | 13.0041 .5440321 23.903 0.000 11.93008 14.07812 ------------------------------------------------------------------------------ . . 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.88 Prob > F = 0.0657 . 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.41 Prob > F = 0.0084 . 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.27 Prob > F = 0.0011 . . end of do-file . exit, clear