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

[keikol]

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?

[tony h]

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

[keikol]

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?

[Pepe Le Mokko]

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

[tony h]

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.

[keikol]

COV differences.xlsx

Does this help you guys to understand my problem?

[Izandol]

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