Very useful video. Thank you very much. But there's a little detail people should be warned about: in order for the calculation to be performed correctly, every categorial variable needs to be transformed into a dummy following the Excel setup, which is a column for each dummy and all the others kept equal to zero.
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. "
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?
Hi, if i have 3categories in the output variable. What shall be the cut off? Shall i just go with 0.5? It will be highly appreciated if someone could help me with the answer! Thanks!
The model doesn't actually find the overall percentage of who survived or died? I don't understand why it's important to know how well the model predicted who survived or died.
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
+Data Analysis Videos I have created a logistic model using historical data and now want to apply the model to new patients. I you need to extract the equation and apply it to the new patients. What can I do for it? Please respond, it's very important for me.
Hello, I have a question. On the bottom part where we see the coefficients and Wald value and the P value. Do we remove the variable that has more than .05 p value? Same like the linear regression?
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
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?
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
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.
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.
Yes, I would say you are right since I'm getting the same results as it is in the video. :) Do you think that the cell R5 in the 'Coeff' column refers to intercept of the regression equation?
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.
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)
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?
use real stats 2011 for mac (even if you are using office/excel 2016). It worked for me just now. Finally! Click here on www.real-statistics.com/wp-content/uploads/2018/07/RealStats-Mac-2011.xlam to download the latest version (Release 5.7) of the resource pack for Excel 2011 for the Mac
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...
Close the Train.csv workbook and all associated workbooks and create a new workbook (not Train). You will see that Add-in tab beside Developer here. Now close that and open Train.csv again. Sounds silly but that's what worked for me. Now I can again see my Add-in tab beside Developer.
Sachin, I used a different computer on 2013 Excel. It seems to be an issue with 2007 or older. i believe the website provides versions of the stats tool that work for the older versions of Excel.
You are asking for free help -- there is plenty enough resources available for you to learn this -- which you obviously have not pursued -- do that first,, then ask for help.
One Indian standup comedian once said, " The smallest particle is atom that is comprised of proton, electron and neutron. Electron is the lightest. Now cut electron into four parts. Pick one part. That's how small male ego is". Just kidding man. I know you also said that just light-heartedly. Just wanted to share the joke. :)
Very useful video. Thank you very much. But there's a little detail people should be warned about: in order for the calculation to be performed correctly, every categorial variable needs to be transformed into a dummy following the Excel setup, which is a column for each dummy and all the others kept equal to zero.
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. "
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?
Hi, if i have 3categories in the output variable. What shall be the cut off? Shall i just go with 0.5?
It will be highly appreciated if someone could help me with the answer!
Thanks!
this is amazing. i know close to nothing and was able to do this and understand it
super useful, saved my thesis! thank you very much!!
contact me please
Hqdocml
The model doesn't actually find the overall percentage of who survived or died? I don't understand why it's important to know how well the model predicted who survived or died.
How to do flood mapping using logestic regression?
Thanks, good video and the explanations and examples for each thing are really helpful. Is there a way to make the accuracy increase?
Thank you for this tutorial. Excellent explanation without using any technical words
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
+Lukas Halim can you send me new link? This one doesn't exist.
+Sargis Davtyan Oh darn, I let the website expire. Sorry about that.
+Data Analysis Videos , It's a pity (((
+Data Analysis Videos I have created a logistic model using historical data and now want to apply the model to new patients. I you need to extract the equation and apply it to the new patients. What can I do for it? Please respond, it's very important for me.
yeah I need help with this too please respond
Very helpful add-in and explanation!
Thank you!
Hello, I have a question. On the bottom part where we see the coefficients and Wald value and the P value. Do we remove the variable that has more than .05 p value? Same like the linear regression?
Any way to get Odds Ratios from the excel linear regression program?
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
can you do the same thing for like a correlation? sorry i am really helpless idk what to do with my thesis!! thanks!
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?
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
smart
No link to download template so that I can try on my own?
How can I check and train my remaining data to understand that the model prepared here is giving us the right result?
Is there a way to weight the dependent variable using this package? Thank you!
So how do you transform from test to train?
thanks very much
Your video and website is brilliant. Thanks.
Hi, what can I do if excel told me that cant use this tool cuz is not secure?
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.
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.
Yes, I would say you are right since I'm getting the same results as it is in the video. :) Do you think that the cell R5 in the 'Coeff' column refers to intercept of the regression equation?
Click Ctrl+M (even on Mac click Ctrl and not Command) to get the sub tools (Binary/probit logistic included) under Add-in to show
M getting a compilation error in hidden module .how to overcome it?
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.
is the same password of your User
What is that even mean ?
My Excel 2013 asks the same
if u just click cancel, you can continue to use the add on
Muy buen video.👍
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)
What secret steps am I missing to find a password for your pack?
fantastic method for data analysis.
It is showing an error - run time error 1004, application defined or object defined wrong. what should i do?
why not use mode? average age creates decimal
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?
Is it possible to do Multinomial Logistic Regression?
I am getting error:"Compilation Error in Hidden Module " when I want to run logistic regression. How can i sort out this error?
use real stats 2011 for mac (even if you are using office/excel 2016). It worked for me just now. Finally!
Click here on www.real-statistics.com/wp-content/uploads/2018/07/RealStats-Mac-2011.xlam to download the latest version (Release 5.7) of the resource pack for Excel 2011 for the Mac
Not use excel, but add-in that for the fuction is very expensive. There are better program...
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...
Could you please shared the Excel file
Is there any video for the Add In on Mac? I cant see the Add In Shortcut on the Data Ribbon.
www.real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/
I downloaded this but still do not see the Add In Shortcut on the Data Ribbon?
I have excel 2015 on mac
Close the Train.csv workbook and all associated workbooks and create a new workbook (not Train). You will see that Add-in tab beside Developer here. Now close that and open Train.csv again. Sounds silly but that's what worked for me. Now I can again see my Add-in tab beside Developer.
Liked it. Wii try on my own.
Thank You!
Hi! where can i download excel?
GREAT
How to calculate Odds ratio and upper and lower confidence interval in excel? pls help me
very nice job, thank u
I am getting error:"Compilation Error in Hidden Module " How can i sort out this error
I am getting the same error, would appreciate any assistance.
Sachin, I used a different computer on 2013 Excel. It seems to be an issue with 2007 or older. i believe the website provides versions of the stats tool that work for the older versions of Excel.
Perfect ! thank you
Terimakasih
can you show how to use logistic regression on time series data/?
You are asking for free help -- there is plenty enough resources available for you to learn this -- which you obviously have not pursued -- do that first,, then ask for help.
what's the password for downloading the addin?
too fast you need to slow down
I feel appalled with you making males equal zero!
One Indian standup comedian once said, " The smallest particle is atom that is comprised of proton, electron and neutron. Electron is the lightest. Now cut electron into four parts. Pick one part. That's how small male ego is". Just kidding man. I know you also said that just light-heartedly. Just wanted to share the joke. :)
Anyone know the password for installing?
It doesn't need password.
Uncle benus