turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Re: Very High R-Square Value

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 19, 2017 3:29 PM
(1019 views)

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??

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 20, 2017 9:10 AM
(993 views)

Highlighted
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 20, 2017 9:38 AM
(988 views)