How You Can Use Logistic Regression in Excel To Predict If a Prospect Will Buy
Uploader Comments (excelmasterseries)
All Comments (10)
-
Can't get the solver to find the right answer. Even with that constraint. (Using excel '10)
-
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
-
wish I understood how you determined the constraint! Key piece of the puzzle, it seems to me.
-
i'd like to download this spreadsheet but can't find it.
-
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.
-
you multiply probability. Summing those probabilities gives you a value that represents what??? Nothing real.
-
too fast and too advanced
-
T_T doesn't show much...
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.
excelmasterseries 9 months ago