--- title: Correlation Coefficient | Formula, Example, Analysis, Calculator description: Correlation coefficients can come in different types, but the most commonly used is known as the Pearson correlation (r). Click to know more. --- [![Carbon collective](https://www.carboncollectiveinvesting.com/hubfs/raw_assets/public/CarbonCollective_August2021%20copy/images/carbon-collective-green-investing-logo-white.4f6047d4.svg "Carbon collective")](https://www.carboncollectiveinvesting.com/) - About - Employers - [Sustainable 401(k)](https://www.carboncollectiveinvesting.com/401k) - [401(k) Comparison Tool](https://www.carboncollectiveinvesting.com/401k/plan-comparison-tool) - Individuals - [FAQ](https://www.carboncollective.co/en/knowledge/faqs) - [ETF](https://www.carboncollectivefunds.com/) - Learn - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - [Blog](https://blog.carboncollective.co/) - [Tools](https://tools.carboncollective.co/calculator/) - Log in - [Carbon Collective](https://app.carboncollective.co) - [Altruist](https://app.altruist.com) [Talk to a human](https://ask.carboncollective.co/f4o5dylkg) [Sign up](https://app.carboncollective.co/sign-up) [Log In](http://app.carboncollective.co/) [![Carbon collective](https://www.carboncollectiveinvesting.com/hubfs/raw_assets/public/CarbonCollective_August2021%20copy/images/carbon-collective-green-investing-logo.53b28bee.svg "Carbon collective")](https://www.carboncollectiveinvesting.com/) - About - Employers - [Sustainable 401(k)](https://www.carboncollectiveinvesting.com/401k) - [401(k) Comparison Tool](https://www.carboncollectiveinvesting.com/401k/plan-comparison-tool) - Individuals - [FAQ](https://www.carboncollective.co/en/knowledge/faqs) - [ETF](https://www.carboncollectivefunds.com/) - Learn - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - [Blog](https://blog.carboncollective.co/) - [Tools](https://tools.carboncollective.co/calculator/) - Log in - [Carbon Collective](https://app.carboncollective.co) - [Altruist](https://app.altruist.com) [Talk to a human](https://ask.carboncollective.co/f4o5dylkg) [Sign up](https://app.carboncollective.co/sign-up) [Log In](http://app.carboncollective.co/) **[Home](https://www.carboncollectiveinvesting.com/) > [Sustainable Investing](https://www.carboncollectiveinvesting.com/sustainable-investing) >** Correlation Coefficient # Correlation Coefficient ![](https://www.carboncollectiveinvesting.com/hubfs/Brooke%20Tomasetti.png) Written by Brooke Tomasetti | Reviewed by [Subject Matter Experts](https://www.carboncollectiveinvesting.com/subject-matter-experts) Updated on October 1, 2024 Fact Checked Why Trust Carbon Collective? ### Table of Contents The correlation coefficient, also called the Pearson correlation, is a metric that reflects the relationship between two numbers. Numbers moving consistently at the same time have a positive correlation, resulting in a positive Correlation Coefficient. Meanwhile, those that move in opposite directions have a negative correlation, producing a negative correlation coefficient. The correlation coefficient comes in handy when analyzing many different types of data but especially [economic](https://www.carboncollectiveinvesting.com/sustainable-investing/primary-economic-activity/) and finance. Although patterns usually go unmonitored by small businesses, larger entities such as investment banks and even the U.S. Federal Reserve use the Correlation Coefficient to help boost their understanding of market trends and make calculated predictions. In a move to rouse the U.S. economy post-2008 financial crisis, the Federal Reserve reduced [interest rates](https://www.carboncollectiveinvesting.com/sustainable-investing/interest-rate-parity/) and ended up driving the country’s unemployment rate down. This proves that the Fed’s interest rate is positively correlated with the unemployment rate, or that both values have a positive Correlation Coefficient. ## Correlation Coefficient Formula ![5-Apr-22-2022-06-46-19-65-AM](https://www.carboncollectiveinvesting.com/hs-fs/hubfs/5-Apr-22-2022-06-46-19-65-AM.png?width=657&name=5-Apr-22-2022-06-46-19-65-AM.png) - ρ = Pearson product-moment correlation coefficient - Cov(x, y) = covariance of variables x and y - σx = standard deviation of x - σy = standard deviation of y Manually calculating the correlation coefficient of two values can be tedious, especially when working with large data sets. There are, however, several tools that may be used to automate the process and save time. Most commonly, you would use Excel to calculate the correlation coefficient. A correlation coefficient of exactly 1 indicates a perfect positive relationship between two variables. That means for every positive increase in one variable, there is a corresponding positive increase in the other. If the correlational coefficient between these two variables is -1.0, it means there is a perfect negative relationship between them, pointing out that the variables are moving in contrasting directions. In such a scenario, a positive increase in one variable comes with a decrease in the other. A Correlational Coefficient of 0 between 2 variables proves their relationship is nonlinear. The strength of the association between two variables can be quantified by the correlation coefficient. For instance, a value of 0.2 indicates a positive yet weak and likely negligible relationship. In certain fields, analysts only give importance to a correlation coefficient higher than 0.8. On the other hand, a value equal to or higher than 0.9, indicates a very strong relationship between the compared variables. ## Correlation Coefficient Example Investor Ethan’s portfolio mainly watches the performance of Tech A, a giant tech company, but he is considering adding the stock of another tech giant, Tech B. However, he wants to check the correlation between the two companies’ stocks to make sure that adding Tech B to his portfolio won’t raise his level of systematic risk. To calculate the coefficient, Ethan researches the stock prices of each of the two companies over the last five-year period. Based on these values, what is the correlation coefficient between the two companies’ stock prices? ![1-Apr-26-2022-04-45-53-47-AM](https://www.carboncollectiveinvesting.com/hs-fs/hubfs/1-Apr-26-2022-04-45-53-47-AM.png?width=1436&name=1-Apr-26-2022-04-45-53-47-AM.png) We’re not going to actually use the correlation coefficient formula because it is longer and more time consuming than is necessary. Instead, we’ll use a simple Excel spreadsheet which will calculate it for us. Excel has a handy function, `CORREL` which will calculate the correlation for us: ![image-7-1](https://www.carboncollectiveinvesting.com/hs-fs/hubfs/image-7-1.png?width=660&name=image-7-1.png) The function is simple enough. In the first parameter, you highlight the x variables, and in the second, the y variables. What this means is that there is a high correlation coefficient between the stock prices of Tech A and Tech B of 0.95. The coefficient shows that the two tech companies’ stock prices are positively correlated. Because their prices move in a single direction, adding Tech B to Ethan’s portfolio would indeed raise his level of systematic risk. ## Correlation Coefficient Analysis Correlation coefficients can come in different types, but the most commonly used is known as the Pearson correlation (r). The correlation coefficient between two variables determines how strongly related they are, as well as which direction they are going. This metric does not work for nonlinear relationships between variables, however, nor can it tell dependent variables apart from independent variables. Understanding how two variables affect each other is particularly useful to financial market investors. For instance, a correlation helps determine the performance of a mutual fund compared to its benchmark index or to another fund or asset. Diversification is beneficial when mutual funds added to the portfolio have low or negative correlation coefficient with that portfolio. Thus, investors should add only negatively-correlated assets or securities to control market risk related to volatility or extreme price swings. A lot of investors hedge a portfolio’s price risk in order to minimize any [capital gains](https://www.carboncollectiveinvesting.com/sustainable-investing/capital-gains-yield/) or losses if they want their dividend income from the stock or security. As well, correlation values enable investors to check the relationship between changes in two variables. For instance, bank stocks usually come with a very high positive correlation coefficient with interest rates, considering the central role [market](https://www.carboncollectiveinvesting.com/sustainable-investing/market-economy/) interest rates play in loan rate calculations. Should a bank’s stock price drop as interest rates go up, investors can detect that something’s misaligned. If the stock prices of parallel banks in the same sector are also going up, investors can be sure that the decreasing bank stock is brought about not by interest rates but by internal issues possibly affecting the underperforming bank. Correlation coefficients are generally useful but not without limitations. For example, they cannot be used to imply causation or make forecasts. While they reflect the relationship between two variables, no matter how strong, one variable does not necessarily cause or become a basis to predict the behavior of the other. ## Correlation Coefficient Conclusion - The correlation coefficient measures how strongly one variable is related to another variable. - The correlation coefficient is one of the most popular values used in financial statistics. - Correlation coefficient values range from -1, indicating an extremely negative relationship, to +1, showing an extremely strong positive relationship. - Any Values below +0.8 or above –0.8 are considered unimportant. - The correlation coefficient between two variables cannot be used to imply that one is the cause or predict the behavior of the other. ## Correlation Coefficient Calculator You can download the correlation coefficient calculator Excel spreadsheet below to quickly calculate the correlation coefficient between two values. ## FAQs ### 1. What is the correlation coefficient? The correlation coefficient is a measure of the strength and direction of a linear relationship between two variables. ### 2. How do you calculate the correlation coefficient? The correlation coefficient is calculated using the Pearson product-moment correlation coefficient formula. ### 3. How is the correlation coefficient used in investing? The correlation coefficient is used by investors to determine the performance of a mutual fund compared to its benchmark index or to another fund or asset. Diversification is beneficial when mutual funds added to the portfolio have a low or negative correlation coefficient with that portfolio. ### 4. What does a correlation coefficient tell you? A correlation coefficient value tells you the strength and direction of the linear relationship between two variables. It does not imply that one variable cause or predicts the behavior of the other. ### 5. What are the types of correlation coefficients? There are three types of correlation coefficients: Pearson, Spearman, and Kendall. ### Related Topics - [Sustainable 401(k) Plan](https://www.carboncollective.co/401k) - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing/) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - [Retirement Glossary](https://www.carboncollective.co/sustainable-investing/retirement-planning-glossary) - [Best Retirement Plans](https://www.carboncollective.co/sustainable-investing/the-10-best-retirement-plans) - [Wealth Manager Vs Financial Advisor](https://www.carboncollective.co/sustainable-investing/wealth-manager-vs.-financial-advisor) ![Attend Our Next Webinar](https://www.carboncollectiveinvesting.com/hubfs/carbon-collective-green-investing-icon-webinar.12af7b6e.svg) ### Attend Our Next Webinar Join our next Sustainable Investing 101 webinar, get our favorite DIY options, and walk through how we build our portfolios. [Watch Now](https://www.carboncollective.co/sustainable-investing-webinar-green-retirement-month) ![Get Our Newsletter](https://www.carboncollectiveinvesting.com/hubfs/carbon-collective-green-investing-icon-demo.6ed28722.svg) ### Get Our Newsletter Go a level deeper with us and investigate the potential impacts of climate change on investments like your retirement account. Join Newsletter ![close-typeform](data:image/gif;base64,R0lGODlhEQARAIAAAODn7P///yH5BAEHAAEALAAAAAARABEAAAIqBIKpab3v3EMyVHWtWZluf0za0XFNKDJfCq5i5JpomdUxqKLQVmInqyoAADs=) ![Talk To A Human](https://www.carboncollectiveinvesting.com/hubfs/carbon-collective-green-investing-icon-chat.49d48c5b.svg) ### Talk To A Human Joining a new investment service can be intimidating. We’re here for you. Click below to email us a question or book a quick call. [Ask a Question](https://ask.carboncollective.co/f70pooobq) Topics ## Sustainable Investing Topics View our list of some topics below. See More - Portfolios - [Performance](https://www.carboncollectiveinvesting.com/returns) - About - [Sustainable 401(k)](https://www.carboncollectiveinvesting.com/401k) - Learn - [FAQ](https://www.carboncollective.co/en/knowledge/faqs) - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - Contact - [Contact us](mailto:hello@carboncollective.co) - [Legal](https://www.carboncollective.co/legal) - [Privacy Policy](https://www.carboncollectiveinvesting.com/hubfs/2022-11%20Carbon%20Collective%20Privacy%20Policy.pdf) - [Back to top](https://www.carboncollectiveinvesting.com/sustainable-investing/correlation-coefficient#top-of-page) DISCLAIMERS: Advisory services provided by Carbon Collective Investment LLC (“Carbon Collective"), an SEC-registered investment adviser. A copy of Carbon Collective's current written disclosure statement discussing Carbon Collective’s business operations, services, and fees is available at the SEC’s investment adviser public information website – [www.adviserinfo.sec.gov](https://adviserinfo.sec.gov/firm/summary/310129) or [our legal documents here](https://blog.carboncollective.co/legal-documents/). The articles and research support materials available on this site are educational and are not intended to be investment or tax advice. Carbon Collective does not make any representations or warranties as to the accuracy, timeliness, suitability, completeness, or relevance of any information prepared by any unaffiliated third party, whether linked to Carbon Collective’s web site or incorporated herein, and takes no responsibility therefor. All such information is provided solely for convenience purposes only and all users thereof should be guided accordingly. Investments in securities: Not FDIC Insured • No Bank Guarantee • May Lose Value. Investing in securities involves risks, and there is always the potential of losing money when you invest in securities. Before investing, consider your investment objectives and Carbon Collective's charges and expenses. Carbon Collective's internet-based advisory services are designed to assist clients in achieving discrete financial goals. They are not intended to provide comprehensive tax advice or financial planning with respect to every aspect of a client's financial situation and do not incorporate specific investments that clients hold elsewhere. For more details, see our Form CRS, Form ADV Part 2 and other disclosures. Past performance does not guarantee future results, and the likelihood of investment outcomes are hypothetical in nature. Not an offer, solicitation of an offer, or advice to buy or sell securities in jurisdictions where Carbon Collective is not registered. © 2026 Carbon Collective Corporation. All rights reserved. × #### Fact Checked Carbon Collective partners with financial and climate experts to ensure the accuracy of our content. Our team of reviewers are established professionals with years of experience in areas of personal finance and climate. They have contributed to top tier financial publications, such as Reuters, Axios, Ag Funder News, Bloomberg, Marketwatch, Yahoo! Finance, and many others. This team of experts helps Carbon Collective maintain the highest level of accuracy and professionalism possible. × #### Why Trust Carbon Collective Carbon Collective is the first online investment advisor 100% focused on solving climate change. We believe that sustainable investing is not just an important climate solution, but a smart way to invest. We follow ethical journalism practices, which includes presenting unbiased information and citing reliable, attributed resources. Much of our research comes from leading organizations in the climate space, such as Project Drawdown and the International Energy Agency (IEA). Our goal is to deliver the most understandable and comprehensive explanations of climate and finance topics. Our writing and editorial staff are a team of experts holding advanced financial designations and have written for most major financial media publications. Our work has been directly cited by organizations including MarketWatch, Bloomberg, Axios, TechCrunch, Forbes, NerdWallet, GreenBiz, Reuters, and many others. We strive to empower readers with the most factual and reliable climate finance information possible to help them make informed decisions. } ```json { "@context" : "https://schema.org", "@type" : "Organization", "alternateName" : "Carbon Collective", "contactPoint" : { "@type" : "ContactPoint", "areaServed" : "US", "availableLanguage" : "en", "contactType" : "customer service", "telephone" : "(650) 868-2697" }, "logo" : "https://www.carboncollective.co/hubfs/CarbonCollectiveLogo.png", "name" : "Carbon Collective Investing LLC", "sameAs" : [ "https://www.facebook.com/carboncollectiveinvesting/", "https://twitter.com/carbncollective", "https://www.instagram.com/carbon.collective/", "https://www.youtube.com/channel/UC769Y-F-L_B37kyQfdpvyXA", "https://www.linkedin.com/company/carbon-collective/", "https://www.crunchbase.com/organization/carbon-collective", "https://adviserinfo.sec.gov/firm/summary/310129", "https://www.wikidata.org/wiki/Q110243690" ], "url" : "https://www.carboncollective.co/" } ``` ```json { "@context" : "https://schema.org", "@type" : "FAQPage", "mainEntity" : [ { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "The correlation coefficient is a measure of the strength and direction of a linear relationship between two variables." }, "name" : "What is the correlation coefficient?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "The correlation coefficient is calculated using the Pearson product-moment correlation coefficient formula." }, "name" : "How do you calculate the correlation coefficient?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "The correlation coefficient is used by investors to determine the performance of a mutual fund compared to its benchmark index or to another fund or asset. Diversification is beneficial when mutual funds added to the portfolio have a low or negative correlation coefficient with that portfolio." }, "name" : "How is the correlation coefficient used in investing?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "A correlation coefficient value tells you the strength and direction of the linear relationship between two variables. It does not imply that one variable cause or predicts the behavior of the other." }, "name" : "What does a correlation coefficient tell you?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "There are three types of correlation coefficients: Pearson, Spearman, and Kendall." }, "name" : "What are the types of correlation coefficients?" } ] } ``` ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "https://20345524.fs1.hubspotusercontent-na1.net/hubfs/20345524/Brooke%20Tomasetti.png", "url" : "https://www.carboncollectiveinvesting.com/sustainable-investing/author/brooke-tomasetti" }, "dateModified" : "2024-10-01", "datePublished" : "2022-05-11", "description" : "Correlation coefficients can come in different types, but the most commonly used is known as the Pearson correlation (r). Click to know more.", "headline" : "Correlation Coefficient | Formula, Example, Analysis, Calculator", "image" : "", "mainEntityOfPage" : { "@id" : "https://www.carboncollectiveinvesting.com/sustainable-investing/correlation-coefficient", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.carboncollective.co/hubfs/CarbonCollectiveLogo.png" }, "name" : "Carbon Collective" } } ```