writer
6,694
edits
Changes
Manuals/calci/INTERCEPT (view source)
Revision as of 05:51, 19 December 2013
, 05:51, 19 December 2013→Description
*This equation will give a "best" fit for the data points.
*This equation will give a "best" fit for the data points.
*The "best" means least-squares method. Here b is the slope.
*The "best" means least-squares method. Here b is the slope.
*The slope is calculated by:<math> b=\sum i=1 to n {(x_{i}-\bar(x))(y_{i}-\bar(y))}/ \ sum i=1 to n{(x_{i}-bar(x))}^2.
*The slope is calculated by:<math> b=\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(y,x)</math> , the arguments can be numbers, names, arrays, or references that contain numbers.