Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Regression analysis on excel?

  1. Jun 6, 2009 #1
    Does anyone know how to do a regression analysis on excel? I need to find the correlation coefficient and the coefficient of determination and I only know how to do that with a graphing calculator TI 83+
  2. jcsd
  3. Jun 6, 2009 #2

    Math Is Hard

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

  4. Jun 6, 2009 #3


    User Avatar
    Science Advisor
    Homework Helper

    Re: Regression

    Two ways:
    1. use the "=LINEST()" spreadsheet function. For further instructions go to help (F1), then type LINEST.
    2. Excel Analysis ToolPak Add-In (which, if installed, will show up as an item "Data Analysis" under the "Tools" menu) has a built-in regression routine:
    A. If you see Data Analysis as an item under the Tools menu, click on it, then choose regression, then follow instructions on the dialog box that will open up.
    B. If you do not see Data Analysis under Tools menu, then you need to install it. On the menu, click on Tools then Add-Ins; a dialog box will pop up. Check the white square (□) next to the "Analysis ToolPak" item. Click OK, then go to step A above.
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook