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
- Mar 13 Thu 2008 20:43
Value of E?
close
全站熱搜
留言列表
發表留言
留言列表

