Changes

Jump to navigation Jump to search
no edit summary
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==
writer
6,694

edits

Navigation menu