trend line

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

Guest

1) can we create a trend line from equation which has 2 variables and 1
respond ? and How? (Ex. Y= 1.2+5A+3B)

2) In case that we have two trend lines ( from X1 with Y and X2 with Y) and
we want to create the average line between those two lines, what should we do?

Thank you
 
I'm not following what you are asking. Can you be more specific on the data
you have and the trends you want?
 
Use the LINEST function for a regression of y=f(x1,x2). See the XL
help for LINEST for more. It includes an example of a multi-variate
regression.

You can then use the coefficients to plot the data as you see fit.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top