5. The female students in an undergraduate engineering core course at UH self-reported their heights to the nearest inch. The data is as follows:62, 64, 61, 67, 65, 68, 61, 65, 60, 65, 64, 63, 59 68, 64, 66, 68, 69, 65, 67, 62, 66, 68, 67, 66, 65 69, 65, 69, 65, 67, 67, 65, 63, 64, 67, 65 First, construct the frequency distribution Table like Table 6-4 on Page 213 of the textbook where you only need to specify the classes/bins, frequency info. Then using the table to create the histogram; here let the height of rectangle (for each bin) equal to the frequency instead of relative frequency in your histogram even though you can also set the height as the relative frequency. *Hint: create the frequency distribution table by hand, but you can create the histogram in Excel and insert the result as a figure.*

Let X denote the height of the female students measured in inches and the data given on X is as followsX=62,64,61,67,65,68,61,65,60,65,64,63,59,68,64,66,68,69,65,67,62,66,68,67,66,65,68,64,66,68,69,65,67,62,66,68,67,66,65The number of observations in X, n=39Requirements:To construct a frequency table and a histogram plot for the frequency of the heights.The steps involved in constructing the frequency table are as follows,Determine the number of classes: According to Sturges rule the formula to compute the number of classes (k) is given byk=1+3.22∗log10(n)=1+3.22∗log10(39)=6.1232≈6Calculate the Range of the given data set: The formula to compute the range is as follows,Range=Maximum(X)−Minimum(X)=69−59=10Compute the class width: It refers to the width for each class interval and the formula to compute the class width is as followsClass width =Rangek=106=1.667≈2Determine the class intervals: To create the class intervals, start with the minimum value and add the class width until it covers the entire range.Computing the frequency: It is the number of observations that fall within the given class intervalcomputing the relative frequency: This can be computed using the following formulaRelative Frequency=frequencyTotal frequency Computing the cumulative frequency: This is a running total of the frequencies of data points in a dataset, representing the number of observations that are less than or equal to a given value.Using all the information mentioned above, the frequency table is as follows Class IntervalFrequencyRelative frequencyCumulative frequencyLower PointUpper point596122/39=0.0512820512616355/39=0.1282051285+2=7636555/39=0.1282051285+7=1265671313/39=0.33333333313+12=25676912012/39=.30769230812+25=37697122/39=0.0512820512+37=39Total Frequency=39The histogram provides the visualization for the distribution of the given sample which is grouped into bins or class intervals.To construct the histogram in Excel the steps are as followsEnter the given data in EXCEL Compute the midpoints for each class interval by taking the average of the lower and upper points. The computed midpoints are as follows;Now select the midpoints and frequency columns and go to charts→Recommended charts→All charts→Column chartNow to make a column chart as a histogram, right-click on any bar on the chart, select Format Data series, and then set the value of Gap width to 0%Finally, provide the appropriate data label to the chart.The EXCEL output is as followsThe frequency distribution table is as followsClass IntervalFrequencyRelative frequencyCumulative frequencyLower PointUpper point596120.0512820512616350.1282051287636550.128205128126567130.333333333256769120.30769230837697120.05128205139The histogram plot for the Frequency of the given data is obtained.