Logistic Regression Using Excel



Predict who survives the Titanic disaster using Excel.

Logistic regression allows us to predict a categorical outcome using categorical and numeric data. For example, we might want to decide which college alumni will agree to make a donation based on their age, gender, graduation date, and prior history of donating. Or we might want to predict whether or not a loan will default based on credit score, purpose of the loan, geographic location, marital status, and income. Logistic regression will allow us to use the information we have to predict the likelihood of the event we’re interested in. Linear Regression helps us answer the question, “What value should we expect?” while logistic regression tells us “How likely is it?”

Given a set of inputs, a logistic regression equation will return a value between 0 and 1, representing the probability that the event will occur. Based on that probability, we might then choose to either take or not take a particular action. For example, we might decide that if the likelihood that an alumni will donate is below 5%, then we’re not going to ask them for a donation. Or if the probability of default on a loan is above 20%, then we might refuse to issue a loan or offer it at a higher interest rate.

How we choose the cutoff depends on a cost-benefit analysis. For example, even if there is only a 10% chance of an alumni donating, but the call only takes two minutes and the average donation is 100 dollars, it is probably worthwhile to call.

Nguồn: https://tongcucthuevietnam.com

Xem thêm bài viết khác: https://tongcucthuevietnam.com/tong-hop

Views:
30
Article Tags:
Article Categories:
Tổng Hợp

