Hello all,
I have a quick question regarding the logistic regression outputs.
Does the logistic regression automatically standardize my numeric observations, or would I have to firstly change my data using the STANDARDIZE function, and then produce the logistic regression?
Thanks,
Wadi Luca Watfa
Administrative Note:
Welcome to the forum.
Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Maybe this will help. https://www.statology.org/logistic-regression-excel/
As we don't know what your data looks like it's unlikely anyone can guess what you need to do to it.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for the link,
I have not standardized any of my data. The variables all have different measures, such as income vs weight.
Do you happen to know is the excel logistic regression analysis from Real Statistics add on automatically standardizes the x variables coefficients? or does that require observations that are standardized prior to the analysis?
Thanks.
Not a clue I’m afraid.
I'll see if I can get help from elsewhere.
Thank you, I really appreciate it. Sadly I cannot find an answer so far
I'm not sure if any of us on here are familiar enough with the Real-Statistics addon to answer the questions. Have you read through the documentation: (landing page for the logistic regression section, it's 14 pages, so I didn't read through it, but you would probably understand it better anyway:https://www.real-statistics.com/logistic-regression/ ). He seems to still be active on the site (a blog entry from earlier this month), I would probably suggest you ask the programmer this question. He seems fairly responsive to comments left on those pages, so perhaps just a comment on an appropriate page from the Logistic regression section would generate a quick and reliable answer.Do you happen to know is the excel logistic regression analysis from Real Statistics add on automatically standardizes the x variables coefficients? or does that require observations that are standardized prior to the analysis?
Originally Posted by shg
Thank you very much! appreciate the help
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks