1.Read the Excel file FEV1.xls into SPSS. Label the variables (see the key table above) andadd value labels where necessary. Alter the number of decimal places displayed to suit each of the variables. Check that all the variables are set up as the appropriate type (measure), i.e. Scale, Nominal or Ordinal. Save the file as an SPSS file called FEV1.sav. Use this file for all subsequent analyses.[5%]
2.Calculate BMI from the HEIGHT and WEIGHT variables (BMI=Weight/Height2). Examine and comment on the distribution of this new variable.[5%]
3.AnFEV1oflessthanorequalto2isindicativeofpoorlungfunction.Createanewvariable FEV1CATthattakesthevalue0whenFEV1islessthanorequalto2andthevalue1when FEV1 is greater than 2. Re-save your SPSS dataset with both BMI and FEV1CATincluded.[5%]
4.Produceasinglepublicationqualitytablesummarisingthedemographicandlungfunction variables separately for each patient group (GROUP). This should include appropriate summaries of the variables FEV1, GENDER, AGE, HEIGHT, WEIGHT, BMI andFEV1CAT.SPSS should be used to calculate all of the values, but the final publication quality table does not need to be produced in SPSS. If you produce any graphics to help you with your choices then these do not need to be presented in the Word report. The syntax that