NathanielPrime
New Member
- Joined
- May 23, 2013
- Messages
- 4
I've done several seemingly more advanced tasks in excel, but I wanted to help a local charity out by analyzing the effect of one variable (generally between 0 and 30) on another variable (between 0 and 4). I -know- this should be easy to do. I have tens of thousands of samples, and I have used the CORREL function to show that there is indeed a moderately strong relationship between the two variables.
What I'd really think would help them, though, is being able to say "for every 1 point the first variable increases, the second variable will be .05 lower on average". This has to be possible, yes? I just can't for the life of me figure out/remember how to do it. Anyone know what formula or technique I'm looking for?
What I'd really think would help them, though, is being able to say "for every 1 point the first variable increases, the second variable will be .05 lower on average". This has to be possible, yes? I just can't for the life of me figure out/remember how to do it. Anyone know what formula or technique I'm looking for?