Manuals/calci/INTERCEPT

From ZCubes Wiki
Revision as of 21:38, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''INTERCEPT'''('''Y''','''X''') '''Where Y '''is the dependent set of observations or data, and '''Y''' is th...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

INTERCEPT(Y,X)

Where Y is the dependent set of observations or data, and

Y is the independent set of observations or data.


This function calculates  the point at which a line will intersect the y-axis using the  available x-values and y-values.


·         An array contains text, logical values, or empty cells that are ignored; but, the cells with the value zero are included.

·          INTERCEPT shows the error value, when Y and X have a dissimilar number of data points.

Formulas:-

·          The equation to calculate the intercept of the regression line, a, is:

where b is the slope, and is calculated as:

and where x and y are the sample means AVERAGE(Y) and AVERAGE(X).


INTERCEPT


Lets see an example,

INTERCEPT(Y, X)

B                        C

10                     13

8                        11

15                      18

6                        12

12                      10

=INTERCEPT(B2:B6,C2:C6) is 1.2268


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 10 13 1.226804
Row2 8 11
Row3 15 18
Row4 6 12
Row5 12 10
Row6