I am developing a model using soil moisture to predict missing precipitation.
I correlated soil moisture storage at location A with precipitation at the same location A.
I also correlated precipitation at location A with precipitation at location B. Surprisingly the soil moisture A - precipitation A correlation has higher R and higher RMSE (0.94 and 18.7 mm) whiles precipitation A -precipitation B correlation has lower R and lower RMSE (0.87, 12 mm).
Please, is it possible to get a high R-value with high RMSE and also low R but low RMSE using the same sample size? What could be the reason?