Regresi.xlsx

Hlm 34 (CONSOL) Pakai cara kedua (mmult)

Ca

T

R

x1=1/T

X2 = LN CA

1 0.923 1.15 0.87 1.05 0.75 0.55 0.65

373 395 365 400 405 388 410 380

1.508 2.936 1.293 3.242 4.566 1.899 2.78 1.255

0.002680965 0.002531646 0.002739726 0.0025 0.002469136 0.00257732 0.002439024 0.002631579 0.020569395

0 -0.0801260445 0.1397619424 -0.1392620673 0.0487901642 -0.2876820725 -0.5978370008 -0.4307829161 -1.3471379946

A B C

6.3305393837 0.0159666285 -1.0336933231

8 0.0205693955 -1.3471379946 0.0205693955 5.2966158E-05 -0.0033808539 -1.3471379946 -0.0033808539 0.6734719621

A B C

13.8117774761 -4998.5293595 0.9998628616

Re

Sc

Sh

14.7 16.4 20.6 34.5 44.8 65.6 73.9 80.7 90.6

1.8 1.9 2.1 3.5 3.7 4.1 4.3 4.8 5.5

K E n

SOAL NO. 7 (hlm 38) X1 = log re

36.2 1.1673173347 40.4 1.214843848 50.52 1.3138672204 94.82 1.5378190951 119.38 1.651278014 168.67 1.8169038394 189.19 1.8686444384 212.76 1.9068735347 247.35 1.9571281977 1159.29 14.4346755224

9 14.4346755224 4.6363714084 14.4346755224 23.9158181148 7.8800389596 4.6363714084 7.8800389596 2.6545690067

A

0.5264049461

X2 = log sc

Y = log sh

0.255272505 0.278753601 0.322219295 0.544068044 0.568201724 0.612783857 0.633468456 0.681241237 0.740362689 4.636371408

1.5587085705 1.6063813651 1.7034633419 1.976899951 2.0769315746 2.2270378449 2.2768981772 2.3278899816 2.3933119147 18.147522722

A B C

18.147522722 29.902877397 9.8150624889

B1

B

0.7889499084

B2

C

0.43603976

B3

Y = LN R

XI.X2

XI.Y

X2.Y

XI^2

X2^2

0.4107842696 1.0770481108 0.2569650998 1.1761904233 1.5186375481 0.6413274318 1.0224509277 0.2271355726 6.3305393837

0 -0.0002028507 0.0003829094 -0.0003481552 0.0001204695 -0.0007414486 -0.001458139 -0.0011336393 -0.0033808539

0.0011012983 0.0027267041 0.000704014 0.0029404761 0.0037497223 0.0016529058 0.0024937828 0.0005977252 0.0159666285

0 -0.0862996048 0.0359139415 -0.1637987099 0.0740945753 -0.1844984047 -0.611258996 -0.0978461243 -1.0336933231

7.1875741E-06 6.4092293E-06 7.5060987E-06 0.00000625 6.0966316E-06 6.6425763E-06 5.94884E-06 6.9252078E-06 5.2966158E-05

0 0.006420183 0.0195334005 0.0193939234 0.0023804801 0.0827609748 0.3574090795 0.1855739208 0.6734719621

X2.Y

X1.X2

X1^2

X2^2

996273.8774415 9532.1954885907 0.9998628616

X1.Y 1.8195075342 1.951502519 2.238124646 3.0401144937 3.4295914456 4.0463136109 4.2547131156 4.4389917978 4.6840182341 29.9028773969

3.3605080963

0.3978954415 0.44778459 0.5488887566 1.0755680902 1.1801161014 1.3646928397 1.4423431718 1.5858546516 1.771918846 9.8150624889

0.2979840203 1.36262976 0.3386420972 1.4758455751 0.4233533691 1.7262470728 0.8366782276 2.3648875692 0.9382590145 2.7267190795 1.113369342 3.3011395615 1.1837273064 3.4918320371 1.2990408863 3.6361666774 1.4489846961 3.8303507821 7.8800389596 23.9158181148

0.0651640519 0.07770357 0.1038252739 0.2960100369 0.3228531992 0.3755040551 0.4012822842 0.4640896235 0.548136912 2.6545690067

0.7889499084 0.43603976