ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Value of E? (https://www.excelbanter.com/excel-discussion-misc-queries/83578-value-e.html)

jhughes77

Value of E?
 

Hi. This is probably a stupid question, but I have an exponential
regression equation in excel based on data in a table. The
auto-generated equation is:

y=1E-69e^.0862x. What is the value of E in excel?


--
jhughes77
------------------------------------------------------------------------
jhughes77's Profile: http://www.excelforum.com/member.php...o&userid=33561
View this thread: http://www.excelforum.com/showthread...hreadid=533470


[email protected]

Value of E?
 
"jhughes77" wrote:
The auto-generated equation is:
y=1E-69e^.0862x. What is the value of E in excel?


=exp(1)

Chip Pearson

Value of E?
 
=exp(1)

Nope. The capital E indicates power of 10. 1E2 = 100.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"
wrote in message
...
"jhughes77" wrote:
The auto-generated equation is:
y=1E-69e^.0862x. What is the value of E in excel?


=exp(1)




jhughes77

Value of E?
 

thanks for the info!


--
jhughes77
------------------------------------------------------------------------
jhughes77's Profile: http://www.excelforum.com/member.php...o&userid=33561
View this thread: http://www.excelforum.com/showthread...hreadid=533470



All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com