Databases Reference
In-Depth Information
gical values are not included in the calculation, but cells with zero values
are included.
Once the linear regression line has been calculated, this function returns
the x-intercept of the line (represented by b in the equation y = ax + b).
See also the other LinRegXXX functions.
LinRegPoint (
x slice numeric expression
,
set
,
y numeric expression
[,
x nu-
meric expression
])
Returns: number
Standard
This function returns the value of the calculated linear regression line y =
ax + b for a particular value of x. For the linear equation y = ax + b, which
will be determined from a set of y and x values, the values of the
y nu-
meric expression
are evaluated to get the y values. If the
x numeric ex-
pression
is present, then it is evaluated over the
set
to get the values of
the x axis. Otherwise, the cells formed by the
set
are evaluated within the
current context and their values are used as the x values. Empty cells
and cells containing text or logical values are not included in the calcula-
tion, but cells with zero values are included.
Once the linear regression line has been calculated, the value of y = ax +
b is calculated for the value given in the
x slice numeric expression
and
is returned.
LinRegR2 (
set
,
y numeric expression
[,
x numeric expression
])
Returns:
number Standard
This function returns the statistical R
2
variance of the given data
points to the linear regression line calculated from them. For the lin-
ear equation y = ax + b, which will be determined over some set of y
and x, the values of the
y numeric expression
are evaluated to get
the y values. If the
x numeric expression
is present, then it is evalu-
ated over the
set
to get the values of the x axis. Otherwise, the cells
formed by the
set
are evaluated within the current context and their
values are used as the x values. Empty cells and cells containing
text or logical values are not included in the calculation, but cells
with zero values are included.
Search WWH ::
Custom Search