$4.$ Create the following $5$ variables $($in bold$)$ in the PHMC n$=100(3)$ datafile using instructions from the class activity $($see class activity step $2$a and $2$b$).$

a$.$ Create Total Hgt$\_$inches column $($hint: $12$ inch$).$

b$.$ Create Total Hgt$\_$meters column $($hint: $1$ inch $=0\mathrm{.}0254$ m$).$

c$.$ Create Weight$\_$kg column $($hint: $1$ lb $=0\mathrm{.}453592$ kg$).$ You will use $$WSHOES$($column BX$).$ Formula: $=$BX$2*0\mathrm{.}453592.$

Note $2$ WSHOES values are missing, excel treats them as $0,$ thus remove these $2$ rows of data.

d$.$ Create BMI column: enter this formula in the next empty column. Formula: $=$FC$2/$FB$2^2$

e$.$ Create BMI$\_$categories column: enter the following entire formula in the next empty column to create new BMI categories:

$=$IF$($FD$2<=18\mathrm{.}5,$"Underweight",IF$($AND$($FD$2>18\mathrm{.}5,$FD$2<=24\mathrm{.}9),$"Normal",IF$($AND$($FD$2>24\mathrm{.}9,$FD$2<=29),$"Overweight",IF$($AND$($FD$2>29),$"Obese",""""$)))).$

f$.$ For this step, you will use the Excel Analysis Toolpak similar to what we did in the class activity. Run descriptive statistics of Weight$\_$kg

$5.$ Use a Pivot Table to create a frequency table of $$BMI categories$,$ similar to what we did in the class activity $($see instructions under step $4$ of the class activity$).$