Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

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

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
18,335
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Apr 26, 2010

This Video Will Provide Step-By-Step Instructions on How to Use Logistic Regression in Excel to Predict if Your Prospect Will Buy. You Will See Just How to Use the Solver in Excel to Run Logistic Regression That Will Produce the Most Accurate Predictive Equation As To Whether Your Prospect Will Buy.

  • likes, 1 dislikes

Link to this comment:

Share to:

Uploader Comments (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.

see all

All Comments (10)

Sign In or Sign Up now to post a comment!
  • 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...

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more