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

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

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

may depend on your specific requirements, but the LINEST worksheet
function can regress against multiple independent variables. Will that
work for you?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=484864