Please log in or register. Registered visitors get fewer ads.
Forum index | Previous Thread | Next thread
Table without matches against top 6 15:57 - Sep 16 with 2616 viewsBedfordBlue

I was interested to see what a table showing only matches played against sides from last season's top 6 would look like, so I dusted off some Excel formulas and put one together:
https://docs.google.com/spreadsheets/d/1c9ifwhcyhDFH2kO7Kww_g-SosaIfho9JSXduY6bC

[Post edited 16 Sep 2024 19:06]
1
Table without matches against top 6 on 17:53 - Sep 16 with 2336 viewsbsw72

I'm curious to ask and not knocking any form of excel wizadry as data analysis is one of my professional things - but what does that tell us?
0
Table without matches against top 6 on 17:56 - Sep 16 with 2311 viewshoppy

Table without matches against top 6 on 17:53 - Sep 16 by bsw72

I'm curious to ask and not knocking any form of excel wizadry as data analysis is one of my professional things - but what does that tell us?


That Everton are still shîte whichever way you look at it?

Poll: Which Which nickname for ITFC do you prefer? poll do you prefer?
Blog: Graphical Blog: I Feel the Need...

4
Table without matches against top 6 on 18:02 - Sep 16 with 2265 viewsStadiumofdark

Table without matches against top 6 on 17:56 - Sep 16 by hoppy

That Everton are still shîte whichever way you look at it?


Norwich & Leeds don't appear, whichever way you cut it.
0
Table without matches against top 6 on 18:19 - Sep 16 with 2170 viewsMK1

Table without matches against top 6 on 17:53 - Sep 16 by bsw72

I'm curious to ask and not knocking any form of excel wizadry as data analysis is one of my professional things - but what does that tell us?


That we can lose all 12 games against the top 6 (which changes throughout the season?) and finish no worse than 16th. Apparently.

Poll: New hobby suggestions for NeedhamChris.

0
Table without matches against top 6 (n/t) on 18:54 - Sep 16 with 2045 viewsBedfordBlue

Table without matches against top 6 on 17:53 - Sep 16 by bsw72

I'm curious to ask and not knocking any form of excel wizadry as data analysis is one of my professional things - but what does that tell us?


Nothing too ground breaking!

I was just looking at ways to get a fairer idea of league positions by levelling the effect of some teams (like us) having played a couple of top sides already, while other teams having played none of last season's top 6 yet.

Using that logic, we're pushed up a couple of places from 17th to 15th in the table. Not a big change and early days, but I was just interested to see how this calculation worked out.
[Post edited 16 Sep 2024 18:59]
0
Table without matches against top 6 on 19:44 - Sep 16 with 1918 viewsgringoblue

Surely that only shows a table of results against sides that were NOT in the top 6 last season? As your title and explanation don't match.
[Post edited 16 Sep 2024 19:45]
0
Table without matches against top 6 on 20:15 - Sep 16 with 1826 viewspowinswitch

Table without matches against top 6 on 17:53 - Sep 16 by bsw72

I'm curious to ask and not knocking any form of excel wizadry as data analysis is one of my professional things - but what does that tell us?


To stick your house on Brentford getting a champions league spot



Not
0
Table without matches against top 6 on 20:37 - Sep 16 with 1757 viewsWestSussexBlue

Table without matches against top 6 on 17:53 - Sep 16 by bsw72

I'm curious to ask and not knocking any form of excel wizadry as data analysis is one of my professional things - but what does that tell us?


I’m trying hard to fathom this out, no I don’t get what the heck this tells us.
0
Login to get fewer ads

Table without matches against top 6 on 20:42 - Sep 16 with 1732 viewsFrimleyBlue

I think it get the point

Basically if we go a point per game against those not inside the top 6 last season then we should have enough to stay up.... ?

a niche perspective
Poll: We've had Kuqi v Pablo.. so Broadhead or Celina?
Blog: Marcus Evans Needs Our Support Not to Be Hounded Out

0
Table without matches against top 6 on 07:23 - Sep 17 with 1351 viewsKeno

Table without matches against top 6 on 20:42 - Sep 16 by FrimleyBlue

I think it get the point

Basically if we go a point per game against those not inside the top 6 last season then we should have enough to stay up.... ?


I think it highlights the overall significance of the expansion of the universe since the Big Bang as a constant and ever moving force which defies the known bounds of gravitional probability and, while not proving it completely, does emphasise the presence of a greater almost cosmic spirituality which in some cultures has been referred as a god or godlike entity but we simply refer as “McKenna”

But then again I may be overthinking it

Poll: At which of our last 10 games will be confirm EPL survival?
Blog: [Blog] My World Cup Reflections

0
Table without matches against top 6 on 09:24 - Sep 17 with 1144 viewsvilanovablue

Table without matches against top 6 on 17:53 - Sep 16 by bsw72

I'm curious to ask and not knocking any form of excel wizadry as data analysis is one of my professional things - but what does that tell us?


Southampton aren't doing well!
0
Table without matches against top 6 on 09:30 - Sep 17 with 1119 viewsGuthrum

Table without matches against top 6 on 20:42 - Sep 16 by FrimleyBlue

I think it get the point

Basically if we go a point per game against those not inside the top 6 last season then we should have enough to stay up.... ?


That would leave us on 26, likely not enough.

Good Lord! Whatever is it?
Poll: McCarthy: A More Nuanced Poll
Blog: [Blog] For Those Panicking About the Lack of Transfer Activity

0
Table without matches against top 6 (n/t) on 09:31 - Sep 17 with 1115 viewsSharkey

Table without matches against top 6 (n/t) on 18:54 - Sep 16 by BedfordBlue

Nothing too ground breaking!

I was just looking at ways to get a fairer idea of league positions by levelling the effect of some teams (like us) having played a couple of top sides already, while other teams having played none of last season's top 6 yet.

Using that logic, we're pushed up a couple of places from 17th to 15th in the table. Not a big change and early days, but I was just interested to see how this calculation worked out.
[Post edited 16 Sep 2024 18:59]


Well it halves the gap to Nottingham Forest.
0
Table without matches against top 6 on 09:37 - Sep 17 with 1091 viewsCotty

Table without matches against top 6 on 17:53 - Sep 16 by bsw72

I'm curious to ask and not knocking any form of excel wizadry as data analysis is one of my professional things - but what does that tell us?


Very little, n still way too small
0




About Us Contact Us Terms & Conditions Privacy Cookies Advertising
© TWTD 1995-2025