I've been looking into subsector / boxel metallicity and ELW / systems ratios for some time, but then carriers and such put that on hold. Now, with some more data since then, I redid the analysis and finished writing things up so that I can post them now.
First off, an intro to those who might not know what exactly I might be talking about. If you're familiar with boxels, metallicity and such, feel free to skip this part.
On to the methodology: I used the EDSM data dump from 2020/09/30, and processed metallicity and ELW data from @Orvidius 's EDAstro. I broke down two sectors into boxels, counted the ELWs and total systems in each boxel, then compared the ELW / Sys ratios of boxels to their Helium levels (min / max / average / diff). To get rid of outlier ELW / Sys ratios from boxels where there's 1 ELW and 1 system visited, I set two cut-off levels: charting only boxels with over 100 systems discovered, and only those with over 500.
As it turns out, there aren't that many sectors which have enough systems spread over enough boxels visited that it's worth analysing them. In the end, I chose two sectors: Eol Prou, for obvious reasons, and the nearby Eoch Flyuae sector. (Sectors around the bubble might also have been good, but they are carved up by all the spherical sector overrides, and it would be a pain to stitch all those together - especially when a sphere overlaps more than one sector.)
The results were somewhat surprising: contrary to what I expected, it turns out that more metallicity as in higher Helium levels lead to lower ELW ratios. This isn't true the other way around: just because a boxel has less Helium doesn't mean it'll have more Earth-likes, only that it might have more. Or it might not. Helium levels alone won't tell you that, but they can be handy to judge where not to stay.
Take a look at these charts (the rest can be found on the sheets I'll link below):
Average He% in Eol Prou, subsectors with over 100 systems, and with over 500 systems:

Or the same two in Eoch Flyuae instead:

The other charts (min / max / diff) are quite similar too.
It's worth noting how the majority of boxels tend to fall below the 0.02 ELW / Systems ratio, which would be the often-cited "1 in 50 systems". But when it comes to boxels where we had over 500 systems visited, in Eol Prou, only five of them had a better ELW / Sys ratio than that. So in boxels with, say, 150-250 systems, you might see the luck of the draw produce quite high ratios, but as you explore more, it'll even out.
So, the summary: boxels with higher Helium levels tend to have fewer ELWs per systems, but that doesn't mean boxels with lower Helium levels are going to have more ELWs per systems. What it does mean that if you want those, you'll likely want to spend more time hanging around in boxels with as low Helium levels as you can go. If you're lucky, you might find one with higher than usual chances for ELWs.
I'd be quite curious about doing the same somewhere inside the galactic core, but we could use more data there. Especially data outside the suppression corridor, and unfortunately, Sagittarius A* and Explorer's Anchorage are smack in the middle of that. There is a cap on maximum Helium levels inside the core, which is why no non-bugged HRGGs have been found there (see the HRGG map on EDastro): I'd be curious to see if this has any effect or not. However, such a survey would require a large coordinated effort - let's see, to at least match Eoch Flyuae, we'd need 30 boxels with at least 500 systems, and 300 boxels with at least 100. So that's a minimum of 30,000 systems.
Well, in any case, I'll revisit this later, and see what other sectors might be worth looking at.
Also, this is just an anecdote, but to me, while exploring boxels with higher Helium levels, it seemed like they have more gas giants, and less planets. I might look into this later too, but in the meantime, I would be interested if others have observed the same. If (if) it were true, then that might explain why such boxels look to have fewer ELWs - but I am not an astrophysicist, and I have no idea how the Forge models planet formation.
Here's all the data and the other charts then:
Eol Prou at https://docs.google.com/spreadsheets/d/1ZNvjJnPcsdHyJRrpDpM9XWA_nN8zwH58DS__bVeurao/edit?usp=sharing
and
Eoch Flyuae at https://docs.google.com/spreadsheets/d/1FCnAUKavGh2OZAq1y290lc_8XdDkRjBVhlec0R1d3tA/edit?usp=sharing
Hope this was useful to someone. Thanks for reading!
First off, an intro to those who might not know what exactly I might be talking about. If you're familiar with boxels, metallicity and such, feel free to skip this part.
So, subsectors or boxels are the smaller parts of sectors, where systems share some similarities, such as the system mass, determined by the ZAMS mass of the main star, and curiously, also the Helium percentages in gas giants. The way the galaxy is structured is sector -> boxel -> system, for example: Synuefe AR-D d12-6 would be Synuefe sector, AR-D d12 boxel, 6 system. (The mass code, which is often referenced, is the last letter in the boxel, which can go from a to h. In this case, it's d.)
For further reading, see the Sector Naming article on the DISC wiki.
As for boxel metallicity, we measure the Helium levels in gas giants then.
For further reading, see the Sector Naming article on the DISC wiki.
As for boxel metallicity, we measure the Helium levels in gas giants then.
On to the methodology: I used the EDSM data dump from 2020/09/30, and processed metallicity and ELW data from @Orvidius 's EDAstro. I broke down two sectors into boxels, counted the ELWs and total systems in each boxel, then compared the ELW / Sys ratios of boxels to their Helium levels (min / max / average / diff). To get rid of outlier ELW / Sys ratios from boxels where there's 1 ELW and 1 system visited, I set two cut-off levels: charting only boxels with over 100 systems discovered, and only those with over 500.
As it turns out, there aren't that many sectors which have enough systems spread over enough boxels visited that it's worth analysing them. In the end, I chose two sectors: Eol Prou, for obvious reasons, and the nearby Eoch Flyuae sector. (Sectors around the bubble might also have been good, but they are carved up by all the spherical sector overrides, and it would be a pain to stitch all those together - especially when a sphere overlaps more than one sector.)
The results were somewhat surprising: contrary to what I expected, it turns out that more metallicity as in higher Helium levels lead to lower ELW ratios. This isn't true the other way around: just because a boxel has less Helium doesn't mean it'll have more Earth-likes, only that it might have more. Or it might not. Helium levels alone won't tell you that, but they can be handy to judge where not to stay.
Take a look at these charts (the rest can be found on the sheets I'll link below):
Average He% in Eol Prou, subsectors with over 100 systems, and with over 500 systems:


Or the same two in Eoch Flyuae instead:


The other charts (min / max / diff) are quite similar too.
It's worth noting how the majority of boxels tend to fall below the 0.02 ELW / Systems ratio, which would be the often-cited "1 in 50 systems". But when it comes to boxels where we had over 500 systems visited, in Eol Prou, only five of them had a better ELW / Sys ratio than that. So in boxels with, say, 150-250 systems, you might see the luck of the draw produce quite high ratios, but as you explore more, it'll even out.
So, the summary: boxels with higher Helium levels tend to have fewer ELWs per systems, but that doesn't mean boxels with lower Helium levels are going to have more ELWs per systems. What it does mean that if you want those, you'll likely want to spend more time hanging around in boxels with as low Helium levels as you can go. If you're lucky, you might find one with higher than usual chances for ELWs.
I'd be quite curious about doing the same somewhere inside the galactic core, but we could use more data there. Especially data outside the suppression corridor, and unfortunately, Sagittarius A* and Explorer's Anchorage are smack in the middle of that. There is a cap on maximum Helium levels inside the core, which is why no non-bugged HRGGs have been found there (see the HRGG map on EDastro): I'd be curious to see if this has any effect or not. However, such a survey would require a large coordinated effort - let's see, to at least match Eoch Flyuae, we'd need 30 boxels with at least 500 systems, and 300 boxels with at least 100. So that's a minimum of 30,000 systems.
Well, in any case, I'll revisit this later, and see what other sectors might be worth looking at.
Also, this is just an anecdote, but to me, while exploring boxels with higher Helium levels, it seemed like they have more gas giants, and less planets. I might look into this later too, but in the meantime, I would be interested if others have observed the same. If (if) it were true, then that might explain why such boxels look to have fewer ELWs - but I am not an astrophysicist, and I have no idea how the Forge models planet formation.
Here's all the data and the other charts then:
Eol Prou at https://docs.google.com/spreadsheets/d/1ZNvjJnPcsdHyJRrpDpM9XWA_nN8zwH58DS__bVeurao/edit?usp=sharing
and
Eoch Flyuae at https://docs.google.com/spreadsheets/d/1FCnAUKavGh2OZAq1y290lc_8XdDkRjBVhlec0R1d3tA/edit?usp=sharing
Hope this was useful to someone. Thanks for reading!