Correlation Chart

Copper Contributor

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