相関 - 定義、公式、例、見つけ方

Correlation - Definition, Formula, Example, How to Find Home › Resources › Data Science › Correlation Table of Contents What is a Correlation? Correlation and Causation How to Find the Correlation? Example of Correlation Additional Resources Correlation A statistical measure of the relationship between two variables Written by Sebastian Taylor Published February 18, 2020 Read Time 5 minutes Over 3 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course. Start Free What is a Correlation? A correlation is a statistical measure of the relationship between two variables. The measure is best used in variables that demonstrate a linear relationship between each other. The fit of the data can be visually represented in a scatterplot. Using a scatterplot, we can generally assess the relationship between the variables and determine whether they are correlated or not. The correlation coefficient is a value that indicates the strength of the relationship between variables. The coefficient can take any values from -1 to 1. The interpretations of the values are: -1: Perfect negative correlation. The variables tend to move in opposite directions (i.e., when one variable increases, the other variable decreases). 0: No correlation. The variables do not have a relationship with each other. 1: Perfect positive correlation. The variables tend to move in the same direction (i.e., when one variable increases, the other variable also increases). One of the primary applications of the concept in finance is portfolio management . A thorough understanding of this statistical concept is essential to successful portfolio optimization. Correlation and Causation Correlation must not be confused with causality. The famous expression “correlation does not mean causation” is crucial to the understanding of the two statistical concepts. If two variables are correlated, it does not imply that one variable causes the changes in another variable. Correlation only assesses relationships between variables, and there may be different factors that lead to the relationships. Causation may be a reason for the correlation, but it is not the only possible explanation. CFI’s Math for Corporate Finance Course explores the financial mathematics concepts required for financial modeling. How to Find the Correlation? The correlation coefficient that indicates the strength of the relationship between two variables can be found using the following formula: Where: r xy – the correlation coefficient of the linear relationship between the variables x and y x i – the values of the x-variable in a sample x̅ – the mean of the values of the x-variable y i – the values of the y-variable in a sample ȳ – the mean of the values of the y-variable In order to calculate the correlation coefficient using the formula above, you must undertake the following steps: Obtain a data sample with the values of x-variable and y-variable. Calculate the means (averages) x̅ for the x-variable and ȳ for the y-variable. For the x-variable, subtract the mean from each value of the x-variable (let’s call this new variable “a”). Do the same for the y-variable (let’s call this variable “b”). Multiply each a-value by the corresponding b-value and find the sum of these multiplications (the final value is the numerator in the formula). Square each a-value and calculate the sum of the result Find the square root of the value obtained in the previous step (this is the denominator in the formula). Divide the value obtained in step 4 by the value obtained in step 7 . You can see that the manual calculation of the correlation coefficient is an extremely tedious process, especially if the data sample is large. However, there are many software tools that can help you save time when calculating the coefficient. The CORREL function in Excel is one of the easiest ways to quickly calculate the correlation between two variables for a large data set. Example of Correlation John is an investor. His portfolio primarily tracks the performance of the S&P 500 and John wants to add the stock of Apple Inc . Before adding Apple to his portfolio, he wants to assess the correlation between the stock and the S&P 500 to ensure that adding the stock won’t increase the systematic risk of his portfolio. To find the coefficient, John gathers the following prices for the last five years ( Step 1 ): Using the formula above, John can determine the correlation between the prices of the S&P 500 Index and Apple Inc. First, John calculates the average prices of each security for the given periods ( Step 2 ): After the calculation of the average prices, we can find the other values. A summary of the calculations is given in the table below: Using the obtained numbers, John can calculate the coefficient: The coefficient indicates that the prices of the S&P 500 and Apple Inc. have a high positive correlation. This means that their respective prices tend to move in the same direction. Therefore, adding Apple to his portfolio would, in fact, increase the level of systematic risk. Connect what you just learned to a clear career path with CFI’s role‑based courses and certification programs. Advance Your Career Additional Resources Thank you for reading CFI’s explanation of Correlation. To keep learning and developing your knowledge of financial analysis, we highly recommend the additional CFI resources below: Free Statistics Fundamentals Course Anchoring Bias Dynamic Financial Analysis Hypothesis Testing Poisson Distribution See all Data Science resources Get Certified for Business Intelligence (BIDA®) Develop analytical superpowers by learning how to use programming and data analytics tools such as VBA, Python, Tableau, Power BI, Power Query, and more. Learn More Share this article Corporate Finance Institute Back to Website 0 search results for ‘ ’ People also search for: excel power bi esg accounting balance sheet fmva real estate Explore Our Certifications Financial Modeling & Valuation Analyst (FMVA)® Commercial Banking & Credit Analyst (CBCA)® Capital Markets & Securities Analyst (CMSA)® Certified Business Intelligence & Data Analyst (BIDA)® Financial Planning & Wealth Management Professional (FPWMP)® FinTech Industry Professional (FTIP)® Resources Mastering Excel Shortcuts for PC and Mac Work Smarter in Excel with Keyboard Shortcuts If you're still reaching for the mouse every few seconds, it's time to level up. The best Excel keyboard... Financial Modeling Guidelines CFI’s free Financial Modeling Guidelines is a thorough and complete resource covering model design, model building blocks, and common tips, tricks,... SQL Data Types What are SQL Data Types? The Structured Query Language (SQL) comprises several different data types that allow it to store different types of information... Structured Query Language (SQL) What is Structured Query Language (SQL)? Structured Query Language (known as SQL) is a programming language used to interact with a database.... See All Resources See All Popular Courses BIDA Prep Course 2h 14min Excel Fundamentals - Formulas for Finance FMVA Required 3h 15min 3-Statement Modeling FMVA Required 3h 9min Introduction to Business Valuation FMVA Required 48min Scenario & Sensitivity Analysis in Excel FMVA Required 1h 30min Excel Data Visualization and Dashboards FMVA Elective 2h 14min Real Estate Financial Modeling See All Courses See All Recent Searches Suggestions Excel Courses Financial Modeling & Valuation Analyst (FMVA)® × Create a free account to unlock this Template Access and download collection of free Templates to help power your productivity and performance. Create a Free Account Already have an account? Log in × Supercharge your skills with Premium Templates Take your learning and productivity to the next level with our Premium Templates. Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs. Discover Paid Memberships Already have a Self-Study or Full-Immersion membership? Log in × Access Exclusive Templates Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more. Discover Full-Immersion Membership Already have a Full-Immersion membership? Log in