30 maret

3
lokasi Jumlah ru B Waktu per b 1 100 150 60 40 2 300 280 25 18 3 50 80 110 100 4 200 50 70 40 60 0.666667 51.72414 48.27586 150 38.46154 61.53846

Upload: muchammad-zaenal-muttaqin

Post on 17-Jan-2016

213 views

Category:

Documents


0 download

DESCRIPTION

alaalatihannn excelllll land use

TRANSCRIPT

Page 1: 30 maret

lokasi Jumlah rumB Waktu perjb1 100 150 60 402 300 280 25 183 50 80 110 1004 200 50 70

40 60 0.66666751.72414 48.27586 15038.46154 61.53846

Page 2: 30 maret

LOKASI % RUMAH TIPE 36 (X) % RUMAH TIPE 45 (Y) HARGA X HARGA Y

1 40 60 60 402 51.7241379310345 48.2758620689655 25 183 38.4615384615385 61.5384615384615 110 1004 65% 35% 100 ?

Xi=(HY - HX) Yi=Ln {(1-P)/P} Xi.Yi-20 0.405465108108164 -8.109302 400

-7 -0.0689928714869516 0.48295 49-10 0.470003629245735 -4.700036 100

å -37 0.806475865866948 -12.32639 549Rata -12.3333333333333 0.268825288622316

B -0.0256818634012909A -0.0479176933269379 y-BX

Yi = A + BxiYi -0.619039208406224A -0.0479176933269379B -0.0256818634012909

Maka Xi 22.2383207228872Xi=HY-HXHY=Xi+HX 122.238320722887

Xi2

Page 3: 30 maret

317.4603-0.568

0.6381620.031348