Can any provide a link to a good statistical overview?
I'm basically trying to find the correlation between known x and known y to predeict y based on a projected x. I thought a good first step would be be to run regression and correlations stats. The only thing I vaguely remember about the output on excel's regression summary output is the closer r squared is to 1, the better.
Given what I'm trying to achieve, it seems as if one of the following stat functions may help me
FORECAST()
LINEST()
SLOPE()
TREND()
Any assistance to allow me to fake my through this until I catch up on statistics would be appreciated.
I'm basically trying to find the correlation between known x and known y to predeict y based on a projected x. I thought a good first step would be be to run regression and correlations stats. The only thing I vaguely remember about the output on excel's regression summary output is the closer r squared is to 1, the better.
Given what I'm trying to achieve, it seems as if one of the following stat functions may help me
FORECAST()
LINEST()
SLOPE()
TREND()
Any assistance to allow me to fake my through this until I catch up on statistics would be appreciated.