我的处理是求出每一列指标的Max和Min值,然后按照(X-Xmin)/(Xmax-Xmin)计算出每一列对应的值。见下表,其中浅蓝色字是每列极值,红色字是归一化之后的结果。
我在计算时发现没有负值的数据归一和不归一的DEA计算结果不同,所有想请教问题出在什么地方。
(软件DEA Slover Pro 5.0, CCR模型 产出角度)。
谢谢!
| DMU | y1 | y2 | x1 | x2 | X3 |
| 年份1 | 1 | 466487 | 38822 | 2397 | 8100 | 368001.41 |
| 2 | 11631951.99 | 312506 | 1774 | 43639 | 8052106.92 |
| 3 | 10642114.08 | 463655 | 3659 | 141000 | 5219546.8 |
| 4 | 651919.21 | 3615.86 | 3900 | 10640 | 618719.97 |
| 5 | 1066716.57 | 140227.56 | 7600 | 2730 | 1294805.51 |
| 年份2 | 1 | 456171 | 35689 | 2372 | 8100 | 322293.97 |
| 2 | 8881454.18 | 580040 | 1639 | 41646 | 6134825.29 |
| 3 | 10349562.52 | 602747 | 3680 | 141000 | 4896010.68 |
| 4 | 629478.38 | -43192.15 | 3700 | 9420 | 695496.92 |
| 5 | 945444.92 | 134256.37 | 7341 | 2353 | 1165455.18 |
| 年份3 | 1 | 442556 | 32186 | 2452 | 8100 | 304267.16 |
| 2 | 8226595.46 | 442773 | 1485 | 30448 | 5893906.66 |
| 3 | 10086159.5 | 774489 | 3709 | 137000 | 4719353 |
| 4 | 662076.75 | 14564.05 | 4000 | 1576 | 698674.27 |
| 5 | 814713.38 | 108804.06 | 7082 | 2029 | 1037281.53 |
| | Max | 11631951.99 | 774489 | 7600 | 141000 | 8052106.92 |
| | Min | 442556 | -43192.15 | 1485 | 1576 | 304267.16 |
| | Max-Min | 11189395.99 | 817681.15 | 6115 | 139424 | 7747839.76 |
| 2016 | 1 | 0.002138721 | 0.10030089 | 0.149141 | 0.046793 | 0.00822607 |
| 2 | 1 | 0.43500838 | 0.047261 | 0.301691 | 1 |
| 3 | 0.91153786 | 0.61985916 | 0.355519 | 1 | 0.63440647 |
| 4 | 0.018710859 | 0.05724482 | 0.39493 | 0.06501 | 0.04058587 |
| 5 | 0.055781435 | 0.22431691 | 1 | 0.008277 | 0.12784704 |
| 2015 | 1 | 0.001216777 | 0.09646933 | 0.145053 | 0.046793 | 0.00232669 |
| 2 | 0.754187106 | 0.76219459 | 0.025184 | 0.287397 | 0.75253984 |
| 3 | 0.885392431 | 0.78996458 | 0.358953 | 1 | 0.59264823 |
| 4 | 0.016705315 | 0 | 0.362224 | 0.05626 | 0.05049533 |
| 5 | 0.044943348 | 0.21701432 | 0.957645 | 0.005573 | 0.11115202 |
| 2014 | 1 | 0 | 0.09218526 | 0.158136 | 0.046793 | 0 |
| 2 | 0.695662167 | 0.59432109 | 0 | 0.207081 | 0.7214449 |
| 3 | 0.861852017 | 1 | 0.363696 | 0.971311 | 0.56984734 |
| 4 | 0.019618642 | 0.07063413 | 0.411284 | 0 | 0.05090543 |
| 5 | 0.033259827 | 0.18588689 | 0.91529 | 0.003249 | 0.09460887
|