Help using Base SAS procedures

weak results

Reply
Contributor
Posts: 60

weak results

Hi

I am running a regression where I get weak results, I know there should be relationship there but the OLS is not picking it up in my data.

Unfortunately I have some negative observations so I cant use natural logarithm to strengthen these results...

Does anyone else know what I could do to my observations to strengthen the r squared?

PROC Star
Posts: 7,474

Re: weak results

Posted in reply to spraynardz90

Have you looked at the distributions of your various variables?   Is the relationship linear?  Are the variables normally distributed (log is NOT the only transformation)?  What is your N?

Respected Advisor
Posts: 4,925

Re: weak results

Posted in reply to spraynardz90

As a first step, you should look at your data, make some graphs. This should help you answer Art's questions. Then, keep with your hypothesis "I know there should be a relationship there" and look for outliers. Redo your regression with only the variables that form the basis of your hypothesis but use the ROBUSTREG procedure. It should detect any obvious outliers.

Another possibility you should consider is that the relationship that you suspect might be present only in a subset of the data or that it takes a different form (intercept, slope) in different subsets.

Good luck.

PG

PG
Super User
Posts: 10,035

Re: weak results

Posted in reply to spraynardz90

In addition, Check the COOK's distance to see which observation is highly influencing your model.

And check the independant  variables whether there are som multi-colinearity .

Ask a Question
Discussion stats
  • 3 replies
  • 186 views
  • 3 likes
  • 4 in conversation