+ Reply to Thread
Results 1 to 3 of 3

X and Y avlue on scatter plot

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    2

    X and Y avlue on scatter plot

    hi,
    let me know how to calculate the extrapolite the value on linear graph? i m able to calculate the x and y at 0, but i wanted to know if the value at 20.9.linear.xlsx

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: X and Y avlue on scatter plot

    The chart is not going to do it automatically for you.

    If this were me, I would use the LINEST() function to get the slope and intercept for my function (y=mx+b). Then you can use this formula in the spreadsheet to calculate y at whatever x you want.

  3. #3
    Registered User
    Join Date
    10-23-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: X and Y avlue on scatter plot

    thnx for ur reply.
    can u pls make this in the excel sheet? i m so week in maths and excel plsss

+ 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