0
Given: I have columns something like
| Location | Year | A | B |
|-----------|------|---|-----|
| Delhi | 1980 | 4 | 3.4 |
| Mumbai | 1986 | 3 | 3.9 |
| Delhi | 1990 | 5 | 4.4 |
| Bangalore | 1997 | 2 | 2.6 |
| Delhi | 1998 | 4 | 3.8 |
| Delhi | 1991 | 4 | 4.5 |
| Bangalore | 1987 | 4 | 3.8 |
| Mumbai | 1998 | 5 | 4.8 |
And I want to perform correlation between column A
and B
under Delhi Location
category.
I want to perform correlation with only Delhi as Location
| Location | A | B |
|----------|---|-----|
| Delhi | 4 | 3.4 |
| Delhi | 5 | 4.4 |
| Delhi | 4 | 3.8 |
| Delhi | 4 | 4.5 |
I tried CORREL()
function but this will give correlation A
and B
for all location. I just want specific Location
to correlated.
Thank you for your time and consideration.
I am getting
#VALUE!
. which says A value used in the formula is of the wrong data types. I am calculating this correlation in another sheet. Does it effect my calculation. Or there is something else. – Maqsud Inamdar – 2019-11-25T14:17:15.163It shouldn't matter if the table is on another worksheet. It shouldn't matter if there are numbers in the Location column and if there was text in any of the number columns, you would get a
#DIV/0!
error. I'm a little dumbfounded as to what the problem is. – Jeeped – 2019-11-25T20:47:58.2001Ctrl + Shift + Enter works. Thanks @Jeeped. – Maqsud Inamdar – 2019-11-26T05:55:57.273