B
bash
Hello,
I have made a exponential graph of below data set:
x y
0,90498 14294225
0,88252 14361091
0,91054 14392452
0,89546 14463203
0,90225 14535720
0,93918 14754041
0,93624 14812708
0,92533 14922256
0,94256 15000374
0,94681 15049871
0,93819 15051332
0,93495 15188711
0,95299 15425517
The equation I get is:
y = 6E+06e0,950x
Microsoft (http://office.microsoft.com/en-us/excel-help/add-change-or-
remove-a-trendline-in-a-chart-HP010007461.aspx) states that the
exponential equation is written on this form:
y = c*e^b*x
where c and b are constants and e is the base of the natural
logarithm.
When I want to calculate what y value I get for x = 0.97 I do like
this:
y(0.97) = (6*10^6)*e^(0.95*0.97) = 15078342.9
Above value is too small. Looking at the line scatter graph that Excel
produces the value should be around:
y = 154100000
What am I doing wrong?
I have made a exponential graph of below data set:
x y
0,90498 14294225
0,88252 14361091
0,91054 14392452
0,89546 14463203
0,90225 14535720
0,93918 14754041
0,93624 14812708
0,92533 14922256
0,94256 15000374
0,94681 15049871
0,93819 15051332
0,93495 15188711
0,95299 15425517
The equation I get is:
y = 6E+06e0,950x
Microsoft (http://office.microsoft.com/en-us/excel-help/add-change-or-
remove-a-trendline-in-a-chart-HP010007461.aspx) states that the
exponential equation is written on this form:
y = c*e^b*x
where c and b are constants and e is the base of the natural
logarithm.
When I want to calculate what y value I get for x = 0.97 I do like
this:
y(0.97) = (6*10^6)*e^(0.95*0.97) = 15078342.9
Above value is too small. Looking at the line scatter graph that Excel
produces the value should be around:
y = 154100000
What am I doing wrong?