Regression confusion

  • Thread starter Thread starter twm145
  • Start date Start date
T

twm145

How is regression analysis used in excel to find the coefficients, a,b,c of
an equation of the form z=ax+by+cxy?
I know it's possible but ive only got experience with single variable
polynomials.

Thanks for the help!!

Tom Morris
 
Tom Morris -
How is regression analysis used in excel to find the coefficients, a,b,c
Click to expand...
of an equation of the form z=ax+by+cxy? <

Arrange your data in four columns, with x, y, and x*y in adjacent columns.
(You may need to create the new x*y column.)

If you use the Regression tool, the Y range is what you're calling z, and
the X range contains the x, y, and x*y data.

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