Testing linear regression to predict the influence of macro-scale parameters on micr-scale water quality parameters