IR Table analysis

[krishnan.anju1987]

Hi,

In order to solve the second part of the question, I drew a graph. Is there some other easier way to go about it?

http://imageshack.us/f/801/imageki.png/

Thanks in advance.
Kris

[tim]

instead of drawing a graph, you could have just sorted on one of the relevant columns and then looked at the other column to see that the numbers *in general* were moving in the opposite direction..

[krishnan.anju1987]

yup, I tried that initially but then there were a few fluctuations in the points(especially the repeating ones like 0 for self checked unlimited lanes which has average customers ages of 56,50 and 38) which got me confused. Would it make sense to take only one point in such cases and if so how do I decide which point to take?

[tim]

no, you definitely don't want to skew the data by ignoring some data points. instead, just look for *general* trends, and remember a correlation does not have to match perfectly. this may be what was confusing you earlier when you noticed a few outliers..