Statistical analysis on Excel

[Dalach]

Hi there,

I am doing a medical research project using excel based data, and was wondering if it is possible to perform simple stats on excel without using SPSS?

 

[Dalach]

Thanks for the responses!
I've gone back and adjusted my data to create a more clear question, below is a sample of the new data


[TABLE="width: 363"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Attune[/TD]
[TD]Attune[/TD]
[TD]PFC[/TD]
[TD]PFC[/TD]
[/TR]
[TR]
[TD]Pre Op SF12[/TD]
[TD]6/12 post SF12[/TD]
[TD]Pre Op SF12[/TD]
[TD]6/12 post SF12[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD="align: right"]31[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD="align: right"]27[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]34[/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]27[/TD]
[/TR]
[TR]
[TD="align: right"]33[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]33[/TD]
[/TR]
[TR]
[TD="align: right"]31[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]29[/TD]
[/TR]
[TR]
[TD="align: right"]26[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]29[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]26[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD="align: right"]27[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD="align: right"]26[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]36[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]33[/TD]
[/TR]
[TR]
[TD="align: right"]24[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]26[/TD]
[/TR]
[TR]
[TD="align: right"]33[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]32[/TD]
[/TR]
</tbody>[/TABLE]

I am looking at two knee prothesis, the attune and PFC. The PFC is the standard knee that was used by the surgeon at my site, and he has recently changed to attune. The table above lists the values for both knee pre and postoperatively as scores out of 100 (a standardised orthopedic outcome score was used)
What I am interested in finding out is- does the attune knee offer IMPROVED outcomes over the PFC knee.
From what I understand so far i think the paired t test will give me information within each population, i.e, does the PFC knee offer improved outcome potop Vs preop.
How should I go about comparing the two types of knee?

 

[Dalach]

Just did Paired t test two sample for means on each of the populations, i.e pre/post PFC sf12 scores and pre/post WOMAC sf12.

heres what i got:

WOMAC:
[TABLE="width: 406"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]t-Test: Paired Two Sample for Means[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Variable 1[/TD]
[TD]Variable 2[/TD]
[/TR]
[TR]
[TD]Mean[/TD]
[TD="align: right"]29.40350877[/TD]
[TD="align: right"]31.0526316[/TD]
[/TR]
[TR]
[TD]Variance[/TD]
[TD="align: right"]7.280701754[/TD]
[TD="align: right"]4.40789474[/TD]
[/TR]
[TR]
[TD]Observations[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]57[/TD]
[/TR]
[TR]
[TD]Pearson Correlation[/TD]
[TD="align: right"]0.450096813[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hypothesized Mean Difference[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]df[/TD]
[TD="align: right"]56[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]t Stat[/TD]
[TD="align: right"]-4.850444957[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P(T<=t) one-tail[/TD]
[TD="align: right"]5.10394E-06[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]t Critical one-tail[/TD]
[TD="align: right"]1.672522303[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P(T<=t) two-tail[/TD]
[TD="align: right"]1.02079E-05[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]t Critical two-tail[/TD]
[TD="align: right"]2.003240719[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

PFC:
[TABLE="width: 383"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]t-Test: Paired Two Sample for Means[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Variable 1[/TD]
[TD]Variable 2[/TD]
[/TR]
[TR]
[TD]Mean[/TD]
[TD="align: right"]30.35088[/TD]
[TD="align: right"]30.43859649[/TD]
[/TR]
[TR]
[TD]Variance[/TD]
[TD="align: right"]7.267544[/TD]
[TD="align: right"]5.250626566[/TD]
[/TR]
[TR]
[TD]Observations[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]57[/TD]
[/TR]
[TR]
[TD]Pearson Correlation[/TD]
[TD="align: right"]0.096054[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hypothesized Mean Difference[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]df[/TD]
[TD="align: right"]56[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]t Stat[/TD]
[TD="align: right"]-0.19674[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P(T<=t) one-tail[/TD]
[TD="align: right"]0.422372[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]t Critical one-tail[/TD]
[TD="align: right"]1.672522[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P(T<=t) two-tail[/TD]
[TD="align: right"]0.844744[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]t Critical two-tail[/TD]
[TD="align: right"]2.003241[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

I would post the question and data from your post#11 to a statistical forum. A couple are listed below.
The people on these forms are dealing with your type of problem day to day and should be able to guide you on the proper tests to run and at what significance level.

Statistics Help @ Talk Stats Forum
Statistics Forum - Statistics Help

 

[SpillerBD]

I think it is as much being able to apply the correct function from Excel's library.
See the following webpage https://support.office.com/en-US/article/Statistical-functions-reference-624DAC86-A375-4435-BC25-76D659719FFD

Nice that the reference indicates what Excel version the functions are first available for.

 

[Aladin Akyurek]

@Dalach

1) What does mean 28 >> 31 in the first Attune record? That is, how do you interpret these scores?
2) Do the operations involve the same patients?
3) If the answer to [2] is no, are the patients matched, that is, are they comparable on the relevant aspects such as age, gender, severity, etc.?