Manuals/calci/INTERCEPT

From ZCubes Wiki
Revision as of 01:07, 19 December 2013 by Devika (talk | contribs)
Jump to navigation Jump to search
INTERCEPT(y,x)


  • is the set of dependent data
  • 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 when is zero.
  • The intercept point is finding using simple linear regression.
  • It is fits a straight line through the set of 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 data points , where i = 1, 2, …, n.
  • To find the equation of the regression line:.
  • 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:.
  • In this formula and are the sample means AVERAGE of and .
  • In , 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.

Examples