The add-in Adequate contains a wizard that allows you to determine single statistics of two ranges.

You insert the y-known-range and the x-known range and choose which statistics you want to see.

Single Statistics wizard in HJGSoft Adequate
Single Statistics wizard in HJGSoft Adequate
Example of use Single Statistics function
Example of use Single Statistics function