Yes, I know. I was asking if that had actually been done. The answer is evidently "no." I've read plenty of accounts of individual actions, but without collating and organizing them, and compiling comparative tables for other possible causes, "seeing clear patterns" is an invitation to subjectivity that undermines the point of basing opinions on facts.
If there were already such tables, it's a safe bet that everyone here would know about it
But while I know some people (to me very mysteriously) discount or down-rate operational history as facts, this is ultimately where the statistics come from, and I think they do 'rate' as useful and valid sources, even if they are incomplete or we can't be 100% certain about them (as we ever can for any historical records). I'm sure someone will count up losses and claims in the Mediterranean soon, and likely CBI as well. Pacific war operational history is still being compiled but that will come too.
Once these come out, as I already noted, needless to say people will contest them (sometimes for good and valid reasons, and quite often for crazy / delusional / emotional ones) and we'll be back in the weeds in the operational history anyway.
Until all this happens, we can just ignore operational history and believe that P-38s and F4Us and P-51As shot down 11-1 or 25-1 or whatever ridiculous the propaganda claim says, or we can start to look at it and draw provisional conclusions or at least make observations.

You can shout me down all you want, but I'm not the only one doing so. Real aviation historians are already publishing books and articles about this, in fact. It's not going away.
The other thing is that attributing this success or that failure to the qualities of the fighter courts the post-hoc fallacy, as those results may be due to many other factors, and are likely a combination of factors anyway.
Potentially that is true, as I've already pointed out, but we also have cases where for example both Ki-43s and A6Ms were operating against the same targets in the same area in the same conditions. You'll never be able to definitively prove anything but you can reach a more informed perception of the realities than was possible 30-40 years ago.
It's great that you have an opinion. but I want to see evidence that a machine-gun armament is as efficacious as a cannon-armament. It's okay if you don't have it, so long as you don't mind coming to terms with Hitchens's Razor.
Thank you so much, I'm delighted to have permission. My opinion wasn't, by the way, necessarily that machine guns are as good as cannon, all things being equal. It's the all-things being equal part. All things aren't equal and that's precisely the difficulty.
Let me pose to you a few questions to
you then.
Hawker Hurricane Mk IIC with four 20mm cannon. Top speed 330 mph.
P-39Q one 37mm cannon, four .50 caliber machine guns. Top speed 380 mph.
P-51A with 6 .50 caliber machine guns. Top speed 390 mph.
Are any of these better fighters than a Ki-43-I (two machine guns, top speed 308 mph)? I believe the operational history clearly tells us "
no".
Hawker Typhoon four 20mm cannon, top speed 412 mph vs Bf 109F2 with one 15mm and two 7.92 mm machine guns top speed 382 mph. Which one was better?
Spitfire Mk VB two 20mm cannon and four 7.7mm machine guns vs Bf 109F2 with one 15mm and two 7.92mm machine guns. Which was better?
Hawker Hurricane Mk IIC with four 20mm cannon, vs MC 202 with two 12.7mm and (maybe) two 7.7mm machine guns. Which was better?
Bf 110 two 20mm cannon and four 7.92 mm machine guns, 360 mph vs Yak 1B with one 12.7mm and one 20mm cannon, top speed 367 mph. Which came out on top?
Finally let me just say, Hitchen's razor? Christopher Hitchens was one of the most intellectually dishonest, devious, 'artful' debaters in our public sphere. He was one of the people who rationalized the Iraq War. I don't rate his theories, and I'm not setting out to 'prove' anything so it's a false premise.