View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Cece Cece is offline
external usenet poster
 
Posts: 2
Default Can Excel describe a function in two variables: y = f(x,z)

No, I have no function yet, just data... I have over 100 ordered triples
(x,y,z) and would like to fit an equation to this data. Suggestions?
Thanks,
Cece

"Bernard Liengme" wrote:

Not unless you have a starting function. For example if y=ax^2 - bz^3 we
could use Solver to find the best fit values for a and b
Tell us more
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cece" wrote in message
...
I have two independent variables (inputs: x, z) and one output: y. I have
the data for all three variables in columns in an Excel 2000 worksheet.
Can
Excel graph and fit an equation to this data? I want an equation of the
form
y = f(x,z). Thanks!