0

# How to calculate p value

Thu 1 Dec, 2022 10:10 am
I'm a nurse (WOCN) and have recently conducted a research in our hospital with the goal to determine, what the number of pressure ulcers is, if patients have appropriate mattresses etc.
I'd like to calculate (in excel), if there is a significant statistical difference between certain groups of patients.
E.g. 25 patients do not have an appropriate mattress, 250 patients do. Is this number (25) statistically significant?
Etc.
• Topic Stats
• Top Replies
Type: Question • Score: 0 • Views: 198 • Replies: 2
No top replies

engineer

2
Thu 1 Dec, 2022 12:37 pm
@Bilch,
The more data you have, the smaller a difference will be considered "statistically significant". Whether 25 is enough depends on how big a difference you are trying to detect.

The first thing you need to do is define your independent variables. One of them is "appropriate mattress, YES or NO". Are there other variables that are known to be significant? Body Weight? Gender? Age? Length of hospitalization? Any variable that is already known or suspected of contributing to pressure ulcers should be recorded. I found this reference.

More to your question, Excel has a few functions you can use depending on the number of independent variables in your data. If you us 1 and 0 for your appropriate mattress question, and you don't have any other independent variables, you could use TTEST. If you have several independent variables and they are fairly linear, you could use LINEST.
Bilch

1
Fri 2 Dec, 2022 01:16 am
@engineer,