LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Paula C
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I have a data table display cell names rather than values? raortiz99 Excel Worksheet Functions 1 November 9th 05 04:11 PM
How do I clear data values wthout losing the formulas? genaksdal Excel Worksheet Functions 1 November 8th 05 05:48 PM
Saving data in a worksheet within a workbook Homeuser Excel Discussion (Misc queries) 2 August 21st 05 10:49 PM
List of different values in data area balcovja Excel Discussion (Misc queries) 1 August 15th 05 09:04 AM
Selecting data from a list based on entered values GrantM Excel Discussion (Misc queries) 1 December 20th 04 10:59 AM


All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"