In this part of the website, we provide additional information about various Excel capabilities not described in Excel Environment.
In this part of the website, we provide additional information about various Excel capabilities not described in Excel Environment.
Hi,
I am trying to automate the binary logistic regression function from your add-in. I have several tables that I need it to be run on (over 10). Is there a way to use Excel VBA code to automate the binary logistic regression?
Thank you for your help and please let me know if you need any additional information.
Thanks,
Justin
I should mention that the data in the tables will be changing, hence the reason for needing it automated. I am trying to avoid running the binary logistic regression manually every single time the data changes. Thanks.
Justin,
See the following webpage
https://real-statistics.com/real-statistics-environment/calling-real-statistics-functions-in-vba/
Charles
HELLO
I Aslam one enquiry abt excel i had cretaed one workbook having more than 500 sheet and in one sheet 100 to 1200 columns are using to save data is there any limited capability for excel workbook if so how much thus did i lose my date
Hello Aslam,
Sorry, but I don’t know the limits on the number of sheets in an Excel workbook. I would think this this is largely governed by the amount of memory available.
Charles