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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate a point 3
Trend Lines 1
Trend lines in charts under Excel 1
One bar line with two trend lines 1
To find equation for two sets of non contiguous data 2
VBA looping 1
Calulating a point on a line 2
trend line equations 2

Back
Top