Microsoft Office Tutorials and References
In Depth Information
SKEW
Is the set of data points or values.
KNOWN_Y’S
Is the set of values that correspond to the known_y values. Inter vals
of time are often the known_x value.
KNOWN_X’S
The equation for RSQ is
Figure 11.41
The closer r 2 is to one,
the better the
regression line fits your data.
SKE SKEW returns the skewness of a distribution.
=SKEW(number1,number2,...)
Skewness refers to the asymmetr y of a distribution around its mean. Positive skewness
indicates a distribution with an asymmetric tail extending towards more positive values. Negative
skewness indicates a distribution with an asymmetric tail extending towards more negative
values. Figure 11.42 illustrates the SKEW function.
You can specify up to 30 arguments for the SKEW function. Arguments
can be cell references, arrays, or range names. Blank cells or cells that
contain a text, or logical values are ignored. Cells containing zero (0)
are included in the calculation.
NUMBER N
The equation for SKEW is
Search JabSto ::




Custom Search