+ Reply to Thread
Results 1 to 7 of 7

Extreme differences in result using covariance.s and using covariance by data analysis

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    Bergen, Norway
    MS-Off Ver
    Excel 2010
    Posts
    3

    Extreme differences in result using covariance.s and using covariance by data analysis

    Differences in covariances.png

    Extreme differences in result using covariance.s and using covariance by data analysis (add inn).

    Why is the result so different?

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186

    Re: Extreme differences in result using covariance.s and using covariance by data analysis

    Hi,
    in the nicest possible way, I can't be bothered to type in the values and try and work out what you might be doing.
    So if you want some help : attach a spreadsheet


    click on the * Add Reputation if this was useful or entertaining.

  3. #3
    Registered User
    Join Date
    09-19-2013
    Location
    Bergen, Norway
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Extreme differences in result using covariance.s and using covariance by data analysis

    Thanks for your reply. I don't know how to attach pictures(spreadsheet) to show in in this thread, but at the top of my post, I have made a link where i show the problem in a spreadsheet. Does that help you? Or can you tell me how I can attach spreadsheet on a good way?

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,801

    Re: Extreme differences in result using covariance.s and using covariance by data analysis

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  5. #5
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186

    Re: Extreme differences in result using covariance.s and using covariance by data analysis

    When you hit REPLY then do GO ADVANCED the attachment option is there. The first step is to upload and then attach it to the email.

  6. #6
    Registered User
    Join Date
    09-19-2013
    Location
    Bergen, Norway
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Extreme differences in result using covariance.s and using covariance by data analysis

    COV differences.xlsx

    Does this help you guys to understand my problem?

  7. #7
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Extreme differences in result using covariance.s and using covariance by data analysis

    The Data Analysis tool lists the x,y covariance as -11.33 (same result using older COVAR function in Excel). The 44.25 is the x,x covariance

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. COVARIANCE.S to build a covariance matrix
    By steve.lorimer in forum Excel General
    Replies: 6
    Last Post: 06-05-2011, 09:37 AM
  2. Covariance Matrix in Data Analysis tool
    By andrewc in forum Excel General
    Replies: 0
    Last Post: 12-29-2009, 10:30 AM
  3. help please covariance
    By uncina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2009, 01:23 PM
  4. Problem with COVARIANCE option in Data Analysis
    By andrewc in forum Excel General
    Replies: 1
    Last Post: 10-24-2008, 11:12 AM
  5. [SOLVED] Covariance for 3D coordinates
    By baluleslie@yahoo.co.in in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-24-2006, 03:30 AM

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