The RegressWgt01.xlsx Model

Multiple linear weighted asymmetric regression

View the model

Download the model

Given a Dependent variable column, call it Y, and

one or more columns of explanatory variables, call them X,

where each row is an observation,

The output is the set of regression coefficients, COEF,

for the model:

Y(i) = COEF0 + COEF(1)*X(i,1) + COEF(2)*X(i,2)+... + error(i)

User can specify:

a) weight applied to error of each observation,

b) a different weight for the up error as opposed to the down error, and

c) the Norm to be used, e.g., 1 for absolute error to give less weight to outliers,

or 2 for squared error to give more weight to outliers

Keywords:

Forecasting | Regression | Weighted Regression | Assymetric Regression | L1 norm | Least Squares |