We will now perform a simple mean imputation. However, rather than substituting with a single mean number, we will replace the NAs with the mean values based upon membership of these four groups:
- Diabetes=pos/younger age range
- Diabetes=neg/younger age range
- Diabetes=neg/older age range
- Diabetes=pos/older age range
We already have the Diabetes=neg/pos category, so how do we categorize into the younger/older age group?
We will do that by automatically calculating a cut point. To determine the cut point, we will use the cut function on the Age variable so separate it into two levels. Then we will use dplyr to compute mean values for the five variables, depending upon how the age group was cut.
- First, let's see ...