I need use EXCEL to get the correlation r.
The data is about comparing the femur and humerus bones (in centimeters) of 5 specimens of bones to determine if they’re the same species. It is suggested that if theres a strong correlation between the two bone sizes per creature, that then the 5 specimens are all the same species, just small and big (young and older) versions of the animal.
Femur: 38 56 59 64 74
Humerus: 41 63 70 72 84
I have already calculated by hand, the correlation r for this data.
r = (1/4)(3.9762) = .9941
Now I know the formula and can do it by hand but I am also required to do it on the TI83 plus as well as Microsoft Excel.
I do not know how to use either. Could someone help me with detailed instructions on how to do it, especially EXCEL?
For Excel, I know to go to “Tools>Data Analysis>Correlation” but the window it brings up confuses me and I need to know the exact correct syntax to produce a successful calculation.
Assume that this is my excel sheet:
[ A ] [ B ]

38 41

56 63

59 70

64 72

74 84
Thanks.