BSc in Medical Physiology and Therapeutics:
MGEM2018 – Contemporary Insights and Skills for MPT
Coursework Portfolio Task: Statistics Workbook 20-21
Description: This worksheet is a collection of scenarios for you to work through applying the statistics you have learnt this year and in Study and Academic Skills for MPT last year. Please complete this in conjunction the materials you have been previously taught and with the use of GraphPad Prism.
COMPLETION AND SUBMISSION OF THIS WORKSHEET IS A REQUIRED COMPONENT OF THE COURSEWORK PORTFOLIO FOR MGEM2018.
Instructions:
• Answer the questions in this worksheet using previously taught techniques and GraphPad Prism, using the previous teaching materials to guide yourselves should you need them.
• You will need to download and use Prism to analyse data sets from a number of different examples (all data needed is in the associated excel spreadsheet available on the Moodle page). You will need to showcase what you have learnt about how to apply appropriate statistical tests to the data and how to interpret and present the results.
• To download Prism, please go to the university of Nottingham software library via the following link:
o https://www.nottingham.ac.uk/it-services/software/software.aspx
o Once on this webpage, scroll down to “Open the Software library (log in required)”, click on this and sign in.
o Once in the library you will find a search bar and you need to search for Prism.
o On the results page, click on “GraphPad PRISM” and follow the download and install instructions.
o NOTE: this site clearly states “GraphPad PRISM software downloads – Staff and PGR only” please ignore this, as although this true for 99% of students and courses, MPT students do have access to this and should follow the instructions the same as PGR students.
o Once you have installed the software follow the instructions when you open the software to get a license key.
o This is not a difficult process as long as you follow the instructions fully and carefully. If you have any issues with this, please drop me an email.
• also be aware the email you will receive confirming the license key from Prism can take up to 24 hours to be delivered to your university email inbox so I strongly suggest downloading this software asap to test that that it works and avoid issues close to the deadline.
• This document, once complete will need to be submitted as part of the coursework portfolio collection for MGEM2018, for which the deadline is:
3:00 PM Thursday 20 May 2021
• There is no specific word limit for this component, but marks for difference parts of this workbook are stated below. Despite there being no word limit you are advised to be as concise as possible in getting across your answers and aim for somewhere in the region of 25 – 50 words (max) per mark, but this will depend a little on the question that is being ask and for some marks a simple few words answer will suffice.
• It is essential you clearly show workings in your answers as marks will be awarded for this – try to relate what you are doing back to the teaching/materials and talk through how you are getting to your answers to the scenarios, and ensure you show any relevant workings getting you to the answers.
• Marks for each question/part of a scenario are stated in the question/lead in – there are a total of 50 marks spread across 5 scenarios.
Scenario 1:
From what you have been taught previously and the slides on Moodle, please complete the required exercises below in relation to data scenario 1 (the 1st sheet of the Excel workbook associated with this task and available on Moodle). (10 marks total for scenario)
1) In terms of N.O.I.R. what kind of data do you have here? (1 mark)
2) Using prism, the statistics flow chart and the nature of the data set, what statistical tests will you need to conduct to compare all the groups?
In your answer, walk through the steps of the flowchart showing what final tests you would do (e.g. ANOVA/T-Test/Kruskal-Wallis/Fishers etc.). Ensure you describe what normality tests have you done, what variance tests are you using and how this information dictates what final test you have done. (you will need to analysis the data in prism to achieve this answer). (4 marks)
3) Is there a statistical difference between (all) the groups? report this as; the test that was done, the P value, and whether or not this is statistically significant (assuming threshold of P<0.05 for significance). (3 marks)
4) These tests have given you a fair amount of statistical/mathematical information but what infrences and interpretations can you make from these statistics in the context of the specific scenario (e.g. is this finding of note? are there potenial confounds? Etc.) – give 2 examples of potential inferences / interpretations you could make? (2 marks)
Scenario 2:
From what you have been taught previously and the slides on Moodle, please complete the required exercises below in relation to data scenario 2 (the 2nd sheet of the Excel workbook associated with this task and available on Moodle). (12 marks total for scenario)
5) In terms of N.O.I.R. what kind of data do you have here? (1 mark)
6) Using prism, the statistics flow chart and the nature of the data set, what statistical tests will you need to conduct to compare all the groups? In your answer, walk through the steps of the flowchart showing what final tests you would do (e.g. ANOVA/T-Test/Kruskal-Wallis/Fishers etc.). Ensure you describe what normality tests have you done, what variance tests are you using and how this information dictates what final test you have done. (you will need to analysis the data in prism to achieve this answer). (5 marks)
7) Is there a statistical difference between (all) the groups? Feport this as the test that was done, the P value and whether or not this is statistically significant (assume threshold of P<0.05). (2 marks)
8) As there are multiple groups in this data set (more than 2) what post hoc statitical test do you need to do compare individual groups against the control? What are the p-values for these multiple comparisons using this test? which groups/comparisons are significantly different (again, assume threshold of P<0.05)? (2 marks)
9) These tests have given you a fair amount of statistical/mathematical information but what infrences and interpretations can you make from these statistics in the context of the specific scenario (e.g. is this finding of note? are there potenial confounds? Etc.) – give 2 examples of potential inferences / interpretations you could make? (2 marks)
Scenario 3:
From what you have been taught previously and the slides on Moodle, please complete the required exercises below in relation to data scenario 3 (the 3rd sheet of the Excel workbook associated with this task and available on Moodle). (16 marks total for scenario)
10) Using prism, the statistics flow chart and the nature of the data set, what statistical tests will you need to conduct to compare all the groups? In your answer, walk through the steps of the flowchart showing what final tests you would do (e.g. ANOVA/T-Test/Kruskal-Wallis/Fishers etc.). Ensure you describe what normality tests have you done, what variance tests are you using and how this information dictates what final test you have done. (you will need to analysis the data in prism to achieve this answer). (5 marks)
11) Is there a statistical difference between (all) the groups? report this as the test that was done, the P value and whether or not this is statistically significant (assume threshold of P<0.05). (2 marks)
12) As there are multiple groups in this data set (more than 2) what post hoc statitical test do you need to do compare individual groups against each other? What are the p-values for these multiple comparisons using this test? which groups/comparisons are significantly different (again, assume threshold of P<0.05)? (2 marks)
13) Produce an appropriate graph with approprate statistics shown on it and an a supporting figure legend to explain what is shown on the graph, any statistics to report or notatitions that need explaining. This should have appropriate axis, titles, and statistics shown on it (5 marks)
14) These tests have given you a fair amount of statistical/mathematical information but what infrences and interpretations can you make from these statistics in the context of the specific scenario (e.g. is this finding of note? are there potenial confounds? Etc.) – give 2 examples of potential inferences / interpretations you could make? (2 marks)
Scenario 4:
From what you have been taught previously and the slides on Moodle, please complete the required exercises below in relation to data scenario 4 (the 4th sheet of the Excel workbook associated with this task and available on Moodle). (6 marks total for scenario)
15) With workings and walkthrough, please calculate the odds/likelyhood ratio of males being symptomatic compared against females. (3 mark)
16) Assuming this was study was complete and being put forward for future application; please calculate (with workings and walkthrough), the relative risk of females being symptomatic compared against males. (3 mark)
Scenario 5:
From what you have been taught previously and the slides on Moodle, please complete the required exercises below in relation to data scenario 5 (the 5th sheet of the Excel workbook associated with this task and available on Moodle). (6 marks total for scenario)
17) In terms of N.O.I.R. what kind of data do you have here? (1 mark)
18) With workings and walkthrough, use an appropriate statistical test (hint: use the other flow chart) to show if there is a significant statistical difference between the vegetarians and the meat eaters and “midnight” snacking. report this as the test that was done, the P value obtained and whether or not this is statistically significant (assume threshold of P<0.05). (5 mark)