Home |
Search |
Today's Posts |
#1
|
|||
|
|||
trend line
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 |
#2
|
|||
|
|||
I'm not following what you are asking. Can you be more specific on the data
you have and the trends you want? "Nee" wrote in message ... 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 |
#3
|
|||
|
|||
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 In article , says... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Line in line chart | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Macro - Skipping a line | Excel Worksheet Functions | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Trend Lines (or Linest?) | Excel Worksheet Functions |