高级微观经济学中的效用极大化与支出 
 
    
    
        
            |   | 
            等效用线 | 
              | 
              | 
              | 
         
        
            |   | 
            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) | 
         
    
 
 |