शुरू करेंमुफ़्त में शुरू करें

Compute the correlation coefficient

How do the monthly returns of ABC and the one of its benchmark move together?

To answer this question, you should compute the correlation coefficient of the two series of historical returns. Such a coefficient is also called "Pearson correlation coefficient", named after the English mathematician Karl Pearson.

Use both the functions CORREL() and PEARSON() to compute the correlation coefficient. They require two arguments, the series of historical returns for stock ABC and the series of historical returns for the benchmark.

यह अभ्यास पाठ्यक्रम का हिस्सा है

Google Sheets में Financial Analytics

पाठ्यक्रम देखें

अभ्यास निर्देश

  • In G2, find the correlation coefficient using the function CORREL().

  • In H2, do the same using the function PEARSON().

इंटरैक्टिव व्यावहारिक अभ्यास

हमारे इंटरैक्टिव अभ्यासों में से किसी एक के साथ सिद्धांत को व्यवहार में बदलें

अभ्यास शुरू करें