# residual value

## Definition and Purpose of Determining Residual Values in Linear Regression Analysis

In linear regression analysis, residual values play a crucial role. The residual value is the difference between the actual and predicted Y values. The actual Y value can be obtained from observations or samples of the dependent variable.

## Create Residual and Y Predicted in Excel

Residual and predicted Y have an important role in linear regression analysis using the Ordinary Least Square (OLS) method. Several OLS linear regression method assumptions were conducted to test the residuals, including normally distributed residuals and constant residual variance.

## How to Calculate Y Predicted and Residual Values in Simple Linear Regression

The residual value in linear regression analysis needs to be calculated first before calculating the variance. In addition, the linear regression of the ordinary least square method must pass the assumption test that the residuals must be normally distributed. However, before calculating the residual value, you must first calculate the predicted Y value. Therefore, we …