Exponential trend-line equation problem

  • Thread starter Thread starter bash
  • Start date Start date
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?
 
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?

Hi again,

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

/Daniel
 
Back
Top