how to do self-defined regression in excel?

C

chuping

Hi, I want to do regression ananlysis in excel using a
sigmoid function, which is not offered in the general 6
functions in excel(by adding trendline). How can I do it?
Thanks.
 
M

Mark

The Analysis ToolPak - VBA addin has a regression function
and probably everything else you want.

Tools > AddIns then checkmark Analysis ToolPak - VBA
Go back to Tools dropdown and it should be listed near the
bottotm of the dropdown.
 
J

Jerry W. Lewis

You can use Solver to minimize the sum of squared deviations for a Least
Squares fit. There may be might specific approaches, if we knew your
function.

Jerry
 
Top