am a Biomedical science master's student and I have statistics assessment which I am struggling with. I need to answer each question separately using SPSS software and explain which SPSS test and why was carried for each question and attach the PASW/SPSS output file as well. for questions 2 and 4 there is an extra excel sheet which contains the data.I will attach the file so you can have a look and let me know if you can help me with this.
General Instructions These questions require you to select and run appropriate statistical tests using SPSS and to write a fully detailed commentary explaining all of your reasoning and rationale. You must include all appropriate information from the SPSS Output file for each question and EMBED the output WITHIN the commentary at the appropriate place. The written commentary must: · be word-processed · only cover the points specified in the questions For each question detail what statistical test(s) were run, showing all relevant output generated and explain why this test(s) is appropriate? Marks will be awarded for (i) selection of correct procedures including those needed to verify test assumptions (ii) correct data entry and execution of tests (iii) overall presentation of the answer so that it contains only relevant material, in a logical order, neatly set out, without repetition. For the commentary, marks will be awarded for (i) general presentation and use of English (ii) grasp of statistical theory and concepts (iii) understanding of the SPSS Output. Mark allocation is as follows: Q1 20%; Q2 25%; Q3 25%; Q4 30%. Q1 It is thought that a new drug A might lead to a reduction in diastolic blood pressure. An experiment was performed using 20 male volunteers, 10 of whom were randomly selected to take a pill containing drug A and 10 who were randomly chosen to take a pill which contained placebo. Diastolic blood pressure was measured for the 2 cohorts following treatment. The values obtained for the diastolic blood pressure (mmHg) is shown below. Placebo Drug A 9071 9579 6769 12098 8991 9285 10089 8275 7978 8580 What can be deduced by statistical analysis about the effect of drug A on the diastolic blood pressure observed in this study? 20 marks Q2 A research laboratory is testing the effect of 5 different drug candidates on the concentration of nitric oxide (NO) in rat plasma to determine whether there is any difference observed for the different drugs. Dataset Q2_Autumn20.xls contains the concentration of NO, in mmol/L for an equal number of rats, obtained by random sampling, following treatment with the 5 different drugs. Using statistical analysis determine if the treatments result in a significant change to the concentration of NO in rat plasma and if so, where those differences lie. 25 marks Q3 A retrospective analysis was performed on 933 patients with clinically localised prostate cancer who underwent radical prostatectomy between March 1999 and July 2009. Some characteristics of the patients were recorded, and the patients were split into those with a low socioeconomic status (SES) who were treated in the public health system, and those with a high socioeconomic status who were treated in a private hospital. Low SES (n=379) High SES (n=554) Total (n=933) Age (years) <65 145="" 290="" 435="" 65="" and="" older="" 234="" 264="" 498="" serum="" psa="" (ng/ml)=""><10 244="" 342="" 586="" 10-20="" 100="" 163="" 263="">20 35 49 84 Pathological stage T2 272 415 687 T3 107 139 246 Tumour Grade / Gleason Score<7 193 344 537 7 or more 186 210 396 using statistical analysis investigate whether there is evidence that the socioeconomic status of the patient, is related to their age, serum prostate specific antigen (psa) level, pathological stage or tumour grade of the patient. discuss your results and any significant association found. for any significant association explain the nature of the association. 25 marks q4 a study was conducted to investigate whether the final exam result gained for a group of 25 biomedical science students was in any way dependent upon the results that the students had obtained in previous assessments. these being: · an in-class test · a coursework assignment · a mock exam the file q4_autumn20.xls details the marks obtained for the students final exam as well as their previous assessments. using the data contained within this file, determine by statistical analysis which variables have an impact on the final exam mark, and the extent of the relationship. 30 marks 193="" 344="" 537="" 7="" or="" more="" 186="" 210="" 396="" using="" statistical="" analysis="" investigate="" whether="" there="" is="" evidence="" that="" the="" socioeconomic="" status="" of="" the="" patient,="" is="" related="" to="" their="" age,="" serum="" prostate="" specific="" antigen="" (psa)="" level,="" pathological="" stage="" or="" tumour="" grade="" of="" the="" patient.="" discuss="" your="" results="" and="" any="" significant="" association="" found.="" for="" any="" significant="" association="" explain="" the="" nature="" of="" the="" association.="" 25="" marks="" q4="" a="" study="" was="" conducted="" to="" investigate="" whether="" the="" final="" exam="" result="" gained="" for="" a="" group="" of="" 25="" biomedical="" science="" students="" was="" in="" any="" way="" dependent="" upon="" the="" results="" that="" the="" students="" had="" obtained="" in="" previous="" assessments.="" these="" being:="" ·="" an="" in-class="" test="" ·="" a="" coursework="" assignment="" ·="" a="" mock="" exam="" the="" file="" q4_autumn20.xls="" details="" the="" marks="" obtained="" for="" the="" students="" final="" exam="" as="" well="" as="" their="" previous="" assessments.="" using="" the="" data="" contained="" within="" this="" file,="" determine="" by="" statistical="" analysis="" which="" variables="" have="" an="" impact="" on="" the="" final="" exam="" mark,="" and="" the="" extent="" of="" the="" relationship.="" 30="">