全文预览已结束
下载本文档
版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
There are the main independent variables we research in this model. By testing this model, it can be concluded that which factors are significant for improving individual earnings, and know the relationships between them is positive correlation or negative correlation, or no linear correlation. Considering the validity of the model, the first step is to choose the more affect variables from the 22 variables. Referring to the research by others, the quality of male employee has far more influence on their income than other external factors from their wife or children ( ). So we select the following several variables: huseduc (years of schooling), husblck, husage, hushrs, hushisp, husexp, the independent variable is husearns.Some variables like the situation of economic development in 1991, external variables from wife and children, we are not able to quantify the size of influence, so we put them in the random fluctuations and fix them in heteroskedasticity test.Preliminary model: assumption: there is linear relationship between the dependent variable husearns and the independent variables huseduc, husage, hushrs, hushisp, husexp, husblck.Husearns=c+x1huseduc+x2husage+x3hushrs+x4hushisp+x5husexp+x6husblckUsing OLSDependent Variable: HUSEARNSMethod: Least SquaresDate: 01/01/11 Time: 16:01Sample: 1 5634Included observations: 5634VariableCoefficientStd. Errort-StatisticProb.C-464.433941.94402-11.072710.0000HUSAGE31.761252.16309114.683270.0000HUSEXP-31.509342.118723-14.871860.0000HUSBLCK-29.4199821.04346-1.3980580.1622HUSHISP23.9779420.873451.1487290.2507HUSHRS5.8247250.26662921.845790.0000HUSEDUC6.4272352.3895892.6896830.0072R-squared0.153373Mean dependent var453.5406Adjusted R-squared0.172492S.D. dependent var406.9878S.E. of regression370.2265Akaike info criterion14.66735Sum squared resid7.71E+08Schwarz criterion14.67559Log likelihood-41310.92F-statistic196.6973Durbin-Watson stat2.012364Prob(F-statistic)0.000000You can see from the table, R2=0.153373, which is not so significant. F-statistic=196.6973, which is so significant. When t0.05/2(n-k) =t0.025 (5634-6) =1.96, so the t-statistic of husblck and hushisp is not significant. And it is surprise that husexp have a negative correlation with the husearns. In addition, some variables have a close bond with each other (such as:husexp=huseduc-husage-6), so multicollinearity problem may exist.HUSAGEHUSBLCKHUSEARNSHUSEDUCHUSEXPHUSHISPHUSHRSHUSAGE1.000000-0.004729-0.079956-0.0506200.967514-0.058621-0.255914HUSBLCK-0.0047291.000000-0.056643-0.0843280.016832-0.048838-0.067556HUSEARNS-0.079956-0.0566431.0000000.310730-0.154993-0.0729460.333011HUSEDUC-0.050620-0.0843280.3107301.000000-0.301469-0.2563620.207321HUSEXP0.9675140.016832-0.154993-0.3014691.0000000.008931-0.296803HUSHISP-0.058621-0.048838-0.072946-0.2563620.0089311.000000-0.063873HUSHRS-0.255914-0.0675560.3330110.207321-0.296803-0.0638731.000000Table1Firstly, we can use the correlation matrix to see the coefficient. It can be seen from Table1, husexp and husage have a high coefficient. Now using stepwise regression method, to test and solve the problem of multiple linear. Analysis the independent variables and dependent variables respectively, you can get the table.1.huseduc2.husage 3.husexp4.hublck5.hushrs6.hushispcoefficient42.47738-2.8981-5.3635-97.473796.919034-119.3914t-statis24.53373-6.019722-11.77401-4.25771626.50414-5.488980R20.0965530.0063930.0.0240230.0032080.1108960.005321Adjust R20.0963930.0062170.0238500.0030310.1107380.005145R2 more to less: hushrs, huseduc, husexp, husage, hushisp, houseblckSo hushrs should be added in this model, then add other variables.variablest-statisticsR2hushrs huseduc22.64071 20.373180.171934hushrs husexp25.73064 -4.6889090.114354hushrs husage25.73064 0.445290.110926hushrs hushisp26.22403 -4.1271210.113578So huseduc should be added in this model, which improve the R2, t-value of this model.t-statisticsR2HushrsHuseducHusexp22.0127919.790160.3966970.171957HushrsHuseduchusage22.0127920.370570.3966970.171957HushrsHuseduchushisp22.6480319.937380.8295390.172035HushrsHuseduchusblck22.5427520.22391-1.3580460.172205From the above data it can be clearly seen, put any other variables, there is no help to improve their t- statistic of this model, so the model only retain two explanatory variables, huseduc and hushrs.The model heteroscedastic testFirstly, we can get the resid graphic. It can be seen from the graphic, the scatter appeared complex changes like deviation band, along with the increase of X. So the heteroscedastic may exist. However, in order to make sure whether it exist or not, we must do more test. Base on the big sample sizes, we can use white test to test hereroscedastic.White Heteroskedasticity Test:F-statistic193.7325Probability0.000000Obs*R-squared681.7618Probability0.000000Test Equation:Dependent Variable: RESID2Method: Least SquaresDate: 01/01/11 Time: 22:42Sample: 1 5634Included observations: 5634VariableCoefficientStd. Errort-StatisticProb.C123837.834104.023.6311800.0003HUSEDUC-30202.985428.793-5.5634800.0000HUSEDUC22114.943215.10419.8321830.0000HUSHRS-2237.899423.1717-5.2883940.0000HUSHRS260.942685.90861910.314200.0000R-squared0.121008Mean dependent var137135.8Adjusted R-squared0.120384S.D. dependent var262476.0S.E. of regression246170.6Akaike info criterion27.66632Sum squared resid3.41E+14Schwarz criterion27.67221Log likelihood-77931.04F-statistic193.7325Durbin-Watson stat2.045266Prob(F-statistic)0.000000From the table, nR2=681.7618, based on the assumption of white test, we can find the x2 in the distribution table, x2 0.
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 高中语文必修上册同步练习 含答案-第7单元 荷塘月色
- 2025年财务岗位竞聘试题及答案
- 2025年渠道考试题及答案
- 2025年电大健康管理试题及答案
- 2025年大学一年级计算机上学期编程练习
- 2025年江苏省公务员面试真题解析卷
- 分析执行差异制定改进措施办法
- 倡导绿色生活方式保护认知健康制度
- 2025企业市场营销策划(咨询)委托合同书模板
- 2025年下半年唐山市路南区招考人事代理教师易考易错模拟试题(共500题)试卷后附参考答案
- 平面设计培训考试题及答案
- 2025浙江温州医科大学附属第二医院医务部工作人员招聘1人笔试考试参考题库及答案解析
- 2025新华保险金融科技中心社会招聘笔试考试参考试题及答案解析
- 2025至2030赖氨酸行业发展趋势分析与未来投资战略咨询研究报告
- 2025海南省海口市城建集团招聘100人笔试历年参考题库附带答案详解
- 天然气突发事件应急预案
- 社会主义核心价值观法治学法知法守法教案x
- 2025年山东综评专科题目及答案
- 运输公司安全管理制度范本
- 神经内科科普讲解演讲
- 【课件】2025年消防月主题培训全民消防生命至上安全用火用电
评论
0/150
提交评论