writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + Line 16:
Line 16: − + − + − + − +
no edit summary
<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}}