Comments

  • shrtlink.ca/49l0vexxxday

    Maria Hill July 9, 2020 4:10 pm Reply
  • Liked it. Wii try on my own.

    Prashant Mulawkar July 9, 2020 4:10 pm Reply
  • What is the difference between summary data and raw data.?

    aashita jain July 9, 2020 4:10 pm Reply
  • This is pretty gnarly stuff. Powerful stuff. Thanks for posting! Wonderful little tool for a small business owner; you can model a response rate to a marketing campaign and use this to quantify your Return On Marketing Investment (ROMI). (!) 👍

    Lash LaRue July 9, 2020 4:10 pm Reply
  • When I go to run a Binary Logistic Regression using this Pack I keep getting an alert saying that the "Summary Table must have at least two data rows" but my input data does have two rows and I am not inputing summary data, I'm inputing raw data. Can anyone help me figure this out?

    Noah Fischer July 9, 2020 4:10 pm Reply
  • what's the password for downloading the addin?

    Nicolas Uribe July 9, 2020 4:10 pm Reply
  • For a vastly easier way to fit logistic regression models in Excel, with highly interactive output worksheets, try RegressItLogistic, a free add-in. Visit https://regressit.com to obtain the software and documentation and see https://regressit.com/titanic-example.html for detailed walk-through of the Titanic example. RegressItLogistic is completely menu-driven and produces more detailed and better designed output than you will get with just about any other logistic regression software. Most of the tables and charts have interactive features that allow you play with parameters such as the cutoff level after fitting a model in order to see what happens to classification performance–very good for teaching or demonstrating the complex properties of logistic models and performing sensitivity analysis. The program also contains an interface with R that allows logistic models to be fitted in R via a menu interface in Excel, with customized table and chart output, which opens up more possibilities for fitting large models and performing a variety of testing. This feature does not require writing code and can be used by anyone. RegressItLogistic also includes many features to aid instructors, such as built-in teaching notes and support for auditing student work and carrying out grading on a large scale. Give it a try, whether you are a practitioner or a student or a teacher.

    RegressIt July 9, 2020 4:10 pm Reply
  • Uncle benus

    Jono • July 9, 2020 4:10 pm Reply
  • would it not be more correct to split the 'class' in to 3 dummy variables 'first', 'second' and 'third' so that the effects can be evaluated individually?

    same for sex

    can someone explain the difference in leaving them as discrete variables vs using dummy variables?

    Darius Lai July 9, 2020 4:10 pm Reply
  • M getting a compilation error in hidden module .how to overcome it?

    Surbhi Sarawagi July 9, 2020 4:10 pm Reply
  • What secret steps am I missing to find a password for your pack?

    mark July 9, 2020 4:10 pm Reply
  • can you show how to use logistic regression on time series data/?

    Ab Dilawar July 9, 2020 4:10 pm Reply
  • It is showing an error – run time error 1004, application defined or object defined wrong. what should i do?

    simi July 9, 2020 4:10 pm Reply
  • How can I check and train my remaining data to understand that the model prepared here is giving us the right result?

    Mahesh Shukla July 9, 2020 4:10 pm Reply
  • https://www.youtube.com/watch?v=jSGefRUrWmQ

    Klekot July 9, 2020 4:10 pm Reply
  • The Most important thing is Before open xlam, you should make sure that you checked the "Solver Function"
    and than close the excel , finally open it from dialog . I also barely fix the Problem with "Password thing"

    In site you can check this words "Most important, remember that Solver must be installed.
    To check this, press Alt-TI and make sure that Solver (as well as RealStats) is on the list of addins with a check mark next to it. "

    서태양 July 9, 2020 4:10 pm Reply
  • Hi, Ive used this method to generate a good predictive model on a training dataset. How do I now apply this model to a test dataset and see what it would predict? ( Ie I dont have the values of the DV but I have all other independent variables)

    Jamie Bailey July 9, 2020 4:10 pm Reply
  • Your video and website is brilliant. Thanks.

    Anant Mehta July 9, 2020 4:10 pm Reply
  • Thank you for this tutorial. Excellent explanation without using any technical words

    EDU4519Computing1 July 9, 2020 4:10 pm Reply
  • Does the add-in include marginal effects? Since coefficients do not equal marginal effects in logistic regression, that's a critical output. Also how about pseudo r-square? Obviously traditional r square mean nothing…

    LexBrett Gen2 July 9, 2020 4:10 pm Reply
  • Hi! Ive downloaded and installed the real statistics tool pack for excel 2016 so my selection window, in video at 3,32mins, looks different and im having problems understanding what option to choose. In the category of logistic regression i have 'binary and Probit logistic regression' and 'multinomial logistic regression' to choose from?

    anna hallengren July 9, 2020 4:10 pm Reply
  • this is amazing. i know close to nothing and was able to do this and understand it

    angiedocnxtdoor July 9, 2020 4:10 pm Reply
  • Is it possible to do Multinomial Logistic Regression?

    Luis Javier Barragan Tamez July 9, 2020 4:10 pm Reply
  • Very helpful add-in and explanation!
    Thank you!

    Alexandra Mihalcea July 9, 2020 4:10 pm Reply
  • How to calculate Odds ratio and upper and lower confidence interval in excel? pls help me

    subeesh k viswam July 9, 2020 4:10 pm Reply
  • fantastic method for data analysis.

    hulihuihong July 9, 2020 4:10 pm Reply
  • very nice job, thank u

    theCcmanccman July 9, 2020 4:10 pm Reply
  • Anyone know the password for installing?

    Chisom Okpala July 9, 2020 4:10 pm Reply
  • Perfect ! thank you

    서태양 July 9, 2020 4:10 pm Reply
  • Thank you for the detailed explanation. very helpful.

    But I alsos have a question?

    I was able to replicate the steps and get similar results. How do you explain row number 549 that has 2 Success counts, 1 Failure count. totalling upto 3.

    Is it possible?

    PLese help.

    Thank
    Dev

    Dev A July 9, 2020 4:10 pm Reply
  • Thank you so much!!!!

    MATFAL EIRL July 9, 2020 4:10 pm Reply
  • When trying to add RealStat Add-on in Excel – Its asking for RealStat Password. So what is the password for RealStat Add-on to get added into my Excel 2016.

    Saurabh Kumar July 9, 2020 4:10 pm Reply
  • On my logistic regression homework, I have to find the coefficient for moderate, conservative, age, economy president, widowed, and non Hispanic black. The columns are those coefficients, B, S.E., wald, df, sig, and exp(B). How do I find the logistic regression for those coefficients (moderate, conservative, economy president, age, widowed, and nonhispanic black using excel?

    Amber Greer July 9, 2020 4:10 pm Reply
  • I am getting error:"Compilation Error in Hidden Module " when I want to run logistic regression. How can i sort out this error?

    Raywin Ovah July 9, 2020 4:10 pm Reply
  • I have downloaded the real statistics tool pack but I cant see logistic regression. Please confirm if its the same as binary regression under regression.

    Raywin Ovah July 9, 2020 4:10 pm Reply
  • super useful, saved my thesis! thank you very much!!

    Gabriel Hernandez Valdivia July 9, 2020 4:10 pm Reply
  • Is there any video for the Add In on Mac? I cant see the Add In Shortcut on the Data Ribbon.

    Carlo Burgos July 9, 2020 4:10 pm Reply
  • I am getting error:"Compilation Error in Hidden Module " How can i sort out this error

    sachin gupta July 9, 2020 4:10 pm Reply
  • can you do the same thing for like a correlation? sorry i am really helpless idk what to do with my thesis!! thanks!

    veronica d. July 9, 2020 4:10 pm Reply
  • Hi Lucas,

    I've used your excellent add-on to predict market movements based upon data I've recorded. As expected, my parameters offered little predictive qualities, oh well.

    I then decided to try and prove to myself the power of this method of regression. I created a two column data set (200 rows). The first column contained a random number between 0 and 100, my predicted value was set as 1 if the random number was greater than 75, otherwise 0. I expected the tool to be able predict with a high probability that numbers over 75 are predictive of the value being 1.

    When I ran the Binary Logistic Regression, I got all values in the output tables set to #VALUE! any idea where I have gone wrong ?

    Thanks

    Sugar Rush 555 July 9, 2020 4:10 pm Reply
  • Any way to get Odds Ratios from the excel linear regression program?

    attitude928 July 9, 2020 4:10 pm Reply
  • This was so helpful! Thank you. I followed all your instructions, but for some reason, 4 columns of my data on the "new" sheet became 0. Is this normal? Also, my ROC Curve ended up as a diagonal line. I'm not sure what I'm doing wrong.

    Angela Tang July 9, 2020 4:10 pm Reply
  • I feel appalled with you making males equal zero!

    Traders Club July 9, 2020 4:10 pm Reply
  • Can you please post a follow up video that explains the rest of the results . I am using logistic regression to predict if a patient would be readmitted to a hospital given some variables. How would I apply the results to a
     given patient. Thanks

    Jayshri Balaji July 9, 2020 4:10 pm Reply

Leave a Reply

Your email address will not be published. Required fields are marked *