David 的個人 Blog: Excel 趨勢線的公式

Excel 趨勢線的公式 Linear Trendline Equation: y = m * x + b m: =SLOPE(y,x) b: =INTERCEPT(y,x) Logarithmic Trendline Equation: y = (c * LN(x)) - b c: =INDEX(LINEST(y,LN(x)),1) b: =INDEX(LINEST(y,LN(x)),1,2) Power Trendline Equation: y=c*x^b c: =EXP(INDEX ...

cwjen888.blogspot.com