writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 2:
Line 2: − Line 8:
Line 7: − + − + − + − + − + + + − + − + Line 64:
Line 65: −
no edit summary
*<math> y </math> is the set of dependent values.
*<math> y </math> is the set of dependent values.
*<math> x </math> is the set of independent values.
*<math> x </math> is the set of independent values.
==Description==
==Description==
*The slope of a regression line (b) represents the rate of change in <math> y </math> as ,math> x </math> changes.
*The slope of a regression line (b) represents the rate of change in <math> y </math> as ,math> x </math> changes.
*To find a slope we can use the least squares method.
*To find a slope we can use the least squares method.
*Slope is found by calculating b as the covariance of x and y, divided by the sum of squares (variance) of x.
*Slope is found by calculating b as the co-variance of <math>x</math> and <math>y</math>, divided by the sum of squares (variance) of <math>x</math>.
*In <math>SLOPE(y,x), y </math> is the array of the numeric dependent values and <math> x </math> is the array of the independent values.
*In <math>SLOPE(y,x</math>), <math>y </math> is the array of the numeric dependent values and <math> x </math> is the array of the independent values.
*The arguments can be be either numbers or names, array,constants or references that contain numbers.
*The arguments can be be either numbers or names, array, constants or references that contain numbers.
*Suppose the array contains text,logical values or empty cells, like that values are not considered.
*Suppose the array contains text, logical values or empty cells, like that values are not considered.
*The equation for the slope of the regression line is :<math>b = \frac {\sum (x-\bar{x})(y-\bar{y})} {\sum(x-\bar{x})^2}</math>. where <math>\bar{x}</math> and <math>\bar{y}</math> are the sample mean x and y.
*The equation for the slope of the regression line is
:<math>b = \frac {\sum (x-\bar{x})(y-\bar{y})} {\sum(x-\bar{x})^2}</math>
where <math>\bar{x}</math> and <math>\bar{y}</math> are the sample mean x and y.
*This function will return the result as error when
*This function will return the result as error when
1. Any one of the argument is nonnumeric.
1. Any one of the argument is non-numeric.
2. x and y are empty or that have a different number of data points.
2. <math>x</math> and <math>y</math> are empty or that have a different number of data points.
==Examples==
==Examples==
*[[Manuals/calci/RSQ | RSQ ]]
*[[Manuals/calci/RSQ | RSQ ]]
*[[Manuals/calci/PEARSON | PEARSON ]]
*[[Manuals/calci/PEARSON | PEARSON ]]
==References==
==References==