Interesting post about the correlation trend. And to further the discussion....
Quick question for anyone in the know...
Excel has a forcast calculation based on linear regression. To use this function I believe one would use the current mean pair ratio as the value you want to base off of to predict a future value, and then plug in the range of the correlations and the range of the pair ratios to get a predictive value?
Anyone else doing this or have experience with excel and statistics to confirm I am using the right data points and ranges etc.
Thanks.
Quick question for anyone in the know...
Excel has a forcast calculation based on linear regression. To use this function I believe one would use the current mean pair ratio as the value you want to base off of to predict a future value, and then plug in the range of the correlations and the range of the pair ratios to get a predictive value?
Anyone else doing this or have experience with excel and statistics to confirm I am using the right data points and ranges etc.
Thanks.
