Re: Excluding 0s and blanks from a LINEST function

From: Jerry W. Lewis (post_a_reply_at_no_e-mail.com)
Date: 02/03/05 

Date: Thu, 03 Feb 2005 08:23:55 -0500

No version of LINEST permits missing values. For simple linear
regression, use SLOPE and INTERCEPT. If you need the statistics from
LINEST (or need more numerical stability in pre-2003 versions), see

http://groups-beta.google.com/group/microsoft.public.excel.worksheet.functions/msg/d6a03470e7a1c650

The formula for seb should be
   seb = steyx*SQRT(...

For missing values, you can replace x arrays in the formulas with
IF(ISNUMBER(x)*ISNUMBER(y),x) and y arrays with
IF(ISNUMBER(x)*ISNUMBER(y),y) and array enter (Ctrl-Shift-Enter) the
formulas.

Jerry

Disco wrote:

> Hey Everyone,
>
> I'm trying to get a linear regression function to work and am having a
> lot of difficulty. I need the function to do a linear regression
> (LINEST) of 2 columns of data, but I need it to exclude 0s and blanks
> in the data(this is where I'm stuck). I've tried some of the
> suggestions I've seen here for the SUM and AVERAGE functions but it
> doesn't seem to be working with LINEST. Help :(
>
> - Disco

Relevant Pages

  • Re: interaction terms in regression model
    ... approach to regression than that in some other disciplines. ... centering constants you use (I'm assuming a two-variable model here... ... two linear and one interaction between those) the "significance" of the ... The "failure to center" ...
    (sci.stat.edu)
  • Re: Regression analysis -- how-to?
    ... > were it not for the fact that, the last time I asked an algorithm ... Do you want to learn about regression? ... > (linear, quadratic, logarithmic, exponential, power and inverse) and at ... > least two types of linear correlation coefficient (rank and product ...
    (comp.lang.pascal.delphi.misc)
  • Re: independent variables - ln
    ... of the meaning of "independent variables" in a regression (the lr ... part-timers stop here is because they're *uncomfortable* with statistics ... "independent variables" in a lr (linear regression), ... transformations, and lnis just any one of infinitely many ...
    (sci.stat.math)
  • Re: Ordinal logistic regression vs. multiple regression with ordinal outcome?
    ... preference to ordinary multiple regression for a dichotomous DV? ... One might try to use OLS regression with categorical DVs. ... predications, as much as that the DV is upper- and lower-censored, ... Could happen if you were modeling counts on a linear scale. ...
    (sci.stat.consult)
  • Re: When and how to do transformation in multiple regression
    ... >> I am doing a project of multiple regression. ... >> regression, how to examine whether the data are linear or not, when I ... >> should do the transformation and which technique I should choose. ... You do this by raising x to a power ...
    (sci.stat.math)