topic Re: Very High R-Square Value in Discussions
https://community.jmp.com/t5/Discussions/Very-High-R-Square-Value/m-p/38342#M22442
<P>I tried to reproduce your results and I do not get R squared = 1. I get something like 0.87, so i'm not sure what you are doing that is different. Also, there are a number of things from your description that I would not recommend - too many variables are trying to meausre the same sort of thing and using 80 something variables when you have 1400 data points seems like a poor idea to me. I also don't recommend deleting outliers - you might try log transformations instead.</P>Thu, 20 Apr 2017 16:10:42 GMTdale_lehman2017-04-20T16:10:42ZVery High R-Square Value
https://community.jmp.com/t5/Discussions/Very-High-R-Square-Value/m-p/38320#M22433
<P>Hi,</P>
<P>I am trying to calulate R-Square by using Step Wise regression in the attached DataSet</P>
<P> </P>
<P>Till now I have cleaned the data by excluding the outliers and also by removing variables : </P>
<P>Garage yrblt ,1stflsf,totrmsabvgrd & Garagecars as they have very high correlation.</P>
<P> </P>
<P>Recalculated the Lot frontage as Updated Lot Frontage as lot frontage had a lot of missing variables.</P>
<P> </P>
<P>My problem is the that the R-Square Value in the Step Wise regression, Forward, minimum BIC is 1.</P>
<P>What am i doing wrong??</P>Wed, 19 Apr 2017 22:29:34 GMThttps://community.jmp.com/t5/Discussions/Very-High-R-Square-Value/m-p/38320#M22433ShriHanuman2017-04-19T22:29:34ZRe: Very High R-Square Value
https://community.jmp.com/t5/Discussions/Very-High-R-Square-Value/m-p/38342#M22442
<P>I tried to reproduce your results and I do not get R squared = 1. I get something like 0.87, so i'm not sure what you are doing that is different. Also, there are a number of things from your description that I would not recommend - too many variables are trying to meausre the same sort of thing and using 80 something variables when you have 1400 data points seems like a poor idea to me. I also don't recommend deleting outliers - you might try log transformations instead.</P>Thu, 20 Apr 2017 16:10:42 GMThttps://community.jmp.com/t5/Discussions/Very-High-R-Square-Value/m-p/38342#M22442dale_lehman2017-04-20T16:10:42ZRe: Very High R-Square Value
https://community.jmp.com/t5/Discussions/Very-High-R-Square-Value/m-p/38349#M22444
<P>I can only think of two reasons you would get R squared = 1. You might have accidentilly included the house id as a nominal variable (althought it looks continuous in your dataset) as a factor - but you should have received a bunch of warnings in the regression results. You could have accidentilly included the sales price as a factor (by shift-clicking when you added variables). Either could produce that result, but I can't think of anything else.</P>Thu, 20 Apr 2017 16:38:22 GMThttps://community.jmp.com/t5/Discussions/Very-High-R-Square-Value/m-p/38349#M22444dale_lehman2017-04-20T16:38:22Z