Calculation of correlation

[Tanu]

Can anyone help me to find out statistically significant correlation in sales volume growth between countries, between different types of products with the GDP or industrial growth, etc. It wud be great if u could provide me sample spreadsheet.


Thanks

 

[Tanu]

pls someone reply me, its bit urgent...tks a lot

 

[Hui]

Have a look at the Correl function

=Correl(Range 1, Range 2)

 

[Tanu]

Thank u. Can u brief little further on correlation pls? How it works? Why it is important to calculate statistically significant correlation? How to interprete it?

 

[Meedan]

Please go through first 4 websites.


http://lmgtfy.com/?q=what+is+excel+correlation