Use LINQ to create a structured array called BloodTests from the text and XML files with the PatientID, and Bilirubin.

For Each testresult in BloodTests

If the value for Bilirubin is not $-99$

Use LINQ to create an array that contains whether or not the patient lived or died from the record in the database with the same PatientID as this testresult

For Each patient in Patients $($there should be exactly one$)$

If Alive $=1($Died$)$ then

Add the value to Bilirubin$\_$died$\_$sum

Add the value$2$ to Bilirubin$\_$died$\_$square$-$sum $($for the std$.$ dev.$)$

Add one to the 'good' Bilirubin$\_$died$\_$record$\_$count

Otherwise $($must have survived$)$

Add the value to Bilirubin$\_$survive$\_$sum

Add the value $2$ to Bilirubin$\_$survive$\_$square$-$sum $($for the std$.$ dev.$)$

Add one to the 'good' Bilirubin$\_$survive$\_$record$\_$count

Next patient

End If

Next testresult

Compute Bilirubin$\_$died$\_$Average $=$ the B ilirubin$\_$died$\_$sum divided by the 'good'

Bilirubin$\_$died$\_$record$\_$count

Compute Bilirubin$\_$died$\_$Std$.$ Dev. $=$ Bilirubin$\_$died$\_$squared$-$sum divided by the 'good' Bilirubin$\_$died$\_$record$\_$count minus the Bilirubin$\_$died$\_$average squared all raised to the $(1/2)$ power.

Compute Bilirubin$\_$survive$\_$Average $=$ the Bilirubin$\_$survive$\_$sum divided by the 'good' Bilirubin$\_$survive$\_$record$\_$count

Compute Bilirubin$\_$survive$\_$Std$.$ Dev. $=$ Bilirubin$\_$survive$\_$squared$-$sum divided by the 'good' Bilirubin$\_$survive$\_$record$\_$count minus Bilirubin$\_$survive$\_$average squared all raised to $(\frac{1}{2})$ power.

Add Info to List box

Do this for each of the $3$ remaining blood characteristics.