Correlation Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-2919209%22%20slang%3D%22en-US%22%3ECorrelation%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2919209%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20asked%20to%20create%203%20x%20correlation%20charts%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20To%20show%20the%20relationship%20between%20time%20spent%20in%20a%20role%20and%20their%20mental%20health%20score%3C%2FP%3E%3CP%3E2.%20To%20show%20the%20relationship%20between%20their%20exposure%20to%20fatalities%20and%203%20mental%20health%20scores%3C%2FP%3E%3CP%3E3.%20To%20show%20the%20relationship%20between%20their%20exposure%20to%20fatalities%20in%20and%20out%20of%20the%20workplace%20and%203%20mental%20health%20scores%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20read%20multiple%20forums%20on%20correlation%20charts%20but%20I%20can't%20work%20it%20out.%20I%20have%20attached%20the%20document%20with%20the%203%20sets%20of%20data%2C%20if%20someone%20is%20able%20to%20share%20how%20I%20go%20about%20this%2C%20or%20even%20if%20a%20correlation%20chart%20is%20the%20best%20format%20to%20show%20this%20anaysis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20Excel%20for%20Mac%20Version%2016.53%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2919209%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have been asked to create 3 x correlation charts:

 

1. To show the relationship between time spent in a role and their mental health score

2. To show the relationship between their exposure to fatalities and 3 mental health scores

3. To show the relationship between their exposure to fatalities in and out of the workplace and 3 mental health scores

 

I have read multiple forums on correlation charts but I can't work it out. I have attached the document with the 3 sets of data, if someone is able to share how I go about this, or even if a correlation chart is the best format to show this anaysis.

 

Using Excel for Mac Version 16.53

 

Thank you!

1 Reply

@charliekidd I added a few Scatter charts on the basis of your data. Would that be what you need?

To insert a such a chart, choose the data range for X and Y. On the Insert ribbon, select the Scatter chart icon.

Screenshot 2021-11-03 at 06.50.36.png