Manuals/calci/SLOPE

From ZCubes Wiki
Revision as of 20:44, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font face="Arial, sans-serif"><font size="2">'''SLOPE'''</font></font><font face="Arial, sans-serif"><font size="2">...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

SLOPE(ky's,kx's)

Where ky's   is an array or cell range of numeric dependent data points and Kx's   is the set of independent data points.

 It calculates the slope of the linear regression line through data points in ky's and kx's.
The equation for the slope of the regression line is:



where x and y are the sample means AVERAGE(kx’s) and AVERAGE(ky’s).

SLOPE

 

=SLOPE(B2:B8,C2:C8) is 0.3993

Syntax
Remarks
Examples
Description
Column1 Column2 Column3
Column4
Row1 5 16 0.3993
Row2 6 12
Row3 9 8
Row4 10 5
Row5 18 17
rOW6 4 9
Row7 3 9
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/SLOPE&oldid=596"