Hi, Attached is the output for dendogram and two way clustering analysis. How do I interpret this? And how do i choose the best possible number of clusters from this data. ... View more

I have a data set to predict the sales price for houses. I ran a PCA analysis on the continuous variable without changing or cleaning the data. The analysis suggested that 26 component out of the 31 componnet explained 96% of variability. So I saved the values of these 26 component.I also created the column Updated LotFrontage as lot frontage had a lot of missing value. as the  Now I am trying to run a Predictive analysis(Neural,K-Mean) by choosing all the 26 saved component and all the remaining categorical variables as X factor and Sales price as Y. I want to have higher R-Square and a lower RMSE for the training data compared to the alidation data.   Is there a better way to clean this data?? ... View more

Hi, I have a data set to predict the sales price for houses. I ran a PCA analysis on the continuous variable without changing or cleaning the data. The analysis suggested that 26 component out of the 31 componnet explained 96% of variability. So I saved the values of these 26 component. Now I am trying to run a K-Means Analysis by choosing all the 26 saved component and all the remaining categorical variables as X factor and Sales price as Y. Attached is my result   Is there a way to show R-Square value in this result?? ... View more

Hi, I have a data set to predict the sales price for houses. I ran a PCA analysis on the continuous variable without changing or cleaning the data. The analysis suggested that 26 component out of the 31 componnet explained 96% of variability. So I saved the values of these 26 component. Now I am trying to run a neural netwrok analysis by choosing all the 26 saved component and all the remaining categorical variables as X factor and Sales price as Y. What I realize is that when I increease the NTanH value in the first layer the R-Square keeps increasing. The R-Square increases for NTanH 3 to 10 then reduces at NTanH 15 and then again increases at NTanH 40 etc.   WHY DID THE VALUE DECREASE FOR 15 AND THEN AGAIN START  INCREASING??   P.S ignore the the last three predicted sales price column. ... View more

Hi, I am trying to calulate R-Square by using Step Wise regression in the attached DataSet   Till now I have cleaned the data by excluding the outliers and also by removing variables :  Garage yrblt ,1stflsf,totrmsabvgrd & Garagecars as they have very high correlation.   Recalculated the Lot frontage as Updated Lot Frontage as lot frontage had a lot of missing variables.   My problem is the that the R-Square Value in the Step Wise regression, Forward, minimum BIC is 1. What am i doing wrong?? ... View more

Hi, I ran PCA on the attached Data Set.   The output is :   I am trying to increase the R-Square Value. In doing so, I want to only consider important variable.   Till now I have cleaned the data by excluding the outliers and also by removing variables : Garage yrblt ,1stflsf,totrmsabvgrd & Garagecars as they have very high correlation. Recalculated the Lot frontage as Updated Lot Frontage as lot frontage had a lot of missing variables.   Now my PCA analysis shows that 12 (out of 26) components can explain around 79.5% of the variability. So, am I correct if I save the formula for these 13 components and then exclude the variables that are used to get these component such as LotFrontage to UpdateLotFrontage.   So, Basically instead of using 26 variables now I will use 13 variables. After this variable reduction, I plan to run regression stepwise etc , neural network etc and try to see which method gives the best R-Square value   Is this approach correct??   Thanks ... View more