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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Correlation problem
- Thread starter pdugan
- Start date
PA HS Teacher
Well-known Member
- Joined
- Jul 17, 2004
- Messages
- 2,838
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.
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.
Upvote
0
NextYearSox
Active Member
- Joined
- Oct 24, 2003
- Messages
- 287
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
=CORREL(A1:A200,B1:B200)
Someone else should probably chime in with advice on how to interpret the correlation number
Upvote
0
Similar threads
- Solved
- Question
- Question
