Statistical example

Calculate in the set of patients (attached table 1)
A) using the table editor EXCEL
B) with the program "Social Science Statistics Calculator" (SSSC) on the web page
a) the average age of the patients and the standard deviation (STDEV)
b) the average duration of hospitalisation and the standard deviation (STDEV)
c) Pearson's correlation coefficient (PEARSON or CORREL) between the age of the patient and the length of his hospitalisation.
d) According to Cohen's scale (given below table 2), determine the measure of this correlation.

Plot the X-Y scatter graph (dependence) of the length of hospitalisation on age where "X-age of patient, Y - duration of hospitalisation.

Table 1.
Order Age of patient in years Length of hospitalisation In days
1. 35 5
2. 73 10
3. 47 9
4. 60 11
5. 25 5
6. 77 17
7. 41 7
8. 63 11
9. ? ?
10. ? ?

Fill in freely chosen data in place of the question marks! Aid: Table 2. Cohen's scale for interpretation of the correlation coefficient R

Value of R coefficient Type of correlation
below 0.1 Trivial
0.1 - 0.3 Small
0.3 - 0.5 Medium
0.5 - 0.7 Large
0.7 - 0.9 Very large
above 0.9 Almost perfect

Final Answer:

a =  
b =  
d =  
d =  

Try another example