MULTIPLE REGRESSION
The least square regression equation discussed above was based on the assumption that total cost was determined by only one activity based variable. However, other variables are likely to affect labour costs such as labour hours, material costs, machine hours, etc. These may have an effect on labour costs.
The equation for the simple regression can be expanded to include more than one independent variable as shown below:
Y = a + b_{1}X_{1 }+ b_{2} X_{2} + b_{3} X_{3} +………+b_{n} X_{n}
For two independent variables, the function will be of the form:
Y = a + b_{1}X_{1 }+ b_{2} X_{2}
The normal equations can be given by:∑y = na + b_{1} ∑X_{1} + b_{2}∑x_{2}∑X_{1}Y = a∑x_{1} + b_{1}∑X_{12} + b_{2} ∑X_{1} ∑X_{2}∑X_{2} Y = a∑x_{2} + b_{1}∑ X 1∑X_{2} +b_{2} ∑X_{2} Normally computers are used for the solution of multiple regression.