| Line 1: |
Line 1: |
| − | <div style="font-size:30px">'''INTERCEPT(y,x)'''</div><br/> | + | <div style="font-size:30px">'''INTERCEPT(yArray,xArray)'''</div><br/> |
| − | *<math>y</math> is the set of dependent data | + | *<math>yArray</math> is the set of dependent data |
| − | * <math>x</math> is the set of independent data. | + | *<math>xArray</math> is the set of independent data. |
| | | | |
| | ==Description== | | ==Description== |
| Line 16: |
Line 16: |
| | *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(y,x)</math>, the arguments can be numbers, names, arrays, or references that contain numbers. | + | *In <math>INTERCEPT(yArray,xArray)</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 Section== |
| | + | *The syntax is to calculate intercept of the regreesion line in ZOS is <math>INTERCEPT(yArray,xArray)</math>. |
| | + | **<math>yArray</math> is the set of dependent data |
| | + | **<math>xArray</math> is the set of independent data. |
| | | | |
| | ==Examples== | | ==Examples== |