Answer
The frequency distribution, the relative frequency distribution, frequency histogram and relative frequency histogram for the provided data is shown below:
Work Step by Step
To construct 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 Column. Select the Format Data series and reduce the gap width and the series overlap.
To construct 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.
