Answer
The relative frequency histogram for the provided data is shown below:
Work Step by Step
To construct the relative frequency histogram using Excel, the steps are listed below:
Step 1: Enter the data in a new Excel sheet.
Step 2: Select the data and go on Charts→Clustered Coloumn. Select the Format Data series and reduce the gap width and the series overlap.
The histogram will be obtained and distribution is negatively skewed.
