Prediciting Values (z) from given data set (x,y,z)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please can someone help!!!
I have the following "known" data (x,y,z) which I am able to plot a bubble
chart from. However I want to be able to predicit the "z" value given new x
and y values based on a trend- is this possible in excel? (trend lines seem
to only be linear i.e. between x and y)- or any idea how I can do this?

Data Set (x,y,z):
96.0%, 95.3%, 2.911
94.4%, 98.0%, 2.297
96.3%, 93.8%, 2.631
96.9%, 93.2%, 4.697
97.1%, 95.3%, 1.073
96.4%, 99.2%, 0.808
96.3%, 94.0%, 1.292
96.7%, 97.1%, 1.414
97.1%, 96.0%, 1.153

I would like to predict the z values for:
91.0%, 83.0%
87.0%, 83.0%
98.0%, 96.0%
90.0%, 95.0%
98.0%, 99.0%
98.0%, 96.0%
98.0%, 97.0%

Thanks
 
may depend on your specific requirements, but the LINEST workshee
function can regress against multiple independent variables. Will tha
work for you
 
Back
Top