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
- :
- Discussions
- :
- Just love it when R2 comes out negative

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
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 19, 2016 10:58 AM
(3195 views)

Hi all,

Does anyone know what JMP does in the bivariate fit platform when calculating the “fit measured on original scale”? I just got a negative R^{2}. Does it estimate a model without the intercept?

I know the data is peculiar and when using the log-log transformation I have many missing observations but still, something must be going on....

Attached is the data table with a script to reproduce the results I got.

Thanks,

Ron

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 23, 2016 9:35 AM
(5545 views)

Solution

Two modes, one fit to the original data and the other to the log-log transformed data, are different models. Anti-logs won't make summary of fit statistics from the log linear model identical to the results from the original linear fit.

14 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 22, 2016 12:10 PM
(2773 views)

Your R Square is actually positive, but it is close to zero. When this happens, adjusted R square maybe slightly negative. This is how adjusted R square formula is built to work. In fact, if R Square is <k/(n-1) , R Square Adj will be negative.

In your case, a negative R Square Adj. will occur when R Square <0.0013568. What a negative R square Adj. means is that the model terms do not help predict the response.

Does it estimate a model without the intercept?

No, it includes an intercept by default.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 22, 2016 12:32 PM
(2773 views)

I would add that what a negative R Square Adj means is that the portion of variability of the predictors do not help predict the expected response. Thus, the R Square should not be used exclusively as the iron-fist to judge a model's anticipated performance. But it is also good for the R Square and the associated R Square Adj. to be positive.

Jenkins Macedo

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 22, 2016 4:45 PM
(2773 views)

thanks for the comment jiancao

I must be missing something. where exactly does it say adjusted in the output?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 23, 2016 4:15 AM
(2773 views)

R Square Adj is the original R^2 adjusted for # of model terms in regression

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 23, 2016 4:27 AM
(2773 views)

sorry for the misunderstanding. i was referring to the R2 marked below.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 23, 2016 6:16 AM
(2773 views)

**Residuals Speed** from the model fit (Notice that that it is calculated by taking Exp to back transform to the original scale). Then I calculated two Sum of Squares columns: **SS of Total** (SST) and **SS of Error** (SSE), for the R Square formula used by JMP, which is 1- SSE/SST=1- 164569257/115933657=-0.41951234. So, the back transformation gives rise to a negative R Square.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 23, 2016 7:24 AM
(2773 views)

Thank you jiancao,

that did reproduce the negative figure. yet i would expect the figure to be identical to the outcome of fitting a line to the same data as in the picture.

but if i just run this with a fit line i do not get the same R2.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 23, 2016 9:35 AM
(5546 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 23, 2016 9:40 AM
(2773 views)

I see, so how can i make use of the anti-log results? what are they comparable to?