Scenario 1:
Dependent/Paired Samples T-test
A performance analyst for an elite football team are interested to identify if his players are scoring more goals during home matches when compared with away matches during the last season. Using the data under the tab marked “ Dependent T-test – Goals Scored ” on Microsoft Excel, you need to perform a dependent/paired samples T-test to identify the following information:
1. What is the dependent variable for scenario 1? (1 mark)
2. What is the independent variable for scenario 1? (1 mark)
3. Is scenario 1 a between or repeated measures research design? (1 mark)
4. What are the mean values (rounded to the nearest whole number) for goals scored at home and away for scenario 1? (2 marks)
5. What are the standard deviation values (rounded to the nearest whole number) for goals scored at home and away for scenario 1? (2 marks)
6. What is the degrees of freedom for scenario 1? (1 mark)
7. Is the T-Statistic for scenario 1 significant? (1 mark)
8. What is the P value (Two tailed) for scenario 1? (1 mark)
9. As per the guidance you were provided within both the lectures and workshops from this unit, write your results within a sentence as you would for a lab report? (5 marks)
Scenario 2:
Independent T-test
A physical education (PE) teacher is interested in comparing the enjoyment levels of his lessons between the male and female students. Enjoyment was measured on a 1-10 scale after each lesson (1 = no enjoyment at all; 10 = extreme enjoyment). Using the data under the tab marked “ Independent T-test – Enjoyment ” on Microsoft Excel, you need to perform an independent T-test to identify the following information:
1. What is the dependent variable for scenario 2 (1 mark)
2. What is the independent variable for scenario 2 (1 mark)
3. Is scenario 2 a between or repeated measures research design? (1 mark)
4. What are the mean values (presented to one decimal place) for enjoyment in males and females for scenario 2? (2 marks)
5. What are the standard deviation values (presented to one decimal place) in males and females for scenario 2? (2 marks)
6. What is the degrees of freedom for scenario 2? (1 mark)
7. Is the T-Statistic for scenario 2 significant? (1 mark)
8. What is the P value (Two tailed) for scenario 1? (1 mark)
9. As per the guidance you were provided within both the lectures and workshops from this unit, write your results within a sentence as you would for a lab report? (5 marks)
Scenario 3:
Pearson’s Correlation
The same PE teacher is also interested about how the enjoyment scores of all students was correlate with lesson attendance throughout the year. Enjoyment was measured on a 1-10 scale after each lesson (1 = no enjoyment at all; 10 = extreme enjoyment). Attendance was measured as a percentage throughout the year. Using the data under the tab marked “ Corr – Enjoyment and attendance ” on Microsoft Excel, you need to perform a Pearson’s correlation to identify the following information:
1. What is the predictor and criterion variables for scenario 3? (2 marks)
2. What is the R value (Presented to two decimal places) for scenario 3? (1 mark)
3. What are the mean values (presented to one decimal place) for enjoyment and attendance? (2 marks)
4. What are the standard deviation values (presented to one decimal place) for enjoyment and attendance? (2 marks)
5. What is the direction of the correlation for scenario 3? (1 mark)
6. What is the strength of the correlation for scenario 3 (1 mark)
7. Produce an appropriate graph to show the relationship between the criterion and predictor variable? (2 marks)
8. What is the degrees of freedom for scenario 3 (1 mark)
9. Does the correlation analysis for scenario 3 show a significant relationship and how is this demonstrated? (1 mark*) – *You must provide a reason to get this mark
10. As per the guidance you were provided within both the lectures and workshops from this unit, write your results within a sentence as you would for a lab report? (5 marks)