Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
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 |
#2
|
|||
|
|||
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 ++++++++++++++++++++++++ "Hugh" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |