Results 1 to 4 of 4

Applying INDIRECT function for Covariance calculus

Threaded View

  1. #1
    Registered User
    Join Date
    12-13-2011
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    68

    Applying INDIRECT function for Covariance calculus

    Hi all,
    I have the following problem. I have to calculate covariance of two arrays and I use the "COVAR" function fot this. But I would like to change arrays by changing starting and ending dates. I suppose I have to insert "INDIRECT" to extract data from dynamic range but I cannot do it. I will appreciate if you can help me. I enclose an example file.

    Regards
    Attached Files Attached Files
    Last edited by geri_n; 12-13-2011 at 09:01 AM.

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