Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I use excel to find y = f(x,z)?
Can I use excel to find y = f(x,z)? I have data for y1-y2 ,x1 -x12 and z1 -z12.
Thanks, Anne |
#2
|
|||
|
|||
I don't understand what you are saying here. what doex x12/z12 stand for?. It seems as though you are trying to find the solution for a formula whose dependance is on x and z? Please provide a sample problem. Thanks, Derek Ane wrote: Can I use excel to find y = f(x,z)? I have data for y1-y2 ,x1 -x12 and z1 -z12. Thanks, Anne |
#3
|
|||
|
|||
Excel will permit linear regression (least squares fit) for multiple
variables. sk Ane wrote: Can I use excel to find y = f(x,z)? I have data for y1-y2 ,x1 -x12 and z1 -z12. Thanks, Anne |
#4
|
|||
|
|||
Anne Your query could refer to two things :- If you are referring to the distance between two points given their 3D coordinates then yes you can do it like so :- y (distance) = ((x1 - x2)^2 + (y1 - y2)^2 + (z1 - z2)^2)^0.5 If this is not what you are wanting to do and it is something close to what Derek suggested then again you should be able to get the solution for 'y' given the relationship between x and z - which you have not explained. You may want to do that if you want better explanation on this count. Best regards Deepak Agarwal -- agarwaldvk ------------------------------------------------------------------------ agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345 View this thread: http://www.excelforum.com/showthread...hreadid=388538 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there an equal fxn for 'InStr' in excel. Not Find or Search | Excel Worksheet Functions | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Excel startup switches | Excel Discussion (Misc queries) | |||
Linking Excel files -- I cannot find an answer anywhere. | Excel Discussion (Misc queries) | |||
Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) |