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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 12:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com