I'd appreciate if any one suggest me the formula or the method to calculate residual effect (r) in path analysis using excel sheet or any other software. My variables are 11 quantitative characters taking "yield: as the dependent character. I'm doing a research on "yield performance and character association in mung bean."