0
   

How to calculate p value

 
 
Bilch
 
Reply 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.
Thanks in advance
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 370 • Replies: 2
No top replies

 
engineer
 
  2  
Reply 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  
Reply Fri 2 Dec, 2022 01:16 am
@engineer,
Many thanks for your answer!
0 Replies
 
 

Related Topics

 
  1. Forums
  2. » How to calculate p value
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 11/10/2024 at 06:07:36