Rsqrd(y,x) in Excel

Discussion in 'Technical Analysis' started by bpatrick, Dec 11, 2005.

  1. bpatrick

    bpatrick

    Does anyone know the exact Excel formula that gives Rsquared ?
    I have R-squared formulas that give different answers than Excel gives.
    Thanks.
     
    #1     Dec 11, 2005
    Share
  2. times3

    times3

    =rsq(X:X,Y:Y)
     
    #2     Dec 11, 2005
    Share
  3. bpatrick

    bpatrick

    I'm actually looking for the complete formula.
    I've already done the rsq(a1:a5,b1:b5)
     
    #3     Dec 11, 2005
    Share
  4. late apex

    late apex

    If you go to Help - Contents and Index, then look up RSQ under the Index tab, it'll give you the exact formula.
     
    #4     Dec 11, 2005
    Share
  5. bpatrick

    bpatrick

    Thanks Late Apex. I have that formula but maybe I'm doing something wrong. I'll have to check.
    Thanks.
     
    #5     Dec 11, 2005
    Share