Jun 11 2021 02:11 AM
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 =)
Jun 11 2021 04:54 AM
SolutionAs 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.
Jun 11 2021 04:57 AM
Jun 11 2021 09:20 AM
Jun 11 2021 04:54 AM
SolutionAs 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.