Find solution
What statistical analysis should I use?

What kind of Excel formula or data analysis to use in a statistical study? Example included?

  • I'm making a study about whether the more surgery you get, the higher the mortality rate is (on a specific disease). here is the data first column: number of interventios (surgery) that patients went through: values are 1, 2, 3, 4 second column: number of patients that went through those interventions: values are 27, 9, 3, 1 third column: how many died after they underwent respectively 1, 2, 3, or 4 interventions: values are 9, 4, 2, 0. So the one guy that went through 4 interventions did not die, 27 went through 1 intervention and out of these 9 died, etc. All I want is to find what corelation is between the number of interventions and the mortality rate. Pls help, I suck at math, but I can find my way around in excel (I can find a function etc, but I have no ideea what it does).

  • Answer:

    12790.333333333 2940.444444444 3320.666666667 4111 These are in Columns A to D rows 1 to 4 Made a new cell with =Correl(A1:A4,D1:D4) And -0.361478446 is the answer. However, THIS IS AN INAPPROPRIATE MEASURE OF ANY RELATIONSHIP I just thought i would point that out. The sample sizes in the bottom two are too small. As well it is an inappropriate model. Consider if you ignored the case with 4 interventions who did not die. =CORREL(A1:A3,D1:D3) 0.981980506 See how much it changes? This is not a good method. You need to do something else. I suggest regrouping. EDIT also if you change the value in 4 interventions to 1 you get a correlation of 0.975900073. You may even want to omit that data.

Paul C at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

First of all, you must understand that this sample size in each number of interventions is too small to make any statistical conclusions with a high probability of being right. Minimum sample size for each intervention should be 30. And, you should have a minimum of 30 diff readings of death and number of interventions. If you still want to go ahead and do it, then add solver tools and run a regression with these values.

DG

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.