30 maret
DESCRIPTION
alaalatihannn excelllll land useTRANSCRIPT
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
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
317.4603-0.568
0.6381620.031348