12 Fig. 12.1 shows an excerpt from the pre-release material.
\begin{table}[h]
| A | B | C | D | E | F | G | H |
| 1 | Sex | Age | Marital | Weight | Height | BMI | Waist | Pulse |
| 2 | Female | 34 | Married | 60.3 | 173.4 | 20.05 | 82.5 | 74 |
| 3 | Female | 85 | Widowed | 64.7 | 161.2 | 24.9 | \#N/A | \#N/A |
| 4 | Female | 48 | Divorced | 100.6 | 171.4 | 34.24 | 105.6 | 92 |
| 5 | Male | 61 | Married | 70.9 | 169.5 | 24.68 | 92.2 | 70 |
| 6 | Male | 68 | Divorced | 96.8 | 181.6 | 29.35 | 112.9 | 68 |
\captionsetup{labelformat=empty}
\caption{Fig. 12.1}
\end{table}
There was no data available for cell H3.
- Explain why \#N/A is used when no data is available.
Fig. 12.2 shows a scatter diagram of pulse rate against BMI (Body Mass Index) for females. All the available data was used.
Pulse rate against BMI for females
\begin{figure}[h]
\includegraphics[alt={},max width=\textwidth]{c9d14a4d-a1c8-42ad-9c0b-42cef6b3612f-08_659_1552_1363_233}
\captionsetup{labelformat=empty}
\caption{Fig. 12.2}
\end{figure}
There are two outliers on the diagram. - On the copy of Fig. 12.2 in the Printed Answer Booklet, ring these outliers.
- Use your knowledge of the pre-release material to explain whether either of these outliers should be removed.
- State whether the diagram suggests there is any correlation between pulse rate and BMI.
The product moment correlation coefficient between waist measurement, \(w\), in cm and BMI, \(b\), for females was found to be 0.912 . All the available data was used.
- Explain why a model of the form \(\mathrm { w } = \mathrm { mb } + \mathrm { c }\) for the relationship between waist measurement and BMI is likely to be appropriate.
The LINEST function on a spreadsheet gives \(m = 2.16\) and \(c = 33.0\).
- Calculate an estimate of the value for cell G3 in Fig. 12.1.