Exponential Trend

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

KİŞİ x y F0

1 40 500 524.25057698
2 40 750 524.25057698
3 50 800 912.02254976
4 55 1100 1202.925984
5 62 1599 1772.415615
6 70 2500 2760.1894714
7 80 4200 4801.8164405
8 90 9700 8353.5718716
9 100 16000 14532.451183

F0 y=a.b^x =57,236*1,056^x (b,a) =LOGEST(y range;x range) 1.0569310728


F1 y=a.e^cx =57,236*e^0,055x c=ln(b) 0.0553694945
F2 y=e^(cx+d) =e^(0,055x+4,047) d=ln(a) 4.0471899903

x y logy x.logy
40 500 2.69897000433602 107.95880017
40 750 2.8750612633917 115.00245054
50 800 2.90308998699194 145.15449935
55 1100 3.04139268515822 167.27659768
62 1599 3.20384846374623 198.63860475
70 2500 3.39794000867204 237.85580061
80 4200 3.6232492903979 289.85994323
90 9700 3.98677173426624 358.80945608
100 16000 4.20411998265592 420.41199827
SUM 587 29.9344434196162 2040.9681507
F1 F2
524.25057698 524.250576982 18000
524.25057698 524.250576982 16000
912.02254976 912.022549757
14000 f(x) = 57.2363960330163 exp( 0.055369494501198 x )
1202.925984 1202.92598399
1772.415615 1772.41561503 12000
2760.1894714 2760.18947137 10000 Column C
4801.8164405 4801.8164405
8000 Exponential (Colum
8353.5718716 8353.57187157 Column D
14532.451183 14532.4511834 6000
4000

57.236396033 2000

0
30 40 50 60 70 80 90 100 110

x^2
1600
1600
2500 0.024047 slope
3025 1.757672 intercept
3844 y=0,02405x+1,75767 lineer
4900
6400 y=A*r^x exponential curve
8100 1.056931 r=10^slope ln(r)= 0.055369495
10000 57.2364 A=10^intercept ln(A)= 4.04718999
41969

y=57,236*(1,05693)^x
y=57,236*e^0,0553x
y=e^(0,055x+4.047)
369494501198 x )

Column C
Exponential (Column C)
Column D

110
0.0000000 0.4771210 0.0000000 0.0000000
2.0000000 0.6020600 1.2041200 4.0000000
4.0000000 1.0413900 4.1655600 16.0000000
7.0000000 1.3979400 9.7855800 49.0000000
13.0000000 3.5185110 15.1552600 69.0000000

0.1390691
0.4276531

You might also like