help please

CASE STUDY # 3 Gender Height (Ft) Height (in) Weight (Lb) |Height(m) Wt (Kg) BMI 195 L. 68 Female 172 1.68 78.02 Female 275 1.60 5 124.74 1.75 97.52 Female 5 1.68 66.22 Female 23.56 5 Femal 5 1.63 67.13 25.40 30.99 Male Female Female 23.03 Female 19.84 Female 29.41 Female 25.00 Female 20.07 Female 27.46 28.72 Female Male 29.23 85 28.37 1.60 23.91 Average Mode Median Variance CV% To complete this homework you will need to: Must be functions in Excel 1. Sort the data set by BMI. 2. Fill-up all the cells within the thick box border (using Excel functions only!) 3. In the same Excel file insert three (3) "text boxes" underneath the data (in the main menu go to Insert and then click Text Box). Provide an answer to each of the questions following 3 questions (I-III, below). Each answer must be provided in each independent box. Start your answer identifying the question (i.e I, II, III). I. Evaluate the average, mode and median for the weight in pound. From the tree measurements indicate: Which is the best statistics to evaluate the central tendency for the weight (Lb) and why. II. Evaluate the variance of the BMI. In your own words explain the meaning of the number obtained in that cell. III. Evaluate the CV% for Height (m) and Weight in (Kg). In your own words explain, compare, and contrast the meaning of the numbers obtained in those two cells