how to do self-defined regression in excel?

  • Thread starter Thread starter chuping
  • Start date Start date
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.
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XY scatter 1
multiple polynomial regression in Excel 4
how can I create a dummy variable in Excel? 1
Regression gives slope of zero when x values smaller than 10^-7 2
I want to use the regression tool in office excel 2007... 1
how do i graph a regression analysis? 1
Structured References - Regression Analysis 6
regression analysis in excel 2007? 1

Back
Top