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?
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?
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
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 .
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.