Interpolasi 222

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

x y

0.050 0.956
0.110 0.890
0.150 0.832 1.200
0.310 0.717
0.460 0.571 1.000 f(x) = 1.18279901400568 exp( − 1.
R² = 0.943886441716727
0.520 0.539
0.700 0.378 0.800
0.740 0.370
0.820 0.306 0.600
0.980 0.242
1.170 0.104 0.400

0.200

0.000
0.000 0.200 0.400 0.600 0.800 1
1.18279901400568 exp( − 1.75319885720003 x )
943886441716727

Column D
Exponential (Column D)

0 0.400 0.600 0.800 1.000 1.200 1.400


NO xi yi pi=log yi qi=log x qi^2 pi.qi
1 0.05 550 2.740 -1.301 1.693 -3.565
2 0.40 750 2.875 -0.398 0.158 -1.144
3 0.80 1000 3.000 -0.097 0.009 -0.291
4 1.20 1400 3.146 0.079 0.006 0.249
5 1.60 2000 3.301 0.204 0.042 0.674
6 2.00 2700 3.431 0.301 0.091 1.033
7 2.40 3750 3.574 0.380 0.145 1.359
8.450 12150 22.068 -0.831 2.144 -1.685

B A
1.207 1735.714 3.153 -0.119 0.457 3.207
1405918.367 19888.119
971632.653 95408.975
541275.510 206118.930 persamaan regresinya:
112704.082 122744.781 y=1610,276x^0,475
69846.939 11.827
929846.939 238977.192
4057346.939 1813094.015
8088571.429 2496243.841

a b Dt^2 Dt^2 r
1610.276 0.457 8088571.429 2496243.841 0.831
NO xi=qi yi qi^2 pi=In yi pi.qi
1 0.05 550 0.0025 6.3099 0.3155 1405918.37
2 0.40 750 0.1600 6.6201 2.6480 971632.65
3 0.80 1000 0.6400 6.9078 5.5262 541275.51
4 1.20 1400 1.4400 7.2442 8.6931 112704.08
5 1.60 2000 2.5600 7.6009 12.1614 69846.94
6 2.00 2700 4.0000 7.9010 15.8020 929846.94
7 2.40 3750 5.7600 8.2295 19.7508 4057346.94
8.4500 12150 14.5625 50.8134 64.8971 8088571.43

B A
1735.7143 1.2071 7.2591 0.81567 6.27443

bxi e^bxi
0.0408 1.0416
0.3263 1.3858
0.6525 1.9204
0.9788 2.6612
1.3051 3.6878
1.6313 5.1104
1.9576 7.0819
8.5045
207.4604
375.1603
159.0903 Dt^2 D^2 r
1801.1803 8088571.43 2798.6266 0.99982699
162.0888
85.1420
2798.6266

sehingga persamaanya :
y=530,8207 e^0,8157

a b
530.8207 0.8157

You might also like