Forum Discussion
Relationship between two variables
Hi,
I have attached an excel file that contains two set of data, the first column is time of a phone call, the second column is the duration of the call, I need you to please help me find a relationship between these two variables, is there any positive or negative relationship between time and duration of the call? also I need to demonstrate this relationship in a chart
Thank you so so much in advance 😃
As you can see in the chart in the attached workbook, the time are pretty random.
Their correlation is very small: -0.004.
The only things that jump out visually is the outliers cluster around 9 AM, 1 PM and 4 PM, but they are small in number.
3 Replies
As you can see in the chart in the attached workbook, the time are pretty random.
Their correlation is very small: -0.004.
The only things that jump out visually is the outliers cluster around 9 AM, 1 PM and 4 PM, but they are small in number.
- Thank you so much this is exactly what I need
