Originally Posted by

**cisaak**
I have 76 observations of X and associated Y. After running an Excel regression, I discover the following:

Correlation coefficient. (0.797)

R^2. 0.630

Standard error. 0.9594

Significance F and p-values. 0.0000 (rounded)

Intercept. 5.4013

X coefficient. (0.2205)

I want to generate a random Y from a known X, i.e., if X is 5, I want a random Y which is influenced by the regression statistics. For example, since X and Y are negatively correlated, I want a higher probability of a larger random Y as X decreases. Logically, I would expect any formula to include the intercept, X coefficient, actual test X, and possibly the correlation coefficient and standard error.

Using two random variables or using a standardized X seems counter-productive because I want the random Y tied a particular value of X.

Hope this better explains my question.