I'm struggling to follow the question. It would be helpful to pose this question as a reprex, with sample data.
- For sharing sample data, check out datapasta https://reprex.tidyverse.org/articles/articles/datapasta-reprex.html
- For reprexes, FAQ: What's a reproducible example (`reprex`) and how do I create one?
Note also that this kind of looks like a homework problem. If that's the case, please have a look to our homework policy, homework inspired questions are welcome but they should not include verbatim instructions from your course.
We certainly love to get homework problems, just not with verbatim text from the assignment.