Tag: CORREL
-
Is the correlation evaluated in cell A15 positive or negative. Put your answer in cell A23.
Dependent groups t Test testing two mean differences We are now going to use Excel to find information on correlation between two dependent groups. We would like to know if the cholesterol level depends on the age and for that reason we collect cholesterol level of 10 people, first when they were 17 and then…
-
Is the correlation you obtained in cell A13 weak, moderate or strong? State your result in cell A14.
• We would like learn about the correlation coefficient using Excel. Lets look at the following question. • To find out how genetically related the cholesterol level is, they measured the cholesterol level of eight mothers and their daughters. They obtained the following data. • • Mother Her daughter • 157 154 • 189 150…