6. Create a table of Descriptive Statistics and Histograms of the Sample Weights for each named range Make a copy of the data table (the one with claus, Weight in. Ibs venue. Cude w.Q je de. Word column_) into a ne.v works leet of your Excel file. Sort the data by the Gender Word column and the Weights in Ibs. column; Sort is _nder the Data tab Define Named Kanges' 5 rect only the weights for the females. In the Formulas tab select Define Name and name the date FemaleWeights Sciect only the weights for the males. In the For:-las tab select Define Name and name the date Maleweights Select all the we, hits. In the For mulas tab select Define Name and name the date AllWeights. Create a table of calculated Sample Statistics for each of the Named Ranges: formulas for each cell are shown below your file should show the numbers not the formulas. Note: the formulas for ,Qk are based on the cells that contain the Q1 and Q3 values. H K