How You Can Use Logistic Regression in Excel To Predict If a Prospect Will Buy

[h55nick]

Can't get the solver to find the right answer. Even with that constraint. (Using excel '10)

[lotsbg]

There's an error here, you have to maximise the product of the P(X )Y * [ 1 - P(X) ](1-Y) 's

not the sum of it. Then you won't have any problems with adding constraints

[mcook10128]

wish I understood how you determined the constraint! Key piece of the puzzle, it seems to me.

[richo12345678]

i'd like to download this spreadsheet but can't find it.

[excelmasterseries]

If anyone is interested, you may download the Excel spreadsheet that I used to make this video about performing logistic regression for $7. Go to: ExcelMasterSeries DotCom Slash ExcelLogisticRegression Dotphp In addition to the Excel spreadsheet, you also get a 100-page emanual about creating interactive Excel graphs of all of the most widely-used statistical distributions (Normal, t, Chi-Square, Weibull, Poisson, Binomial, and Exponential). Become an Excel Statistical Master.

[johntube28]

This (and the rest of the series) would have been really good stuff if not for the poor recording. I still listened to a few though but after a while I gave up. Thanks though.

[cessissy333]

you multiply probability. Summing those probabilities gives you a value that represents what??? Nothing real.

[solongo7]

too fast and too advanced

[pjsyhan]

T_T doesn't show much...