Assume $X,Y,Z$ are three variables over a set of data (say, a finite set of data to avoid discussions of convergence). Suppose we know the Pearson correlation coefficient $r_{X,Y}$ and $r_{Y,Z}$: given these data, what bounds (ideally sharp) can we put on $r_{X,Z}$?
If I am not mistaken, the question is equivalent to the following: for a positive semidefinite matrix with a diagonal of $1$, if we know the coefficients $(i,j)$ and $(j,k)$ in the matrix, what (ideally sharp) bounds can we put on the coefficient $(i,k)$?
Surely this is a classical problem and has been considered before, but I don't know what terms to search for.