HEIGHT1) Download the HEIGHT excel table filled by the class on the google drive. (See the link onCanvas)2) Using the do-file “importing and saving data.do”, import the data from Excel to Stata and savethem as a stata data set.3) Using “setup.do”, open the HEIGHT.dta and set up a log file for your records.4) Explore the distribution of the height using summarize and kdensity commands.5) Generate a new variable representing a log transformation of the height.gen ln_height = ln(height)Explore the relationship between the original scales in feet and cm and the new scale in logpoints.6) Use describe command to get description of the variable. What is format of the gender variable?Convert the gender variable into numeric format. To do so, generate a new variable F taking thevalue of 0 for male students and 1 for female students. This can be done in two ways:a)gen F = 0replace F = 1 if gender==”F”b) The same job can be simply performed by just one command. Drop F before regeneratingit once again, and use another way:drop Fgen F = (gender==”F”)7) Explore the gender distribution in our class by using the tab command.tab FWhat are fractions of men and women in the class?28) Explore the gender distribution in our class by using the sum command:sum FCompare the mean value with the percentage of women reported by the tab output. What do youlearn from the mean value of the binary variable F?For This or a Similar Paper Click Here To Order Now