I have been playing around with the nonlinear fit tool, and am having a lot of fun with the individual confidence limits that it can generate. I want to be able to perform the same work using column formulas rather than pulling up the nonlinear tool (I am adjusting the section of the data to perform the fit on using variables). I have a way to perform the nonlinear fit using column formula, but I do not know the equations used to calculate the confidence limits. I know that the individual confidence limits for a linear fit has the equation; Yc = Yp +/- t(n-2.alpha/2) * Sqrt( Sum( ( Yi - Yip )^2) / ( n-2 ) ) * Sqrt( 1 + 1/n + ( Xp - Xbar )^2 / Sum( ( Xi - Xbar ) ^2 ) ) Yc = the confidence limit Yp = the predicted value of y from the fitted line t(n-2.alpha/2) = the t statistic for n-2 degrees of freedom and alpha/2 confidence Yi = the ith y value Yip = the predicted ith y value n = number of data points Xp = the x value for which Yp is predicted Xbar = the average x value Xi = the ith x value Can anyone tell me the similar equation for the confidence line for a fitted 3 parameter exponential (ie a fitted curve with the equation y = Exp ( m * x + b ) + c)?
... View more