Changes

<div style="font-size:30px">'''INTERCEPT(yArray,xArray)'''</div><br/>

<div style="font-size:30px">'''INTERCEPT (KnownYArray,KnownXArray)'''</div><br/>

*<math>yArray</math> is the set of dependent data  

*<math>KnownYArray</math> is the set of dependent data  

*<math>xArray</math> is the set of independent data.  

*<math>KnownXArray</math> is the set of independent data.  

==Description==

==Description==

*The slope is calculated by:<math> b=\frac{\sum_{i=1}^{n} {(x_{i}-\bar{x})(y_{i}-\bar{y})}} {\sum_{i=1}^{n}{(x_{i}-\bar{x})}^2}</math>.  

*The slope is calculated by:<math> b=\frac{\sum_{i=1}^{n} {(x_{i}-\bar{x})(y_{i}-\bar{y})}} {\sum_{i=1}^{n}{(x_{i}-\bar{x})}^2}</math>.  

*In this formula<math> \bar{x}</math> and<math> \bar{y}</math> are the sample means  AVERAGE of <math> x</math>  and <math> y </math>.  

*In this formula<math> \bar{x}</math> and<math> \bar{y}</math> are the sample means  AVERAGE of <math> x</math>  and <math> y </math>.  

*In <math>INTERCEPT(yArray,xArray)</math>, the arguments can be numbers, names, arrays, or references that contain numbers.

*In <math>INTERCEPT (KnownYArray,KnownXArray)</math>, the arguments can be numbers, names, arrays, or references that contain numbers.

* The arrays  values are  disregarded when it is contains text, logical values or empty cells.  

* The arrays  values are  disregarded when it is contains text, logical values or empty cells.  

*This function will return the result as error when any one of the argument is non-numeric or <math>x</math> and <math>y</math> is having different number of data points and there is no data.

*This function will return the result as error when any one of the argument is non-numeric or <math>x</math> and <math>y</math> is having different number of data points and there is no data.

==ZOS==

==ZOS==

*The syntax is to calculate intercept of the regression line in ZOS is <math>INTERCEPT(yArray,xArray)</math>.

*The syntax is to calculate intercept of the regression line in ZOS is <math>INTERCEPT (KnownYArray,KnownXArray)</math>.

**<math>yArray</math> is the set of dependent data  

**<math>KnownYArray</math> is the set of dependent data  

**<math>xArray</math> is the set of independent data.  

**<math>KnownXArray</math> is the set of independent data.  

*For e.g.,intercept([14,16,19,15.25],[20.1,26,10,26.4])

*For e.g.,intercept([14,16,19,15.25],[20.1,26,10,26.4])

{{#ev:youtube|ltc2nl-pwpk|280|center|Intercept}}

{{#ev:youtube|ltc2nl-pwpk|280|center|Intercept}}