The trendline feature of Excel has been used to fit a line to ... The MS Excel function LINEST carries out an ordinary least squares calculation. ..... The shortest distance between the point and the line is the perpendicular.
From univariate to Multiple Linear Regression (MLR). Least squares ... Step 2 : Use the orthogonal PC-scores as independent variables in a MLR model. Step 3: Calculate ..... www.xlstat.com. – For use in Microsoft Excel.