What does the "E" in 5E - 71e^0.085x mean? (MS EXCEL)

G

Guest

I am used MS EXCEL to perform a scatter plot. When the information was graph,
Excel provided me with the formula 5E - 71e^0.085x. What does the "E" in 5E
mean?
 
B

Bernard Liengme

The E is the way Excel represents 10 to the power. So 1.2E3 is 1.2X10^3 or
1200 and 1.2E-3 is 1.2 x 10^-3 or 0.0012.

"College Professor"
 
J

Jerry W. Lewis

1.2E3 is certainly 1.2 * 10^3, but I do not think that is the OP's
question.

It looks like he/she has fit an exponential trendline and displayed the
equation. In that case, -71e^0.085x would be calculated in a worksheet as
=71*EXP(0.085*x)
since e=2.71828182845905... is the base of natural logarithms. I am
mystified by the leading "5E -" was that transcribed correctly?

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top