Read the Excel file FEV1.xls into SPSS. Label the variables (see the key table above) and
add 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%]

1. Calculate BMI from the HEIGHT and WEIGHT variables (BMI=Weight/Height2
   ). Examine
   and comment on the distribution of this new variable.
   [5%]
2. An FEV1 of less than or equal to 2 is indicative of poor lung function. Create a new variable
   FEV1CAT that takes the value 0 when FEV1 is less than or equal to 2 and the value 1 when
   FEV1 is greater than 2. Re-save your SPSS dataset with both BMI and FEV1CATincluded.
   [5%]
3. Produce a single publication quality table summarising the demographic and lung function
   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