I have a scatter graph plotted in excel
On the x axis is distance from CBD and on the y axis is accessibility. I have given every station in a rail network an accessibility value and plotted this with how far away it is from the CBD. In total there are 103 stations which I grouped in the graph according to the different boroughs they are located in. I made a trend line for all the stations and now what I want to know is whether this means that stations below the trend line perform below average accessibility wise and vice versa. The purpose of this is to see whether boroughs as a whole have below or above average connectivity.
I have attached the graph
excel forum graph.xlsx
Bookmarks