# Re: Excluding 0s and blanks from a LINEST function

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

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)