.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Logistic regression co-efficients

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server

I am currently conducting my own benchmarking exercise on a dataset making use of the SSAS logistic regression algorithm.

The issue that I currently face is that I am obtaining a very linear set of results, i.e. the co-efficients of the regression equation are all neatly staggered, when run through two alternate software packages other than SSAS. When I run the same dataset through the SSAS logistic regression algorithm and extract the results, i.e. I extract the co-efficients from the model, the neat linear set of co-efficients become completely non-sensical and do not follow any trend whatsoever.

I am conducting some preperation of the dataset before it is run into each algorithm i.e. I am discretising the dataset into "classes" of my choosing by conducting additional analysis on the underlying data trends. One of my variables is set to "predict only" while all of the other variables are set as "discrete" and "input". The reason for the use of "discrete" is due to the fact that I am assigning a class ID to each piece of data depending on the which "class" the particular value falls into. As a result, I obtain a corresponding co-efficient for each class. e.g. variable = Age. I break this into classes 0-18, 19-35, 36 - 74, >=75, assign a class ID and feed this, along with all

View Complete Post

More Related Resource Links

SSAS logistic regression vs. vanilla logistic regression

I recently ran the same data set through the SSAS logistic regression (Neural network - Hidden layer disabled) as well as a vanilla logistic regression procedure. I am aware that different processes are followed in order to obtain the resulting co-efficients, however, has anyone got further information as to how close the results of the SSAS logistic regression equation are in comparison to logistic regression equations contained in other statistical packages such as SAS or SPSS? I do understand that the respective procedures are dependant on the quality of the data that they are applied to. I assume that the SSAS logistic regression may perform more favourably on one dataset in comparison to a vanilla logistic regression and vice versa. I am aware of the following post however it does not go into much detail concerning the results of the comparison. http://social.msdn.microsoft.com/Forums/en/sqldatamining/thread/4f381c6b-2471-4d4c-a022-316a1073184d Further info would certainly be appreciated.

Could not derive coefficient and regression coefficients from Logistic Regression predictions.


Does anyone know how I can get the coefficient and regression coefficients for each prediction that the Logistic Regression made? I've sifted through all of the mining functions and none of them seems to be the same.

Thanks in advance!

MCP, MCSD, MCDBA (dB Wizards)

T-SQL linear regression in multiple dimensions

Hi! I'm trying to make linear regression T-SQL in multiple dimensions  (y = a + a1*x1+ ... a2*xn) like LINEST function in Excel.I need create a similar stored procedure in SQL Server.I also created the code using the article http://charlottecredittechnology.blogspot.com/2008/11/sql-2008-excel-like-linest-function.html but i have troubles in re-adapt to a model with multiple dimensions...thanks!
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend