how to calculate standard error coefficient?
STDEV. S(errors) = (SQRT(1 minus R-squared)) x STDEV. S(Y). So, if you know the standard deviation of Y, and you know the correlation between Y and X, you can figure out what the standard deviation of the errors would be be if you regressed Y on X.