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 | Excel | WhatsBest | What'sBest | What'sBest! | What's Best | Prediction |