How do I evaluate y = 2E+06e-0.3766x for x = 9 in Excel?

[brh986]

I can't figure this out at all. I keep playing with parenthesis that seem like they shouldn't matter and are redundant and I keep getting different values that are way off base. Also the -0.3766x looks like it's superscript to me so therefor another exponent value. I tried both ways htough and hte values are still wrong. I'm expecting a value certainly of more than $10,000 and less than $117,000. Nothing I've tried even falls remotely in that range and some of them go in the wrong direction... i.e. as x gets bigger y gets bigger but it should definitely be the other way around.

Can anyone help.

The last thing I tried was =2*(10^(6*(EXP(1))^(-0.3766*9))). The answer was not even close 3.xxxx

[MSP77079]

Your equation worked fine on my machine.

Are you sure that you do not have the autocalculate turned off?

[brh986]

Your equation worked fine on my machine.

Are you sure that you do not have the autocalculate turned off?

I know it works in so far as it gives an answer but it's not giving the right answer so the equation must not be entered correctly.

What I have is y = 2E+06e-0.3995x. It appears exactly as pasted except htat "-0.3995x" is superscript so I guess it's denoting that it is an exponent factor of the 2+06e which I guess is 2 * 10^6*exp(1) or 2.718......

Then that whole term to the power of .3995x ...

I'm not sure if I'm interpretting that right but if I am interpretting it right and converting it to a formula properly then it should generate values like this (aproximately)

y = 1,500,000 x=1
y = 800,000 x= 2
y = 750,000 x = 3
y = 450,000 x =4
.... ... .

y= 125,000 x = 7

and so and so forth...

I'm trying to get a value for x equals nine and I'm getting all kinds of crazy answers that can't be right for the formula given like 3, 22, etc. It should be somewhere in the thousands at least.

Do you follow?

The latest thing I tried was =(2*(10^(6*EXP(1))))^(-0.3995*9) that gives an absurdly small number... a value less than one you have to go out 60 decimal places on. Totally wrong.


I found this article which seems to be exactly what I need but I'm STILL getting absurd values:

http://office.microsoft.com/en-us/ex...CL100570551033

According to that looks like I read it wrong and what it should be is (2*10^6 )^exp(-.3995x) or (2*10^6)^exp(-.3995*9) but now I'm getting 1.81 - obviously the wrong answer for the curve I have...

I don't understand this at all...

According the article it looks like:

=(2*10^6)^(EXP(-0.3995*9)) should work also but that evaluates to 1.49

That cannot possible be on this curve or part of this equation. Please see: http://www.objektivphoto.com/post_images/chart.jpg

[MSP77079]

Oh.

When I got something in the thousands, I assumed I got it wrong. Thought you were looking for something like 3.1415.

If you are looking for 64,457, then the answer is:

=(EXP(-0.3766*9))*(2*10^6)

[MSP77079]

The article's example is:

=58.552664*EXP(0.569367*A4)

Equavalent using your numbers would be:

=(2*10^6)*EXP(-0.3766*9)