求帮助 计量经济学问题 用excel 解答

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

新建 Microsoft Office Excel 工作表.zip (7.49 KB) 本附件包括：

• 新建 Microsoft Office Excel 工作表.xlsx

2012-1-18 21:21:50 上传

大家好，新人初来乍到，有个问题想请教一下。
求 年龄条件下的LIFESAT 的方差，使用 VAR(G2:G1661,"0",B2:B1661) 不知道是不是对。
还有我在做一个计量经济学的作业，有一道题是这样的：
Calculate the sum of squared residuals for the estimated multiple regression model in Part (C).Choose some other estimator or make up any other set of estimates for your coefficients (i.e. change ̂ ̂ ̂ ̂ ̂ ̂ and ̂ ). Re-calculate the new sum of squared residuals based on your new coefficients.What can you conclude about the original sum of squared residuals and the new sum of squared residuals?
我实在是没有理解，不知道哪位能帮忙解答一下。

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：用excel 经济学问题 计量经济学 EXCEL xcel excel 收藏 multiple original 经济学 计量经济学模型 计量经济学课程 计量经济学课件 计量经济学数据 计量经济学课后答案 金融计量经济学 计量经济学案例

第一个没看懂条件好像是VARA(IF……）语句，第二个应该是求误差平方和

For second question, you are asked to calculate the sum of squares of difference of exact value and corresponding estimated value(i.e. sum of (Xi-bar Xi)^2, for i = 1,2,...,n.
then you can choose to add more independent variables into your model and estimate the new coefficients and calculate the the sum of squares of difference of exact value and corresponding estimated value(same as above).
Then, it is expected that some coefficient do not change which means the additional variable does not have any effect of other independent variables on dependent variable.