Matriks (2).xlsx

d

r

x = 1/d^2

0.1 0.2 0.3 0.5 0.8 1.5

6 142.118055556

CARA 3 A B

5.78 2.26 1.6 1.27 1.53 1.1

y=r

100 25 11.1111111111 4 1.5625 0.4444444444 142.1180555556

5.78 2.26 1.6 1.27 1.53 1.1 13.54

142.1180555556 A 10767.0957272377 B

1.1700213456 0.0458764504

13.54 660.2372916667

6 142.1180555556 142.1180555556 10767.0957272377

CARA 2

6 142.1180555556 142.1180555556 10767.0957272377

A B

1.1700213456 0.0458764504 6 142.1180555556 142.1180555556 10767.0957272377

SOAL KE-2

x

y 4 6 8 15.3 10 12

X = x^2*y 4.89 5.49 6.62 9 11.4 16.1

Y=y 78.24 197.64 423.68 2106.81 1140 2318.4 6264.77

XY 4.89 5.49 6.62 9 11.4 16.1 53.5

382.5936 1085.0436 2804.7616 18961.29 12996 37326.24 73555.9288

6 6264.77

6264.77 A 11337914.7457 B

53.5 73555.9288

cara 2 5.0648619456 0.0036890147

#VALUE! #VALUE!

cara 3 5.0648619456 0.0036890147

xy

x^2

578 10000 56.5 625 17.7777777778 123.456790123 5.08 16 2.390625 2.44140625 0.4888888889 0.1975308642 660.2372916667 10767.0957272

DET = DET A= DET B= A= B=

X^2 6121.4976 39061.5696 179504.7424 4438648.3761 1299600 5374978.56 11337914.7457

44405.0326485

5.0648619456 0.0036890147

A

6 6264.77 6264.77 11337914.7457

DET A

6 6264.77 6264.77 11337915

DET B

6 6264.77 6264.77 11337915

DET