If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Treadline Equation
Hello Everyone -
When use a series of data and create a chart - then from that create a treadline to forecast future values - sometimes the formula Excel provides (used to forecast the future values) is, im guessing, to big or too long and Excel will place an E next to a number. Here is an example: y = 762870x + 5E+06 How can I see the equation in its entirety so I can use it? Thanks! |
#2
|
|||
|
|||
Treadline Equation
I assume that you mean "trendline", not "treadline"?
5E+06 means 5 * 10^6 You may want to try a function such as LINEST or LOGEST, depending on what sort of trendline you are looking at. -- David Biddulph MC wrote: Hello Everyone - When use a series of data and create a chart - then from that create a treadline to forecast future values - sometimes the formula Excel provides (used to forecast the future values) is, im guessing, to big or too long and Excel will place an E next to a number. Here is an example: y = 762870x + 5E+06 How can I see the equation in its entirety so I can use it? Thanks! |
#3
|
|||
|
|||
Treadline Equation
MC -
Several possibilites: (1) Select the equation, and then Format it. Method depends on Excel version, which you didn't specify. (2) For a linear trendline, use the INTERCEPT and SLOPE worksheet functions (or array-entered LINEST, especially if you want diagnostics). (3) Or, for linear forecasts, use the array-entered TREND worksheet function. - Mike http://www.MikeMiddleton.com "MC" wrote in message ... Hello Everyone - When use a series of data and create a chart - then from that create a treadline to forecast future values - sometimes the formula Excel provides (used to forecast the future values) is, im guessing, to big or too long and Excel will place an E next to a number. Here is an example: y = 762870x + 5E+06 How can I see the equation in its entirety so I can use it? Thanks! |
#4
|
|||
|
|||
Treadline Equation
Haha yes I did mean trendline thanks for that correction. I do not know what
I was thinking when I wrote that. I do not know how to use the LINEST, TREND, or LOGEST functions, but I was using the trendline to forecast future expenses, assuming they increase in a linear fashion (which is more than likely not the case, but it works well enough). Thanks for the help - It is much appreciated David and Mike! "MC" wrote: Hello Everyone - When use a series of data and create a chart - then from that create a treadline to forecast future values - sometimes the formula Excel provides (used to forecast the future values) is, im guessing, to big or too long and Excel will place an E next to a number. Here is an example: y = 762870x + 5E+06 How can I see the equation in its entirety so I can use it? Thanks! |
#5
|
|||
|
|||
Treadline Equation
If you don't know how to use any Excel function (with the exception of
DATEDIF), look it up in Excel help. -- David Biddulph MC wrote: Haha yes I did mean trendline thanks for that correction. I do not know what I was thinking when I wrote that. I do not know how to use the LINEST, TREND, or LOGEST functions, but I was using the trendline to forecast future expenses, assuming they increase in a linear fashion (which is more than likely not the case, but it works well enough). Thanks for the help - It is much appreciated David and Mike! "MC" wrote: Hello Everyone - When use a series of data and create a chart - then from that create a treadline to forecast future values - sometimes the formula Excel provides (used to forecast the future values) is, im guessing, to big or too long and Excel will place an E next to a number. Here is an example: y = 762870x + 5E+06 How can I see the equation in its entirety so I can use it? Thanks! |
Thread Tools | |
Display Modes | |
|
|