distribution of frequency using histogram
distribution of frequency using histogram
Embedded Files
HistogramFrequency can be achieved through Histogram. Histogram is a pictorial representation of data. This can be done by the following ways1. Click Data Ribbon Select Data Analysis.2. Data Analysis window will open as given below.3. Select Histogram in the data analysis window4. Another window will open referred Histogram.5. Provide the data to the Input Range. E.g. Age6. Provide the Bin to the Bin Range E.g. 20, 30, 40, 50, 60, 70, 807. Give the Output range where the chart to be placed.8. Finally, Choose Chart Output and Click OK.9. Now, the Frequency table and Chart have been created in Excel.
Page updated
Report abuse