Hello
I have two variables x and y with a roughly linear relationship and good correlation.
I have been given a y value and I want to get a probability distribution for what the corresponding x might be. How can I do this? Preferably using excel.

The variables x and y are usually lognormal in shape. I have confidence intervals for the linear model if this helps.

Is it monte carlo simulation>?