• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excell/Regression Question

N

NakaNaka

Diamond Member
Hey. I'm doing a project for stats on baseball players and predicting their perfomance based on the last two years performance. I'm using OPS (OBP+SLG) .. When I run it using only the last year, I get fine results. When I do two years, I get my F test out ot wack and #NUM signs all over the place. I get an RSquared of 1 (which is impossible in real world data basically) and an adjusted R squared of 65,000 something which is most certainly impossible. Some how, the two years are conflicting. Any reason why? Thanks

-Phil
 
Sounds like a missing decimal point or you're multiplying by 100 when it should be like 10. It's hard to say without you posting the cell formulas for us to look at.

techfuzz
 
I've ran regressions using the 2001 stats and then the 2002 stats seperatly. both work fine. it when combined that there is a problem.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top