Correlation coefficient excel

SHARE THE ARTICLE ON

Correlation coefficient is used to find the relationship between two variables and how strong they are.

Correlation coefficient can be calculated using various mentioned methods:

In this article, we will see a step-by-step guide on how to calculate correlation coefficient in excel. In the end we will see a shortcut method.

Step 1: Enter your data in excel as given below

If you don’t have the “Data analysis” tool installed, follow the below steps to get it installed:

File > Options > Add-ins > Select the “Analysis ToolPak” > Go > Tick the “Analysis ToolPak” checkbox > Ok

Create an actionable feedback collection process.

Select “Correlation” from the opened dialogue box. And click on “Ok”

Select the columns of rows you want to add in the “inputs range” field.

Get market research trends guide, Online Surveys guide, Agile Market Research Guide & 5 Market research Template

See Voxco survey software in action with a Free demo.

Create an excel sheet using your data.

Select a blank cell you want to show your results into and put the following formula in the formula tab: =CORREL(array, array) and press enter.

The field array refers to the range of the cells in which your data is for each sample 1 and sample 2.

Explore Voxco Survey Software