Data structure for p-value analysis of medical data I have a good-sized data set containing details and outcomes of various types of injury. I've worked through it and cleaned the data as best I can - it's now consistent and complete.
At this point I'm focusing on 3 main types of injury: gunshot, stab wound and blunt force trauma (variable values of 1, 2 and 3). Outcomes are binary: survival and death (0 and 1).
The hypothesis I'd like to test is "Gunshot victims are more likely to die from their wounds". (The mortality rates are already well known, so this analysis is mostly just an exercise)
I'm not a statistician, so will likely have the analysis done by someone else. My question is this: how should I structure the data for analysis? I currently have a spreadsheet containing all the data with many more points (ICU duration, etc). Should I submit just 2 columns pertaining to the aforementioned variables? Note I'm not testing in relation to other variables such as injury location etc.
Alternatively, if testing the hypothesis / calculating p-score is something I can do myself with reasonable reading and effort that would be great - I'm always happy to learn something new.

It sounds like you have one categorical predictor/independent variable (injury) and one binary/categorical response/dependent variable (survival outcome). While many analysts have preferences for data formatting, the most versatile format for sharing your data is probably a spreadsheet (in .csv or a variation of excel format) that has 5 columns:




Gunshot
Stab
Blunt Force
Survived
Died




1
0
0
0
1


0
1
0
1
0


0
0
1
0
1




A value of '1' in the column indicates the categorical event occurred for the experimental unit (a victim in your case). I would be surprised if any analysts can't easily manipulate this format into their more preferred formatting should choose to.
As for performing this analysis yourself, I would highly recommend taking 15-30 minutes to read about the capabilities of Excel to help in performing this analysis. For people of all backgrounds, learning this task for "simple" analyses requires minimal effort in return for a useful skill. Some test options are Chi-Squared test for association or a linear regression.
