Solver, an Excel application to solve the difficulty in applying different univariate linear regression methods

Different fitting methods to carry out a regression analysis could be applied. Ordinary least squares regression (OLS) is the most popular and used because it is easily accessible while the application of other methods generally requires specific statistical software. As consequence, OLS is profusely used without taking account its constrains which could provide erroneous predictions. The use of Solver, a default implemented Excel add-in, could overcome this drawback because it can be used without any knowledge in programming. Solver uses iterative methods to get the parameters which satisfy the imposed condition.