I know that Excel has buit in functiions for SLOPE and INTERCEPT used for least sqaures analysis to solve y = a*x+b. But are there any functions that will detemine the coefficients for the equation y = a + b*Ln(x) + c*x?
I know that Excel has buit in functiions for SLOPE and INTERCEPT used for least sqaures analysis to solve y = a*x+b. But are there any functions that will detemine the coefficients for the equation y = a + b*Ln(x) + c*x?
If you have x values in col A, y values in col C, and the formula =LN(x) in col B, then in a three-wide range array-enter this formula:
=LINEST(C1:C100, A1:B100, TRUE)
The coefficients will apear in the order b, c, a
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks