Welcome @sorukumar!
Since Foundry had it’s first 7-block streak at the end of 2022 (2022-11-06), when they were already close to 30% hashrate (and probably had slightly more than 30% hashrate since the beginning of 2023 on average; I haven’t checked in detail), I think it makes sense to do this calculation again with e.g. 30% and 32% hashrate numbers instead of 24%.
See Foundry Hashrate
I was curious how you calculate this for e.g. SpiderPool. The data on your page suggests it’s using data from 2021 till now and are using an average hashrate over that time, but SpilderPool did have highly variable hashrate through this period. I’d assume that for a pool going from 0% to 10% hashrate in two years (and no blocks before) doesn’t produce a usable average? See mempool.space/mining/pool/spiderpool
Might be better to look at shorter timeframe without much variance in hashrate? Or graph the expected and observed “Second Block Uplift” on e.g. a per-month level per pool?