So let's say I have two random variables, $X \sim (0,1)$ and $Y \sim (0,1)$. If I want to make a random variable $Z$, a linear combination of $aX + bY$ such that $\text{Corr}(Y,Z)$ is always equal to 0.20, this would've been my intuition and approach:
$$\text{Corr}(YZ) = \text{Cov}(Y,Z)/ \sqrt{\text{var}(y)* \text{var}(z)}$$
where $\text{var}(y) = \text{var}(z) = 1$ so $\text{Corr}(Y,Z)/1 = \text{Cov}(Y,Z)$.
Then:
$$\begin{array}{ccc} \text{Cov}(Y,Z) &=& \text{Cov}(Y, aX + bY) \\ &=& \text{Cov}(Y, aX) + \text{Cov}(Y, bY) \\ &=& a\text{Cov}(Y,X) + b\text{Cov}(Y,Y) \\ &=& a\text{Cov}(Y,X) + b*Var(Y) \\ &=& a\text{Cov}(Y,X) + b = 0.20 \end{array}$$
First question: So I know $\text{Cov}(Y,X) = \text{Cov}(X,Y)$. Would the covariance between these two variables essentially be 0?
Assuming it's 0, then to answer the original question, we would simply need to multiply Y with 0.20 such that $\text{Corr}(Y,Z) = 0.20$.
I then went on Excel, did a RNG of 25k numbers for X~(0,1), Y~(0,1), Z = X + 0.2Y. When I took the \text{Corr}elation, the results were a bit puzzling:
Cor(X,Y) = 0.7...?
Cor(Y, X + 0.2Y) = 0.2
I probably made a lot of wrong assumptions, can someone help me point out what my misconception is? Is it incorrect to say "simply multiply Y by 0.20 and the resulting relationship of $\text{Corr}(aX + by,y)$ will always be equal to 0.20?