+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Paula C
    Guest

    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

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,922
    may depend on your specific requirements, but the LINEST worksheet function can regress against multiple independent variables. Will that work for you?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1