Covariance calculation like excel formula

Hi When I calculate covariance in excel it gives me a number but in matlab it gives me a matrix,why is that?and how can I get the covariance amount like excel? thanks

Answer 1

[Pawel Jastrzebski]

Given the code:

A = randi([18 22], 20,1)
B = randi([15 25], 20,1)

C = cov(A,B)

This is the outcome that you'll get:

>> C

C =

      1.6947   -0.2842
     -0.2842    6.8842

The same data in excel produces the following:

So you get the same values. Read up the documentation for covariance. This is why you get a matrix of the results:

[amir khalighi]

very complete , thank you