# Correlation problem

#### pdugan

##### New Member
I would like to correlate two sets of data to determine if they are both from the same population. One set has 50 entries and the other can have between 100 & 200 entries. The data are arranged in two columns, A & B. Any detailed help would be apprecited, because I'm not very experienced using excel.

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
The quickest way to see how closely the two data sets correlate would be to graph them. You can hightlight the data, then click on the graph wizard at the top of the screen.
Choose X-Y Scatter.

You can probably guess visually if they could be from the same population. For a more quantitative comparison, add a trendline to each data series.

Try using the Correlation Function. Copy the following formula if your data is in Column A and B in rows 1:200:

=CORREL(A1:A200,B1:B200)

Someone else should probably chime in with advice on how to interpret the correlation number

Replies
18
Views
517
Replies
0
Views
442
Replies
19
Views
2K
Replies
6
Views
264
Replies
6
Views
473

1,203,052
Messages
6,053,234
Members
444,648
Latest member
sinkuan85

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back