close

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: www.excelforum.com/member.php...oamp;userid=33561
View this thread: www.excelforum.com/showthread...hreadid=533470quot;jhughes77quot; wrote:
gt; The auto-generated equation is:
gt; y=1E-69e^.0862x. What is the value of E in excel?

=exp(1)

gt; =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
quot;
gt; wrote in message
news
gt; quot;jhughes77quot; wrote:
gt;gt; The auto-generated equation is:
gt;gt; y=1E-69e^.0862x. What is the value of E in excel?
gt;
gt; =exp(1)

thanks for the info!--
jhughes77
------------------------------------------------------------------------
jhughes77's Profile: www.excelforum.com/member.php...oamp;userid=33561
View this thread: www.excelforum.com/showthread...hreadid=533470

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()