Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / January 2005

Tip: Looking for answers? Try searching our database.

Formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Hugh - 30 Jan 2005 15:26 GMT
On a graph I have the following trend line formula.
y=6E+06e to the power of -5.1056x.

If x=2 what would be the formula that I put into excel.

Thanks
Michael R Middleton - 30 Jan 2005 19:27 GMT
Hugh  -

Looks like the Exponential type of trendline.  Here's a short answer:

You'll need more precision to get reliable results. So first select the
textbox on the chart, and press the Increase Decimal button numerous times
until 15 digits are displayed.

Then, on a worksheet, enter the 15-digit values, like this:

=612345.123456789*EXP(-5.10512345678901*2)

Here's some longer answers:

The Exponential type of trendline uses linear regression of log Y as the
dependent variable and X as the explanatory variable. You can obtain the
regression coefficients using the worksheet function LOGEST. And you can
obtain fitted values (e.g., for X = 2) using the GROWTH worksheet function.
See Excel's built-in Help for details, or see Chapter 15, "Simple Nonlinear
Regression," in my book "Data Analysis Using Microsoft Excel: Updated for
Office XP."

-  Mike

www.mikemiddleton.com

++++++++++++++++++++++++

> On a graph I have the following trend line formula.
> y=6E+06e to the power of -5.1056x.
> If x=2 what would be the formula that I put into excel.
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.