1. Not finding help here? Sign up for a free 30min tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

How to draw a correlation function in excel

  1. Apr 14, 2010 #1
    1. The problem statement, all variables and given/known data
    For my homework i have to compute a correlation function in excel from available data. Data goes somewhat like this: 1 xxx yyy
    2 xxx yyy
    3 xxx yyy
    I now I have to calculate the correlation at a given point (1,2,3,4,...) but all my atempts sofar turnedout to be wrong.


    2. Relevant equations

    It is statet in the "hint" section of the homework that you should use functions CORREL and INDIRECT.



    3. The attempt at a solution
     
  2. jcsd
  3. Apr 14, 2010 #2

    berkeman

    User Avatar

    Staff: Mentor

    Welcome to the PF. So what does Excel Help say about those functions? That would seem to be a good place to start.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: How to draw a correlation function in excel
Loading...