Need solution for problem desperately! Totally clueless in biostatistics!

2 posts / 0 new
Last post
kafandiyev's picture
Need solution for problem desperately! Totally clueless in biostatistics!

 Hello... I bet you didn't even understand what I'm talking about... 

As a complete illiterate person in terms of biostatistics let me put it that way:

The problem is about two study groups regarding the lesion size at the lip and the time of admission since the onset of the lesion.

I divided the group into two categories: those who have T1(0-2cm) size lesions and those who have T2(2-4cm) size lesions.

I wrote down the size of the lesion and corresponding time of the admission to the hospital for each patient in each group (T1 and T2).

According to average calculations
1- the mean size of the lesions in the T1 group is 1.16 cm2 and the average admission time is 6.2 months. For the T2 group the average size is 5.06 and the mean admission time is 9.9 months.

It is obvious that those who admit late have bigger tumors.

My question is:
what is the best test to calculate the reliability of this correlation? 
What program can use for that? I have only excel...
And what are the names of statistical calculations I have to make?

Here are the two groups:
Admission time vs Size of the lesion
6 0.25
7 0.5
12 0.5
3 0.5
6 1
6 1
6 1
7 1
4 1
3 1
4 1
6 1
15 1.5
5 1.5
12 1.5
4 1.5
2 1.5
12 2
3 2
1 2
6.2 1.1625

5 2.5
12 3
2 3
12 6
9 6
9 4
6 8
24 8
9.875 5.0625

I will very very much appreciate any help... 

Thank you very much in advance...

Rina's picture
I would suggest you can try

I would suggest you can try correlation test, which is CORREL function in excel. For this you will have to summarize all your data in 2 arrays: array 1- time and array 2 -lesions size.
Statistically, many time groups you have consist of a single event ( one patient only), which make many statistical functions not applicable. For more competent answer I would suggest you contact statisticians.