How to Find Residual Value in Multiple Linear Regression using Excel

Residual values in linear regression analysis can be used to test for normality. In addition, the heteroscedasticity test also requires the variance value of the residual. Therefore, the residual value is important in the linear regression assumption test with the Ordinary Least Square (OLS) method.