• Systolic Blood Pressure (SBP)
To keep track of the needs of potential clients, the program created a data file from one
month's new applications. Use the data file, called Jan_exam_data, saved on the desktop
of your computer and answer the following questions.
3.1 Import the data from your Excel file, Jan_exam_data into SPSSand define all the
variables in SPSS.Save your SPSSdata file using your initials and student number, eg.
studentnoQ3.
[5]
3.2 Recode the variable "age" into "agegroup" using the following categories:
1 = 60-69 yrs
2 = 70-79 yrs
3 = 80+ yrs
Run a frequency of the variable "agegroup".
[2]
3.3 Obtain summary information about the distribution, variability, and central tendency
of the continuous variables, "age". Furthermore, visually examine the central tendency
and distributional characteristics of the continuous variable, "age" as well as producing a
histogram, stem and leaf and box plots and checking assumptions with Normality plots.
Write up a short narrative for each output explaining what you found about this variable
(age).
[14]
3.4 Produce a table of frequencies and percentages and a bar chart of the variable "sex".
Write up a short narrative explaining your results.
[4]
QUESTION 4 (25 MARKS)
4.1 Perform a simple linear regression of the variables "SBP" (dependent variable) and
"age" (independent variable) and show the results.
[6]
4.2 State the regression equation and interpret the equation in terms of age and systolic
blood pressure.
[5]
4.3 How much of the variation in systolic blood pressure is explained by the differences in
age?
[2]
4.4 ls the regression line significant? State your hypothesis and the p-value.
[5]
Applied Mathematical and Statistical Computing (AMS602S}
5
2nd Opportunity- January 2024