Michael Hobbes: I spent the morning collecting all of the data on hormones and mental health for trans kids. Here are the results of every single study and the UK review's utterly disingenuous takeaway.

I spent the morning collecting all of the data on hormones and mental health for trans kids. Here are the results of every single study and the UK review's utterly disingenuous takeaway.

also for the love of god someone teach me how to use excel this took me like 5 hours

1. Open Excel 2. Close Excel again 3. Open Google Sheets instead

Is there no systematic review for this?

Because if not, you've already done quite a lot of the work..

I mean, the tables were already done, i just had to convert them from pdf and merge two of them. If I knew excel it probably would have taken like 25 minutes lol

Opening the PDF in Word (it does that, just takes some time) might make the formatting a lot more convenient for copying. If you're serious about learning Excel stuff ask me any question, it's a hobby of mine.

happen to know any linux/unix tricks? (both come with lots of doc, pdf, and similar tools as well as a couple office suites now) or know anyone who would? goin back to college lol

this IS the systematic review! And Cass's summary of it

Aha, apologies!

This was the data used in a systemic review that was, frankly, garbage.

The wildest thing is that there's only 5 studies that meaningfully looked into this. Everyone is fighting over which review to use but with that few studies you might as well just talk about the results directly.

Drop-down data validation and conditional formatting (for color coding) would be your friend here

I’d help you with the data cleaning and organizing!

The discord is full of Excel nerds, you can just ask us next time 😁

The idea that I'm better at something than Michael Hobbes is shocking.

My local library district gives classes on Excel for freeeeee, check and see if yours does the same! If not group classes, some places will let you make an appointment w/a staff person who can spend time teaching you

TBH I write scripts to export to CSV files as part of the work. Simple that way to just include it in your Python.

weird how the data always seems to be perfectly sufficient to draw negative/skeptical conclusions, even when the results are overwhelmingly positive.

Given the political fervor, a kid transitioning is probably going to be exposed to increased bullying and other kinds of ostracization, and mental health outcomes are always hard to measure, so this is especially impressive.

Their conclusion certainly doesn't fit the evidence in the table. Every one of the studies showed an improvement in mental health following hormone treatments.

Yeah, a lot of the studies were downgraded for factors such as small sample size, and single clinic samples. Those are certainly limitations of the studies, but that’s a perfect opportunity to combine the results. Could they not have done a meta-analysis, rather than a narrative synthesis?

michael are you doing a meta-analysis

Sounds like someone should write a systematic review/meta analysis!

I’m “on vacation” so I may be telling you what you already know, but I believe this systematic review was specifically funded to inform the Cass Review: adc.bmj.com/content/earl... . It certainly words some things differently…

adc.bmj.com

💜

I knew you'd have the goods on this.

Thanks. This is great. And will be very useful to me.

This looks really useful, but could you put in the alt text, please?

Post