Tag: TTEST
-
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…
-
What does the value in cell A33 tell you about the hypothesis. Do we reject the null hypothesis? Why? Put your explanation in cell A36.
One sample t Test We are now going to use Excel to test a hypothesis based on one given sample. We would like to know if the average cholesterol level of patients in intensive care is equal to 200 and for that reason we collect cholesterol level of 20 random people from various intensive care…