SOLVED

Relationship between two variables

%3CLINGO-SUB%20id%3D%22lingo-sub-2438426%22%20slang%3D%22en-US%22%3ERelationship%20between%20two%20variables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2438426%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20an%20excel%20file%20that%20contains%20two%20set%20of%20data%2C%20the%20first%20column%20is%20time%20of%20a%20phone%20call%2C%20the%20second%20column%20is%20the%20duration%20of%20the%20call%2C%20I%20need%20you%20to%20please%20help%20me%20find%20a%20relationship%20between%20these%20two%20variables%2C%20is%20there%20any%20positive%20or%20negative%20relationship%20between%20time%20and%20duration%20of%20the%20call%3F%20also%20I%20need%20to%20demonstrate%20this%20relationship%20in%20a%20chart%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20so%20much%20in%20advance%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-big-eyes%22%20title%3D%22%3Agrinning_face_with_big_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2438426%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2439078%22%20slang%3D%22en-US%22%3ERe%3A%20Relationship%20between%20two%20variables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2439078%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1076540%22%20target%3D%22_blank%22%3E%40maalee100%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20you%20can%20see%20in%20the%20chart%20in%20the%20attached%20workbook%2C%20the%20time%20are%20pretty%20random.%3C%2FP%3E%0A%3CP%3ETheir%20correlation%20is%20very%20small%3A%20-0.004.%3C%2FP%3E%0A%3CP%3EThe%20only%20things%20that%20jump%20out%20visually%20is%20the%20outliers%20cluster%20around%209%20AM%2C%201%20PM%20and%204%20PM%2C%20but%20they%20are%20small%20in%20number.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2439097%22%20slang%3D%22en-US%22%3ERe%3A%20Relationship%20between%20two%20variables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2439097%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1076540%22%20target%3D%22_blank%22%3E%40maalee100%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20add%20scatter%20chart%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20557px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F288064i174D5C30BAACF992%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 (New 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