| 所在主题: | |
| 文件名: airline.xls | |
| 资料下载链接地址: https://bbs.pinggu.org/a-1333718.html | |
| 附件大小: | |
|
小弟初学计量。不是很懂。刚做的作业有点问题。 希望高手给解决下。可给稿酬 数据在附件中Q=出售机票量 P=航空公司票价 P0=竞争对手的票价 Y=收入 假设模型为 Q= β1P + β2P0 + β3Y + e.
a) 给出结果并加以说明
测试H0: β3 = 2 against H1: β3 1 2.
算出各个量的弹性。1价格2corss价格3收入
+----------------------------------------------------+ | Ordinary leastsquares regression | | Model was estimated May 16, 2013 at 08:53:01PM | | LHS=Q Mean = 87.24375 | | Standard deviation = 27.93562 | | WTS=none Number of observs. = 16 | | Model sizeParameters = 3 | | Degrees of freedom = 13 | | Residuals Sumof squares = 2622.326 | | Standard error of e= 14.20273 | | Fit R-squared = .7759840 | | Adjusted R-squared = .7415200 | | Model testF[2, 13] (prob) =22.52 (.0001) | | Diagnostic Loglikelihood =-63.49684 | | Restricted(b=0) =-75.46515 | | Chi-sq [2](prob) = 23.94 (.0000) | | Info criter. LogAmemiya Prd. Crt. = 5.478718 | | Akaike Info. Criter. =5.474228 | | Autocorrel Durbin-WatsonStat.= 1.0998728 | | Rho= cor[e,e(-1)] = .4500636 | | Not using OLS or no constant. Rsqd & F may be <0. | +----------------------------------------------------+ +--------+--------------+----------------+--------+--------+----------+ |Variable| Coefficient| Standard Error |t-ratio |P[|T|>t]| Mean of X| +--------+--------------+----------------+--------+--------+----------+ P |-2.11839990 .32605643 -6.497.0000 239.687500 P0 | 1.10188791 .21812294 5.052.0002 243.125000 Y | 3.19929914 .71632554 4.466.0006 102.237500
So,β1:每增加一个单位的P,Q将会减少2.1个单位 β2:每增加一个单位的PO,Q将会增加1.1个单位 β3: 每增加一个单位的Y,Q将会减少3.2个单位 b)不会 c)不会
+------------------------------------+ |Listed Calculator Results | +------------------------------------+ TSTAT1= 1.665693 在B等于0.05时。临界值为2.160和-2.160数据结果为 1.666 并且在飞拒绝区域内。 所以假设被接受在5%B等于0.1和0.01时。 临界值分别为1.771和-1.7713.012和-3.012 所以在b等于0.1和0.01时。假设也被接受 e)命令界面输入 --> CREA;qstar=q-rho*q[-1]$ --> CREA;pstar=p-rho*p[-1]$ -->CREA;p0star=p0-rho*p0[-1]$ --> CREA;ystar=y-rho*y[-1]$ --> SAMPLE;1-1$-->CREA;qstar=q*sqr(1-rho^2)$ -->CREA;pstar=p*sqr(1-rho^2)$ -->CREA;p0star=p0*sqr(1-rho^2)$ --> CREA;ystar=y*sqr(1-rho^2)$ 重置数据,启用新数据
+----------------------------------------------------+ | Ordinary leastsquares regression | | Model was estimated May 16, 2013 at 08:39:04PM | | LHS=QSTAR Mean = 50.41993 | | Standard deviation = 22.44172 | | WTS=none Number of observs. = 16 | | Model sizeParameters = 3 | | Degreesof freedom = 13 | | Residuals Sumof squares = 2067.257 | | Standard error of e= 12.61030 | | Fit R-squared = .7263530 | | Adjusted R-squared = .6842534 | | Model testF[2, 13] (prob) =17.25 (.0002)| | Diagnostic Loglikelihood =-61.59413 | | Restricted(b=0) =-71.96146 | | Chi-sq [2](prob) = 20.73 (.0000) | | Info criter. LogAmemiya Prd. Crt. = 5.240879 | | Akaike Info. Criter. =5.236389 | | AutocorrelDurbin-Watson Stat.=1.3385152 | | Rho= cor[e,e(-1)] = .3307424 | | Not using OLS or no constant. Rsqd & F may be <0.| +----------------------------------------------------+ +--------+--------------+----------------+--------+--------+----------+ Variable| Coefficient| Standard Error |t-ratio |P[|T|>t]| Mean of X| +--------+--------------+----------------+--------+--------+----------+ PSTAR |-1.88031580 .33750451 -5.571.0001 136.751256 P0STAR| 1.12732312 .24288748 4.641.0005 138.782307 YSTAR | 2.57014923 .78685350 3.266.0061 58.5946562
+------------------------------------+ | Listed Calculator Results | +------------------------------------+
+------------------------------------+ | Listed Calculator Results | +------------------------------------+
+------------------------------------+ | Listed Calculator Results | +------------------------------------+
|
|
熟悉论坛请点击新手指南
|
|
| 下载说明 | |
|
1、论坛支持迅雷和网际快车等p2p多线程软件下载,请在上面选择下载通道单击右健下载即可。 2、论坛会定期自动批量更新下载地址,所以请不要浪费时间盗链论坛资源,盗链地址会很快失效。 3、本站为非盈利性质的学术交流网站,鼓励和保护原创作品,拒绝未经版权人许可的上传行为。本站如接到版权人发出的合格侵权通知,将积极的采取必要措施;同时,本站也将在技术手段和能力范围内,履行版权保护的注意义务。 (如有侵权,欢迎举报) |
|
京ICP备16021002号-2 京B2-20170662号
京公网安备 11010802022788号
论坛法律顾问:王进律师
知识产权保护声明
免责及隐私声明