# Exponential trend-line equation problem

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

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?

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

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?

Hi again,

Sorry the value should be around y = 154150000 and not previously
stated y = 154100000.

/Daniel