{"id":7810,"date":"2024-01-05T17:34:55","date_gmt":"2024-01-05T17:34:55","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=7810"},"modified":"2024-01-19T20:18:08","modified_gmt":"2024-01-19T20:18:08","slug":"how-to-use-correl-function-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-use-correl-function-in-excel\/","title":{"rendered":"How to use CORREL function in Excel?"},"content":{"rendered":"<p>The CORREL function in Excel is a powerful tool for statisticians, data analysts, and anyone keen on understanding the relationship between two sets of data. This function computes the correlation coefficient, a crucial statistic that measures the degree of linear relationship between two variables, offering insights into trends, patterns, and predictive modeling. Whether you&#8217;re in finance analyzing stock market trends, in marketing assessing consumer behavior, or in healthcare studying clinical data, this guide will navigate you through the process of using the CORREL function in Excel. By mastering this function, you&#8217;ll be able to unveil hidden relationships in your data, leading to more informed decisions and strategic planning.<\/p>\n<p><strong>This content Covers:<\/strong><\/p>\n<ol>\n<li><a href=\"#what-is-the-correl-function?\"><strong>What is the CORREL Function?<\/strong><\/a><\/li>\n<li><a href=\"#what-are-some-uses-of-the-correl-function-in-excel?\"><strong>What are some uses of the CORREL function in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-use-correl-function-in-excel?\"><strong>How to use CORREL Function in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#some-points-to-remember-about-the-correl-function\"><strong>Some points to remember about the CORREL Function<\/strong><\/a><\/li>\n<li><a href=\"#how-to-find-correlation-coefficient-in-excel?\"><strong>How to Find Correlation Coefficient in Excel?<\/strong><\/a><\/li>\n<\/ol>\n<h2><strong id=\"what-is-the-correl-function?\">1. What is the CORREL Function?<\/strong><\/h2>\n<p>The CORREL function simplifies this calculation and makes it easy to find correlations between two data sets in Excel.<\/p>\n<p>A correlation coefficient is a statistical measure that quantifies the strength and direction of a linear relationship between two data sets.<\/p>\n<p>It is used to determine whether there is a positive or negative relationship between variables and ranges from -1 to 1.<\/p>\n<ul>\n<li><strong>A value of 1<\/strong> indicates a perfect positive correlation, meaning the variables move in the same direction.<\/li>\n<li><strong>A value of -1 indicates<\/strong> a perfect negative correlation, meaning the variables move in opposite directions.<\/li>\n<li>Values \u200b\u200bclose to 0 indicate weak or no correlation.<\/li>\n<li>There is no linear relationship between the variables.<\/li>\n<\/ul>\n<h2><strong id=\"what-are-some-uses-of-the-correl-function-in-excel?\">2. What are some uses of the CORREL function in Excel?<\/strong><\/h2>\n<ul>\n<li><strong>Portfolio management:<\/strong><\/li>\n<\/ul>\n<p>In here, the CORREL function is often used to evaluate correlations between different investments. By analyzing the correlation coefficient between assets or asset classes, investors can build diversified portfolios that reduce overall risk. Assets with low or negative correlation tend to move independently of each other, reducing risk more effectively.<\/p>\n<ul>\n<li><strong>Forecasting and forecasting:<\/strong><\/li>\n<\/ul>\n<p>The CORREL function helps you make predictions and forecasts by identifying relationships between variables. By calculating correlations between historical data, you can predict future results. For example, you can predict future sales by analyzing the correlation between sales and various factors such as advertising spend, economic indicators, and seasonal trends.<\/p>\n<ul>\n<li><strong>Risk analysis:<\/strong><\/li>\n<\/ul>\n<p>CORREL functionality is useful for risk analysis and risk management. By analyzing the correlation between variables such as market indexes and asset returns, you can assess the degree of systematic risk in your portfolio. Understanding the correlation between investments can help you identify potential vulnerabilities and make informed decisions to reduce risk.<\/p>\n<ul>\n<li><strong>Data validation:<\/strong><\/li>\n<\/ul>\n<p>The CORREL function can be used as a data validation tool. It helps ensure data integrity by checking for errors and inconsistencies in records. Correlation coefficients outside a certain range may indicate data entry errors, outliers, or missing values \u200b\u200bthat require further investigation.<\/p>\n<h2><strong id=\"how-to-use-correl-function-in-excel?\">3. How to use CORREL Function in Excel?<\/strong><\/h2>\n<p>While doing Correl function in excel you have to follow a syntax that is:<\/p>\n<p><strong>=CORREL(array1, array2)<\/strong><\/p>\n<p><strong>&#8220;Array1&#8221; is the first set of data values.<\/strong><\/p>\n<p><strong>\u00a0&#8220;Array2&#8221; is the second set of data values.<\/strong><strong>\u00a0<\/strong><\/p>\n<p><strong>Step 1:<\/strong> First you need to prepare your data then organize your data into two columns or tables, where each column represents a different variable or set of data.<\/p>\n<p>Now put your data into your excel sheet as shown below:<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-7811\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-1.png\" alt=\"CORREL function \" width=\"503\" height=\"228\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-1.png 503w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-1-300x136.png 300w\" sizes=\"(max-width: 503px) 100vw, 503px\" \/><\/p>\n<p><strong>Step 2:<\/strong> After entering your data where you want to show the correlation you need to put in the CORREL function with the exact array.<\/p>\n<p>Suppose you want to work with the data is in columns A and C same as the picture showing, for this you need to choose <strong>(A1:A8, C1:C8).<\/strong><\/p>\n<figure id=\"attachment_7812\" aria-describedby=\"caption-attachment-7812\" style=\"width: 435px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"wp-image-7812 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-2.png\" alt=\"CORREL Function in Excel\" width=\"435\" height=\"304\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-2.png 435w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-2-300x210.png 300w\" sizes=\"(max-width: 435px) 100vw, 435px\" \/><figcaption id=\"caption-attachment-7812\" class=\"wp-caption-text\">CORREL Function in Excel<\/figcaption><\/figure>\n<p><strong>Step 3:<\/strong> Now you need to create another table with the results. For this choose column E so that you can get the output for Stock A and Stock B.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-7813\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-3.png\" alt=\"CORREL function\" width=\"634\" height=\"189\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-3.png 634w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-3-300x89.png 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/p>\n<p><strong>Step 4:<\/strong> Now, write down the formula for stock A <strong>=CORREL(A2:A8, C2:C8)<\/strong> in the Output column as shown.<\/p>\n<figure id=\"attachment_7814\" aria-describedby=\"caption-attachment-7814\" style=\"width: 638px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-7814 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-4.png\" alt=\"CORREL Function in Excel\" width=\"638\" height=\"202\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-4.png 638w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-4-300x95.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><figcaption id=\"caption-attachment-7814\" class=\"wp-caption-text\">CORREL Function in Excel<\/figcaption><\/figure>\n<p><strong>Step 5:<\/strong> Now, do press enter Key.<\/p>\n<p>You can see the results in the output box in which Excel calculates the correlation coefficient between two data sets A2 to A8 and C2 to C8.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7815\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-5.png\" alt=\"CORREL function\" width=\"339\" height=\"127\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-5.png 339w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-5-300x112.png 300w\" sizes=\"(max-width: 339px) 100vw, 339px\" \/><\/p>\n<p>Now, you can use the same formula for Stock B according to your column. The formula will be: <strong>=CORREL(A2:A8,B2:B8)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7816\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-6.png\" alt=\"CORREL function\" width=\"636\" height=\"208\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-6.png 636w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-6-300x98.png 300w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/p>\n<p>After entering the formula press Enter and you will get the result for Stock B.<br \/>\nThe result is outlined below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7817\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-7.png\" alt=\"CORREL function\" width=\"300\" height=\"131\" \/><\/p>\n<h2><strong id=\"some-points-to-remember-about-the-correl-function\">4. Some points to remember about the CORREL Function<\/strong><\/h2>\n<ul>\n<li><strong>N\/A error \u2013<\/strong> When the specified arrays have different lengths that time it Occurs. Therefore, if Array1 and Array2 contain different numbers of data points, CORREL returns the error value N\/A.<\/li>\n<li><strong>DIV\/0 error &#8211;<\/strong> Occurs when one of the specified arrays is empty or the standard deviation of their values \u200b\u200bis 0. If the array or reference argument contains text, logical values, or empty cells, the values \u200b\u200bare ignored. However, cells with a value of zero are also considered.<\/li>\n<\/ul>\n<h2><strong id=\"how-to-find-correlation-coefficient-in-excel?\">5. How to Find Correlation Coefficient in Excel?<\/strong><\/h2>\n<p><strong>Step 1:<\/strong> You need to make an data table first.<\/p>\n<p>Where,\u00a0 Put Variable <strong>array1 as X<\/strong><\/p>\n<p>Variable <strong>array2 as Y1 and array3 as Y2<\/strong>.<\/p>\n<p>Make a table as shown below and put the data into the column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7818\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-8.png\" alt=\"CORREL function\" width=\"530\" height=\"274\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-8.png 530w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-8-300x155.png 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Now make another table for finding the Correlation for Y1 and Y2.<\/p>\n<p>Make a table in Columns E and F to get the Correlation of X of Y1 and X of \u00a0Y2 as shown.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7819\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-9.png\" alt=\"CORREL function \" width=\"637\" height=\"218\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-9.png 637w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-9-300x103.png 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><\/p>\n<p><strong>\u00a0Step3:<\/strong> The formula for finding the Correlation of Y1 is:<\/p>\n<p><strong>=CORREL(array1,array2) or =CORREL(A2:A7,B2:B7)<\/strong><\/p>\n<p><strong>array1:<\/strong> Set of values of X. The cell range is from <strong>A2 to A7<\/strong>.<\/p>\n<p><strong>array2 :<\/strong> Set of values of Y1. The cell range is from <strong>B2 to B7<\/strong>.<\/p>\n<p>Now, you can follow the below formula for finding the correlation for the variables X and Y1.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7820\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-10.png\" alt=\"CORREL function \" width=\"637\" height=\"225\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-10.png 637w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-10-300x106.png 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><\/p>\n<p><strong>Step 4:<\/strong> After writing down the formula now press enter.<\/p>\n<p>After pressing the enter key you will get the result of Array X and Array Y1 as shown.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7821\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-11.png\" alt=\"CORREL function\" width=\"320\" height=\"125\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-11.png 320w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-11-300x117.png 300w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><\/p>\n<p>For Array X and Array Y2 you need to follow <strong>Step 2<\/strong> and you will get the result it like this. For X and Y2 the formula will be:\u00a0 <strong>=CORREL(A2:A7,C2:C7).<\/strong><\/p>\n<p>Enter the formula according to your column as shown below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7822\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-12.png\" alt=\"CORREL function \" width=\"589\" height=\"228\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-12.png 589w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-12-300x116.png 300w\" sizes=\"(max-width: 589px) 100vw, 589px\" \/><\/p>\n<p>After using the formula press Enter the result of X and Y2 will appear.<\/p>\n<p>The result is outlined below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7823\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-13.png\" alt=\"CORREL function\" width=\"304\" height=\"138\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-13.png 304w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-13-300x136.png 300w\" sizes=\"(max-width: 304px) 100vw, 304px\" \/><\/p>\n<p><strong>Step 5:<\/strong> Now, Go to the file tab as shown below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7824\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-14.png\" alt=\"CORREL function\" width=\"637\" height=\"429\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-14.png 637w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-14-300x202.png 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><\/p>\n<p><strong>Step 6:<\/strong> After clicking on the file tab, You can see a home page will appear. Now, click on <strong>MORE tab <\/strong>and you will get an <strong>Option tab<\/strong>.<\/p>\n<p>Do click on Option tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7825\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-15.png\" alt=\"CORREL function \" width=\"330\" height=\"439\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-15.png 330w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-15-226x300.png 226w\" sizes=\"(max-width: 330px) 100vw, 330px\" \/><\/p>\n<p><strong>Step 7:<\/strong> After clicking on Option the Excel Options dialog box will open. Click on the Add-Ins option as shown below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7826\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-16.png\" alt=\"CORREL function \" width=\"617\" height=\"442\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-16.png 617w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-16-300x215.png 300w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/><\/p>\n<p><strong>Step 8:<\/strong> After clicking Add-ins, you will get a page the same as like which is in the one below and then you can see\u00a0 Excel Add-ins from the drop-down in the Manage and click on the Go button as showing.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7827\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-17.png\" alt=\"CORREL function\" width=\"609\" height=\"444\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-17.png 609w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-17-300x219.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/p>\n<p><strong>Step 9:<\/strong> After clicking on Go the Add-ins dialog box opens and in this option, you can see <strong>Analysis ToolPak.<\/strong><\/p>\n<p>Select <strong>Analysis ToolPak<\/strong> and Click <strong>Ok<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7828\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-18.png\" alt=\"CORREL function \" width=\"443\" height=\"380\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-18.png 443w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-18-300x257.png 300w\" sizes=\"(max-width: 443px) 100vw, 443px\" \/><\/p>\n<p><strong>Step 10: <\/strong>After clicking on OK tab now<strong> Click on Data \u02c3Data<\/strong> Analysis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7829\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-19.png\" alt=\"CORREL function\" width=\"635\" height=\"214\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-19.png 635w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-19-300x101.png 300w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><\/p>\n<p><strong>Step 11: <\/strong>After clicking on Data analysis, A dialogue box opens. A dialogue box appears. When getting the dialogue box you can see Correlation from the list of options.<\/p>\n<p>Select Correlation from the list of options and Click OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7830\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-20.png\" alt=\"CORREL function\" width=\"535\" height=\"213\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-20.png 535w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-20-300x119.png 300w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/p>\n<p><strong>Step 12:<\/strong> After clicking on OK from the above step a Correlation menu will appear like the below image.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7831\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-21.png\" alt=\"CORREL function\" width=\"416\" height=\"255\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-21.png 416w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-21-300x184.png 300w\" sizes=\"(max-width: 416px) 100vw, 416px\" \/><\/p>\n<p><strong>Step 13<\/strong>: In this menu first provide the Input Range. The input range is the cell range of X and Y1 columns and also, supplies the Output Range as the cell number where you want to display the result. As highlighted in the picture below.<\/p>\n<p>Then, Check the Labels in the first-row option if you have labels in the dataset. In this case column 1 has label X and column 2 has label Y1.<\/p>\n<p>Here entered the range according to the information. For Calculating X and Y1 the formula will be:<strong>$A$1:$B$7, <\/strong>Output range<strong> $A$10.<\/strong><\/p>\n<p>When you put the output range you can see a mark there as shown below according to given output range.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7832\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-22.png\" alt=\"CORREL function\" width=\"637\" height=\"218\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-22.png 637w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-22-300x103.png 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><\/p>\n<p><strong>Step 14:<\/strong> While clicking on OK, The Data Analysis table is now ready. Here, you can see the correlation coefficient between X and Y1 in the analysis table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7833\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-23.png\" alt=\"CORREL function\" width=\"495\" height=\"346\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-23.png 495w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-23-300x210.png 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/p>\n<p>Like the above way, For calculating the correlation coefficient between X and Y2 in the analysis table use this formula: <strong>$A$1:$C$7 and <\/strong>Output range is<strong> $A$10.<\/strong><\/p>\n<p>In the below picture, you can see the formula is entered<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7834\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-24.png\" alt=\"CORREL function\" width=\"514\" height=\"253\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-24.png 514w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-24-300x148.png 300w\" sizes=\"(max-width: 514px) 100vw, 514px\" \/><\/p>\n<p><strong>Step 15: <\/strong>After pressing OK, you will get the correlation between X and Y2<\/p>\n<p>Here is the result below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7835\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-25.png\" alt=\"CORREL function\" width=\"549\" height=\"341\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-25.png 549w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/01\/CORREL-function-25-300x186.png 300w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/p>\n<p>You may be interested:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>The CORREL function in Excel is a powerful tool for statisticians, data analysts, and anyone keen on understanding the relationship between two sets of data. This function computes the correlation coefficient, a crucial statistic that measures the degree of linear relationship between two variables, offering insights into trends, patterns, and predictive modeling. Whether you&#8217;re in &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-use-correl-function-in-excel\/\"> <span class=\"screen-reader-text\">How to use CORREL function in Excel?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[881],"tags":[883,882],"class_list":["post-7810","post","type-post","status-publish","format-standard","hentry","category-correl-function-in-excel","tag-correl-function","tag-correl-function-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/7810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=7810"}],"version-history":[{"count":4,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/7810\/revisions"}],"predecessor-version":[{"id":8160,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/7810\/revisions\/8160"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=7810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=7810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=7810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}