define "Coefficient" in Excel's regression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in excel's regression there is a row that is titled "coeffidcient" what is that refering to exactly. I know it is the intercept, but what does that mean?
 
Ty -
in excel's regression there is a row that is titled "coeffidcient" what is
Click to expand...
that refering to exactly. I know it is the intercept, but what does that
mean? <

The Regression tool uses Excel's LINEST worksheet function. The Help for
LINEST says:
"The equation for the line is:

y = mx + b or

y = m1x1 + m2x2 + ... + b (if there are multiple ranges of x-values)

where the dependent y-value is a function of the independent x-values. The
m-values are coefficients corresponding to each x-value, and b is a constant
value."

In the Regression tool output, the "Coefficient" column contains b, m1, m2,
....

See Help for LINEST for more details.

- Mike Middleton, www.usfca.edu/~middleton
 
Back
Top