Call/WhatsApp: +1 914 416 5343

Blood Bank Data

A dataset from blood bank is presented. The data are recorded for apheresis blood donation made by a group of donors of a period of time. The donor ID is unique for each donor. A donor might have donated more than once in this period. At each donation, the blood total protein level of the donor has been recorded. Use the dataset to answer the following questions:
• There are some missing values for blood type. Think how you can fill in the missing values. Explain your approach (step by step) and also apply your approach and try to fill the missing value as much as possible in. (save the results in an Excel worksheet in and name it Question 3 Part a.) (4 marks)
• Calculate the average of total protein for each donor. Explain your approach (step by step). Report them in a worksheet and name it Question 3 Part b. (2 marks)
• Calculate the range of total protein for each donor. Explain your approach (steps by step). Report them in a worksheet and name it Question 3 Part c. (5 marks)
• Is total protein declining by age? (2 marks)
• Present two best visualization tool for this data that you think provide useful information? (4 marks)

Leave a Reply