高级微观经济学中的效用极大化与支出
|
等效用线 |
|
|
|
|
r / u0 |
0.7 |
3 |
|
|
x1 / x2 |
2.3 |
0.238 |
|
|
预算约束线 |
|
|
|
|
p1 / p2 |
2.6 |
3 |
|
|
w |
|
8.251 |
|
|
与横轴交点坐标 |
3.174 |
0 |
|
|
与纵轴交点坐标 |
0 |
2.75 |
|
|
最优解 |
|
|
|
|
r / p1r+p2r |
-2.333 |
0.185 |
|
|
p1r-1 / p2r-1 |
0.041 |
0.026 |
|
|
x*1 / x*2 |
1.849 |
1.148 |
|
|
umax |
|
4 |
|
|
|
|
|
|
|
0.238 |
4 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
|
|
0 |
4 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
|
|
0.1 |
3.575 |
0.728 |
1.659 |
2.612 |
3.575 |
4.545 |
5.518 |
6.495 |
7.473 |
8.454 |
|
|
0.2 |
3.317 |
0.571 |
1.455 |
2.378 |
3.317 |
4.267 |
5.223 |
6.185 |
7.15 |
8.118 |
|
|
0.3 |
3.101 |
0.447 |
1.288 |
2.183 |
3.101 |
4.034 |
4.976 |
5.924 |
6.878 |
7.835 |
|
|
0.4 |
2.911 |
0.344 |
1.143 |
2.012 |
2.911 |
3.827 |
4.755 |
5.691 |
6.634 |
7.582 |
|
|
0.5 |
2.737 |
0.255 |
1.013 |
1.857 |
2.737 |
3.638 |
4.553 |
5.478 |
6.411 |
7.349 |
|
|
0.6 |
2.577 |
0.18 |
0.895 |
1.714 |
2.577 |
3.463 |
4.366 |
5.28 |
6.203 |
7.133 |
|
|
0.7 |
2.427 |
0.116 |
0.787 |
1.582 |
2.427 |
3.299 |
4.19 |
5.094 |
6.007 |
6.928 |
|
|
0.8 |
2.286 |
0.063 |
0.687 |
1.458 |
2.286 |
3.144 |
4.023 |
4.917 |
5.821 |
6.734 |
|
|
0.9 |
2.152 |
0.023 |
0.595 |
1.342 |
2.152 |
2.997 |
3.865 |
4.748 |
5.644 |
6.549 |
|
|
1 |
2.026 |
2E-23 |
0.51 |
1.233 |
2.026 |
2.857 |
3.713 |
4.587 |
5.474 |
6.371 |
|
|
1.1 |
1.905 |
#NUM! |
0.432 |
1.129 |
1.905 |
2.723 |
3.568 |
4.432 |
5.311 |
6.2 |
|
|
1.2 |
1.79 |
#NUM! |
0.359 |
1.031 |
1.79 |
2.594 |
3.428 |
4.283 |
5.153 |
6.035 |
|
|
1.3 |
1.679 |
#NUM! |
0.292 |
0.938 |
1.679 |
2.471 |
3.294 |
4.139 |
5.001 |
5.875 |
|
|
1.4 |
1.574 |
#NUM! |
0.231 |
0.849 |
1.574 |
2.352 |
3.164 |
4 |
4.853 |
5.72 |
|
|
1.5 |
1.472 |
#NUM! |
0.176 |
0.766 |
1.472 |
2.237 |
3.038 |
3.865 |
4.71 |
5.57 |
|
|
1.6 |
1.375 |
#NUM! |
0.126 |
0.686 |
1.375 |
2.126 |
2.917 |
3.734 |
4.571 |
5.424 |
|
|
1.7 |
1.281 |
#NUM! |
0.083 |
0.61 |
1.281 |
2.019 |
2.799 |
3.607 |
4.436 |
5.281 |
|
|
1.8 |
1.191 |
#NUM! |
0.046 |
0.539 |
1.191 |
1.916 |
2.684 |
3.483 |
4.305 |
5.143 |
|
|
1.9 |
1.104 |
#NUM! |
0.017 |
0.471 |
1.104 |
1.815 |
2.573 |
3.363 |
4.176 |
5.007 |
|
|
2 |
1.021 |
#NUM! |
#NUM! |
0.407 |
1.021 |
1.718 |
2.465 |
3.246 |
4.051 |
4.875 |
|
|
2.1 |
0.941 |
#NUM! |
#NUM! |
0.347 |
0.941 |
1.624 |
2.36 |
3.132 |
3.929 |
4.746 |
|
|
2.2 |
0.864 |
#NUM! |
#NUM! |
0.291 |
0.864 |
1.533 |
2.258 |
3.02 |
3.81 |
4.62 |
|
|
2.3 |
0.79 |
#NUM! |
#NUM! |
0.238 |
0.79 |
1.445 |
2.159 |
2.912 |
3.693 |
4.496 |
|
|
2.4 |
0.718 |
#NUM! |
#NUM! |
0.189 |
0.718 |
1.359 |
2.062 |
2.806 |
3.579 |
4.375 |
|
|
2.5 |
0.65 |
#NUM! |
#NUM! |
0.145 |
0.65 |
1.276 |
1.968 |
2.702 |
3.468 |
4.257 |
|
|
2.6 |
0.585 |
#NUM! |
#NUM! |
0.104 |
0.585 |
1.196 |
1.876 |
2.601 |
3.359 |
4.14 |
|
|
2.7 |
0.522 |
#NUM! |
#NUM! |
0.069 |
0.522 |
1.118 |
1.786 |
2.502 |
3.252 |
4.027 |
|
|
2.8 |
0.463 |
#NUM! |
#NUM! |
0.038 |
0.463 |
1.042 |
1.699 |
2.405 |
3.147 |
3.915 |
|
|
2.9 |
0.406 |
#NUM! |
#NUM! |
0.014 |
0.406 |
0.969 |
1.614 |
2.311 |
3.045 |
3.805 |
|
|
3 |
0.352 |
#NUM! |
#NUM! |
#NUM! |
0.352 |
0.898 |
1.531 |
2.219 |
2.944 |
3.698 |
|
|
3.1 |
0.301 |
#NUM! |
#NUM! |
#NUM! |
0.301 |
0.83 |
1.451 |
2.128 |
2.846 |
3.592 |
|
|
3.2 |
0.253 |
#NUM! |
#NUM! |
#NUM! |
0.253 |
0.763 |
1.372 |
2.04 |
2.749 |
3.489 |
|
|
3.3 |
0.207 |
#NUM! |
#NUM! |
#NUM! |
0.207 |
0.699 |
1.295 |
1.954 |
2.655 |
3.387 |
|
|
3.4 |
0.165 |
#NUM! |
#NUM! |
#NUM! |
0.165 |
0.638 |
1.221 |
1.869 |
2.562 |
3.287 |
|
|
3.5 |
0.127 |
#NUM! |
#NUM! |
#NUM! |
0.127 |
0.578 |
1.148 |
1.786 |
2.471 |
3.189 |
|
|
3.6 |
0.092 |
#NUM! |
#NUM! |
#NUM! |
0.092 |
0.521 |
1.078 |
1.706 |
2.382 |
3.093 |
|
|
3.7 |
0.06 |
#NUM! |
#NUM! |
#NUM! |
0.06 |
0.466 |
1.009 |
1.627 |
2.294 |
2.998 |
|
|
3.8 |
0.034 |
#NUM! |
#NUM! |
#NUM! |
0.034 |
0.414 |
0.942 |
1.549 |
2.208 |
2.905 |
|
|
3.9 |
0.012 |
#NUM! |
#NUM! |
#NUM! |
0.012 |
0.364 |
0.877 |
1.474 |
2.124 |
2.814 |
|
|
4 |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
0.316 |
0.814 |
1.4 |
2.042 |
2.724 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
in E4: |
=(E3^D3-D4^D3)^(1/D3) |
in D8: |
=E7/D6 |
in E9: |
=E7/E6 |
in D11: |
=D3/(D3-1) |
in E11: |
=D6^D11+E6^D11 |
in D12: |
=D6^($D$11-1) |
in D13: |
=$E$7*D12/$E$11 |
in E14: |
=(D13^D3+E13^D3)^(1/D3) |
in E21: |
=COUNT(J3:J48) |
YY |
=OFFSET(效用最大模型!$J$3,0,0,效用最大模型!$E$21,1) |
|