Statistika- Latihan Mencari B0.xlsx

X 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 10.5 b1= b0*=

Y 0.032974 0.054366 0.089634 0.147781 0.24365 0.401711 0.662309 1.091963 1.800343 2.968263 4.893839 8.068576 13.30283 21.93266 36.16085 59.61916 98.29538 162.0617 267.1945 440.5293

y* -3.41202 -2.91202 -2.41202 -1.91202 -1.41202 -0.91202 -0.41202 0.087977 0.587977 1.087977 1.587977 2.087977 2.587977 3.087977 3.587977 4.087977 4.587977 5.087977 5.587977 6.087977 1.337977

0.5 -3.91202 b0=

(X-XX ) -9.5 -8.5 -7.5 -6.5 -5.5 -4.5 -3.5 -2.5 -1.5 -0.5 0.5 1.5 2.5 3.5 4.5 5.5 6.5 7.5 8.5 9.5

0.02

(Y*-YX*) -4.75 -4.25 -3.75 -3.25 -2.75 -2.25 -1.75 -1.25 -0.75 -0.25 0.25 0.75 1.25 1.75 2.25 2.75 3.25 3.75 4.25 4.75

(X-XX )² 90.25 72.25 56.25 42.25 30.25 20.25 12.25 6.25 2.25 0.25 0.25 2.25 6.25 12.25 20.25 30.25 42.25 56.25 72.25 90.25 665

(X-XX )(Y*-YX*) 45.125 36.125 28.125 21.125 15.125 10.125 6.125 3.125 1.125 0.125 0.125 1.125 3.125 6.125 10.125 15.125 21.125 28.125 36.125 45.125 332.5

X 1 2 3 4 5 6 7 8 9 10 11 12 13 14

b1= b0*= Y=

Y

X* 2 7 16 30 49 60 90 100 180 200 240 280 350 400

0 0.693147 1.098612 1.386294 1.609438 1.791759 1.94591 2.079442 2.197225 2.302585 2.397895 2.484907 2.564949 2.639057 1.799373

2.031044 0.585401 b0= 29.99485

Y* 0.693147 1.94591 2.772589 3.401197 3.89182 4.094345 4.49981 4.60517 5.192957 5.298317 5.480639 5.63479 5.857933 5.991465 4.240006

1.795711

(X*-XX *) -1.79937 -1.10623 -0.70076 -0.41308 -0.18994 -0.00761 0.146537 0.280069 0.397852 0.503212 0.598522 0.685534 0.765576 0.839684

(Y*-YX*) -3.54686 -2.2941 -1.46742 -0.83881 -0.34819 -0.14566 0.259803 0.365164 0.952951 1.058311 1.240633 1.394783 1.617927 1.751458

(X*-XX *)² (X*-XX *)(Y*-YX*) 3.237743 6.3821223781 1.2237354 2.5377882918 0.4910655 1.0283085198 0.1706339 0.346494009 0.0360753 0.0661327238 5.7965E-05 0.0011089918 0.0214732 0.0380708562 0.0784384 0.1022709304 0.1582859 0.3791329242 0.2532225 0.5325549744 0.358229 0.7425463129 0.4699565 0.9561709505 0.5861072 1.2386466207 0.7050699 1.4706721226 7.7900936 15.8220206063

X

X*=1/X 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 8

b1= b0=

Y

1 10.2 0.5 5.2 0.333333 3.5 0.25 2.7 0.2 2.2 0.166667 1.9 0.142857 1.6 0.125 1.5 0.111111 1.3 0.1 1.2 0.090909 1.1 0.083333 1 0.076923 1 0.071429 0.9 0.066667 0.9 0.221215 2.413333 9.989869 Y= 0.203422

(X*-XX *) 0.778785 0.278785 0.112118 0.028785 -0.02122 -0.05455 -0.07836 -0.09622 -0.1101 -0.12122 -0.13031 -0.13788 -0.14429 -0.14979 -0.15455 -7.77878 10.19329

(Y-YX) 7.786667 2.786667 1.086667 0.286667 -0.21333 -0.51333 -0.81333 -0.91333 -1.11333 -1.21333 -1.31333 -1.41333 -1.41333 -1.51333 -1.51333

(X*-XX )² 0.606506 0.077721 0.01257 0.000829 0.00045 0.002976 0.00614 0.009257 0.012123 0.014693 0.01698 0.019011 0.02082 0.022436 0.023885 0.846397

(X*-XX )(Y-YX) 6.06413713 0.77688012 0.12183497 0.00825162 0.00452592 0.02800161 0.06373127 0.08787661 0.12258263 0.14707452 0.17113544 0.19487313 0.20393296 0.2266772 0.23388355 8.45539869

X

Y 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

b1= b0=

X*=1/X 2 2.5 2.7 2.9 2.9 3 3 3.1 3.1 3.1 3.1 3.2 3.2 3.2 3.2

0.200573 0.300098

1 0.5 0.333333 0.25 0.2 0.166667 0.142857 0.125 0.111111 0.1 0.090909 0.083333 0.076923 0.071429 0.066667 0.221215

Y*=1/Y 0.5 0.4 0.37037 0.344828 0.344828 0.333333 0.333333 0.322581 0.322581 0.322581 0.322581 0.3125 0.3125 0.3125 0.3125 0.344468

(X*-XX *) 0.778785 0.278785 0.112118 0.028785 -0.02122 -0.05455 -0.07836 -0.09622 -0.1101 -0.12122 -0.13031 -0.13788 -0.14429 -0.14979 -0.15455

(Y*-YX*) 0.155532 0.055532 0.025903 0.00036 0.00036 -0.01113 -0.01113 -0.02189 -0.02189 -0.02189 -0.02189 -0.03197 -0.03197 -0.03197 -0.03197

(X*-XX *)² (X*-XX *)(Y*-YX*) 0.60650566 0.1211262177 0.07772093 0.0154815707 0.01257046 0.0029041626 0.00082856 1.0360591E-05 0.00045009 -7.63608574E-06 0.00297555 0.0006073615 0.00614 0.0008724644 0.00925738 0.0021058643 0.01212292 0.0024098505 0.01469314 0.0026530394 0.0169797 0.0028520122 0.01901143 0.0044077617 0.02082024 0.0046126826 0.02243605 0.004788329 0.02388527 0.004940556 0.84639737 0.1697645971