無約束重力模式

1、無約束重力模式根據(jù)無約束重力模型公式：???ijjitUTkjiX??)(兩邊取對(duì)數(shù)得Ln(Tij)=lnkαlnGiβlnAjγlntijTij─交通區(qū)i到交通區(qū)j的出行分布量：Gi─交通區(qū)i的出行產(chǎn)生總量：Aj─交通區(qū)j的出行吸引總量：K，α，β，γ─模型參數(shù)；公式轉(zhuǎn)換為:Y=Kαx1βx2γx3參數(shù)的確定是通過擬合現(xiàn)狀OD調(diào)查資料，用最小二乘法確定。現(xiàn)有一規(guī)劃區(qū)域，共劃分為5個(gè)交通區(qū)，經(jīng)調(diào)查其現(xiàn)狀OD分布見表1，各交通區(qū)間的出行時(shí)

2、間見表2，通過對(duì)各交通區(qū)的交通生成進(jìn)行預(yù)測(cè)，得到各交通區(qū)未來交通產(chǎn)生、吸引量見表3，分析計(jì)算得到未來各交通區(qū)間的交通出行時(shí)間見表4。表A1（現(xiàn)狀OD分布）交通區(qū)12345180060020030040022002100500200150545024090010050411010024070050解：選用出行時(shí)間的函數(shù)形式，將無約束重力模型變?yōu)椋篖n(Tij)=lnkαlnGiβlnAjγlntij格式LN(number)：number是

3、用于計(jì)算其自然對(duì)數(shù)的正實(shí)數(shù)。Ln是exp函數(shù)的反函數(shù)計(jì)算步驟：打開數(shù)據(jù)文件，在定下的單元格中輸入公式Ln(number)按下number之后選擇要計(jì)算的數(shù)字，然后按下Entre鍵后公式將返回計(jì)算結(jié)果如下表：ijTGATlnTlnGlnAlnt118005200440056.6846128.5564148.389361.6094381260052004100106.396938.5564148.3187422.30258513200520

4、03400125.2983178.5564148.1315312.4849071430052002700155.7037828.5564147.9010072.708051540052002200205.9914658.5564147.6962132.9957322120045004400105.2983178.4118338.389362.3025852221004500410047.6496938.4118338.3187421.3

5、86294235004500340086.2146088.4118338.1315312.0794422420045002700205.2983178.4118337.9010072.9957322515045002200205.0106358.4118337.6962132.9957323145033004400106.1092488.1016788.389362.3025853224033004100105.4806398.1016

6、788.3187422.302585339003300340076.8023958.1016788.1315311.945913410033002700104.605178.1016787.9010072.302585355033002200303.9120238.1016787.6962133.4011974111021004400154.700487.6496938.389362.708054210021004100204.6051

7、77.6496938.3187422.9957324324021003400105.4806397.6496938.1315312.302585447002100270086.551087.6496937.9010072.079442455021002200203.9120237.6496937.6962132.995732519023004400304.499817.7406648.389363.4011975250230041002