Hello guys, i know excel isn't as good at performing logistic regression as good as sigma stat/ SPSS. Bit i need to perform it as part of a long sequence of macros. There are a references to achieving this using solver, but it seems that either i am doing it wrong or Solver returns a different answer each time.

If anybody has the ability to do one regression for me, i can repeat this for all of my data sets. I enclose an example spreadsheet too.

Many thanks for taking the time to look at my post,

Best regards

Alan

logisitic regression in excel.xlsx