June 2023 Paper 2 Q8
8 The pre-release material contains information on Pulse Rate and Body Mass Index (BMI).
A student is investigating whether there is a relationship between pulse rate and BMI. A section of the available data is shown in the table.
| Sex | Age | BMI | Pulse |
|---|---|---|---|
| Male | 62 | 29.54 | 60 |
| Female | 20 | 23.68 | #N/A |
| Male | 17 | 26.97 | 72 |
| Male | 35 | 24.7 | 64 |
| Male | 17 | 20.09 | 54 |
| Male | 85 | 23.86 | 54 |
| Female | 81 | 24.04 | #N/A |
The student decides to draw a scatter diagram.
The student cleans the data for BMI and Pulse Rate in the pre-release material and draws a scatter diagram.

The student identifies one outlier.
The student decides to remove this outlier from the data. They then use the LINEST function in the spreadsheet to obtain the following formula for the line of best fit.
\(P = 0.29Q + 64.2\),
where \(P = \text{Pulse Rate}\) and \(Q = \text{BMI}\).
They use this to estimate the Pulse Rate of a person with BMI 23.68.
They obtain a value of 71 correct to the nearest whole number.
It is suggested that all pairs of values where the pulse rate is above 100 should also be cleaned from the data, as they must be incorrect.
| Scheme | Marks | AO |
|---|---|---|
| Remove any data where #N/A is in the column, as there is no data available | B1 | 2.4 |
| [1] |
Notes
LDS advantage
Comments such as exclude 20/81 year old female are B0 as this is only an extract of the full set of data
Must refer to N/A/missing data but accept ‘not available/non-existent’
Remove data without a pulse reading is B0 as we could have missing BMI data too
| Scheme | Marks | AO |
|---|---|---|
| (62.77, 84) ringed and no others | B1 | 1.1 |
| [1] |
Notes

| Scheme | Marks | AO |
|---|---|---|
| No evidence of a linear relationship oe so unlikely to be reliable | B1 | 2.2b |
| [1] |
Notes
Any comment relating to interpolation or extrapolation is B0 as we want a comment on the appropriateness of the model considering the scatter diagram
Condone ‘there appears to be little correlation/weak positive correlation’ etc
‘No/Zero correlation’ is B0 e.g the PMCC could be 0.1 etc
| Scheme | Marks | AO |
|---|---|---|
| None of the pulse rates are that unusual so should not be removed | B1 | 2.2b |
| [1] |
Notes
LDS advantage
Need ‘no/keep’ and reason
Condone ‘No as they are not outliers’
Accept ‘Higher pulse rates are not uncommon’