1NOKecamatanJumlah Bangkitan Perjalanan (Ribu smp/tahun)Jumlah Penduduk (Ribu)Jumlah Kepemilikan KendaraanJumlah bangkitan perjalanan merupakan variabel terikat (Y) sedangkan jumlah penduduk dan jumlah kepimilikan kendaraan merupakan variabel bebas (X1 dan X2).1A2958001952B3883843923C2082862054D2123042365E8003702476F4856014457G3705222898H2173888009I40837536110J189319314

2ZonaPerjalanan (Yi)Penduduk (Xi)(Xi-X)(Yi-Y)(Xi-X)2(Yi-Y)2(Xi-X)(Yi-Y)A295800365.1-62.2133298.013868.84-22709.22B388384-50.930.82590.81948.64-1567.72C208286-148.9-149.222171.2122260.6422215.88D212304-130.9-145.217134.8121083.0419006.68E800370-64.9442.84212.01196071.84-28737.72F485601166.1127.827589.2116332.8421227.58G37052287.112.87586.41163.841114.88H217388-46.9-140.22199.6119656.046575.38I408375-59.950.83588.012580.64-3042.92J189319-115.9-168.213432.8128291.2419494.3835724349233802.9311257.633577.2

SUMMARY OUTPUTRegression StatisticsY=357.2Multiple R0.1244685266X=434.9R Square0.0154924141Adjusted R Square-0.1075710341Trip= 0.1436X1+294.743Standard Error195.7151847608Observations10ANOVAdfSSMSFSignificance FRegression14822.13163241344822.13163241340.12588964740.7319042283Residual8306435.46836758738304.4335459483Total9311257.6

CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%Intercept294.7425870252186.59402885831.57959281350.1528543522-135.5440151265725.029189177-135.5440151265725.029189177X Variable 10.14361327430.40476185290.35480931130.7319042283-0.78976923221.0769957808-0.78976923221.0769957808

3ZonaPerjalanan (Yi)Kendaraan (Xi)(Xi-X)(Yi-Y)(Xi-X)2(Yi-Y)2(Xi-X)(Yi-Y)A295195-153.4-62.223531.563868.849541.48B38839243.630.81900.96948.641342.88C208205-143.4-149.220563.5622260.6421395.28D212236-112.4-145.212633.7621083.0416320.48E800247-101.4442.810281.96196071.84-44899.92F48544596.6127.89331.5616332.8412345.48G370289-59.412.83528.36163.84-760.32H217800451.6-140.2203942.5619656.04-63314.32I40836112.650.8158.762580.64640.08J189314-34.4-168.21183.3628291.245786.0835723484287056.4311257.6-41602.8SUMMARY OUTPUT

Regression StatisticsY=357.2Multiple R0.1391806825X=348.4R Square0.0193712624Adjusted R Square-0.1032073298Trip= -0.1449X2+407.693Standard Error195.3292564375Observations10ANOVAdfSSMSFSignificance FRegression16029.45263662466029.45263662460.15803136610.7013717561Residual8305228.14736337538153.5184204219Total9311257.6

CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%Intercept407.6932672464141.23975462822.88653338660.020306884481.9938090185733.392725474481.9938090185733.3927254744X Variable 1-0.14492901050.3645723098-0.39753159130.7013717561-0.98563426450.6957762436-0.98563426450.6957762436

4ZonaPerjalanan (Y)Penduduk (X1)Kendaraan (X2)X1YX2YX1X2(X1)2(X2)2Y2A295800195236000575251560006400003802587025B388384392148992152096150528147456153664150544C208286205594884264058630817964202543264D212304236644485003271744924165569644944E8003702472960001976009139013690061009640000F485601445291485215825267445361201198025235225G37052228919314010693015085827248483521136900H2173888008419617360031040015054464000047089I408375361153000147288135375140625130321166464J18931931460291593461001661017619859635721357243493484158704012028821492536212518315008821587176SUMMARY OUTPUTRegression StatisticsMultiple R0.1791062784Trip= 0.1306X1-0.1346X2+347.319R Square0.032079059Adjusted R Square-0.2444697813Standard Error207.4583431854Observations10ANOVAdfSSMSFSignificance FRegression29984.85089941264992.42544970630.11599780680.8921535354Residual7301272.74910058743038.9641572268Total9311257.6

CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%Intercept347.3189390264249.32946694161.39301199850.2062542509-242.2515651403936.8894431931-242.2515651403936.8894431931X Variable 10.13056814510.43069817370.3031546290.7705832823-0.88787120161.1490074918-0.88787120161.1490074918X Variable 2-0.13462406810.3886998384-0.34634454340.7392609663-1.05375313250.7845049964-1.05375313250.7845049964

Sheet5Zona JTahun01234Kendaraan314322.792331.830341.121350.673Penduduk (ribu)319324.997331.107337.332343.674Trip= 0.1306X1-0.1346X2+347.319Trip (4tahun)= 0.1306(343.674)-0.1346(350.673)+347.319=345.0022386Jadi peningkatan perjalanan 4 tahun yang akan datang apabila jumlah penduduk pada zona tersebut meningkat sebesar 1,88 % per tahunnya dan pertumbuhan kepemilikan kendaraan meningkat tetap sebesar 2,8 % adalah 345.0022 ribu smp/thn.