Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Making your own trenlines
Since I'm working databases that are subject to change, I would like to be
able to make my own trendline formulas. The built-in trendline function of excel doesn't let me use the trendline formula shown in the graph, and I don't want to manually change my formulas each time my database changes. I've been able to make my own linear- and 'power'trendlines as follows: My linear trendline: form: y=a*x+b a=SLOPE(Yrange;Xrange) b=INTERCEPT(Yrange;Xrange) Mijn 'Power'trendline: form: y=a*x^b a=EXP(INTERCEPT(LN(Yrange);LN(Xrange))) b=SLOPE(LN(Yrange);LN(Xrange)) So currently I'm looking for the following two: Logarithmic trendline in the form: y=a*Ln(x)+b Exponential trendline in the form: y=a*e^(b*x) Thanks in advance, Maarten |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making Mailing Labels | Links and Linking in Excel | |||
making a non-validation list | Excel Worksheet Functions | |||
Making a cell self contained. | Excel Discussion (Misc queries) | |||
making an employee schedule in two sheets | Excel Worksheet Functions | |||
making a workbook into a web page. | Excel Worksheet Functions |