SOLVED

Relationship between two variables

Copper Contributor

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 =)

3 Replies
best response confirmed by maalee100 (Copper Contributor)
Solution

@maalee100 

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.

@maalee100 

You may add scatter chart like

image.png

Thank you so much this is exactly what I need
1 best response

Accepted Solutions
best response confirmed by maalee100 (Copper Contributor)
Solution

@maalee100 

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.

View solution in original post