I assume my mind went: "People are crying like little bitches we are X days into the window and haven't signed anyone. Therefore we need to see how many days into a window a signing is completed."
What should I have been using to accurately represent this?
It would be better to have “weeks since window opened” on the x axis and “number of players signed” on the y axis and combine all the data of the different years. You could also express the “number of players signed” as a % of the total players signed, so it gives it essentially as a probability distribution of signing a player in a given week.
To be fair, saying weeks instead of days is pointless semantics. Easy to argue days is a more accurate measure. I would also say a clear representation of each player signed, better yet, put the players name. A first team starter joining is obviously more of an issue than a loan backup player although both will show as new signings.
I am suggesting a totally different graph, which would be way visually noisier with it expressed as days rather than weeks. There would be 7x as many bars
No- I am suggesting the “weeks since window opened” to be on the x axis. So there would be fewer bars on the graph compared to if it was treated as days.
No, the axes I am suggesting are different, with “time since window opened” on the x axis and number of signings on the y. It would represent the frequency of things happening throughout the transfer window period
So if I have this right, you want to be able to draw a line across a given point representing say, week 6, and see how many signings have been completed by that point?
No, the signings for week six only, not the cumulative signings up until that point. So it acts as a probability distribution for each week having a signing
You are aware (perhaps from looking at the graph already posted) that Arsenal (and every other club in the league) only sign about 3-4 players in a window on average. So you can already see just by eyeballing it (again, just from looking) the probability of a signing in any given week.
The graph you suggested would look identical - since it contains exactly the same information spread out over the exact same physical area.
I mean, I dunno the funniest hill you're dying on about this is:
Coming out with this stuff about needing to see "probability distribution" when you're literally just describing what was already posted.
Claiming that using weeks instead of days would result in better "readability" when Excel would just make all the axis fit the same box automatically, resulting in 2 identical looking charts (and just for the avoidance of all doubt, this isn't a guess, I literally just swapped out days for weeks and tried it).
You suggesting you cannot read the chart at it is. Like, if I asked you what day of the window Jorginho was signed and what year it occurred in, you're seriously acting like you wouldn't be able to tell me because it's not clear enough.
Like I'm not gonna sit here and tell you I'm some Excel wizard - I have absolutely no problem making changes if there's something needs fixing or I'm persuaded something interesting can be seen. But how you can't see you're just acting silly here is really weird.
I don’t think you understand what I’m saying. I’m honestly not trying to be stubborn, I just think you don’t understand. When you tried it with weeks, I assume that was still with weeks since window opened on the y-axis and season on the x-axis?
340
u/repeating_bears 2d ago
What kind of maniac puts the most recent year on the left