writer
6,694
edits
Changes
Manuals/calci/INTERCEPT (view source)
Revision as of 05:31, 19 December 2013
, 05:31, 19 December 2013no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''INTERCEPT(y,x)'''</div><br/>
*<math>y</math> is the set of dependent data
* <math>x</math> is the set of independent data.
==Description==
*This function is calculating the point where the line is intesecting y-axis using dependent and independent variables.
*Using this function we can find the value of <math> y </math> when <math> x </math> is zero.
*The intercept point is finding using simple linear regression.
*It is fits a straight line through the set of <math> n </math> points in such a way that makes vertical distances between the points of the data set and the fitted line as small as possible.
*Regression methods nearly to the simple ordinary least squares also exist.
*i.e.,The Least Squares method relies on taking partial derivatives with respect to the slope
and intercept which provides a solvable pair of equations called normal equations.
*Suppose there are <math> n </math> data points {y_i, x_i}, where i = 1, 2, …, n.
*To find the equation of the regression line:<math> a=y(bar)-b.x(bar)</math>.
*This equation will give a "best" fit for the data points.
*The "best" means least-squares method. Here b is the slope.
*The slope is calculated by:<math> b=summation(i=1 to n)(x_i-x(bar))(y_i-y(bar))/ summation(i=1 to n)[(x_i-x(bar))]^2.
*In this formula<math> x(bar)</math> and<math> y(bar)</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.
* 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 nonnueric or x and y is having different number of data points and there is no data.
'''INTERCEPT'''('''Y''','''X''')
'''INTERCEPT'''('''Y''','''X''')