(Solved): 1. The body surface area (BSA) in \( m^{2} \) of a person (used for determining dosage of medicatio ...

1. The body surface area (BSA) in \( m^{2} \) of a person (used for determining dosage of medications) can be calculated by the formula (Mosteller formula): \[ B S A=\sqrt{\frac{H * W}{3131}} \] in which \( H \) is the person's height in inches, and \( W \) is the persons weight in \( t b \). Given simulated data file names 'personalInfo.xlsx' that contains ID number(first column), Gender(second column, 0: Male; 1:Female), Heigh(third column, measured in \( \mathrm{cm} \) ) and Weight (fourth coloumn, measured in \( K G \) ). Write a program in a script file that read the personal information from data file 'personalInfo.xlsx' and complete the followings: (a) Calculate the average \( B S A \) for male group. (b) Determine the number of females whose BSA is below \( (<) \) the average of female. (c) Determine the number of males whose \( B S A \) is within two standard deviations of male. This is, the BSA falls in the range of average \( -2 \) * std \( <=B S A<=a v e r a g e+2+ \) std. No loops! Note: \( 1 K G=2.2046 l b \), and \( 1 c m=0.3937 \) inch