The number of observation for each of the category can be counted using the function COUNTIF in Excel.
The function is given in Excel as, COUNTIF (Range, cell reference.) Under the 'Range' enter the range of data from which the frequency has to be counted. Under 'cell reference' enter the cell position that contains the categoty name for counting.
Constructing frequency distributions for numerical data:
If the data set consists of small number of values then the function COUNTIF in Excel can be used for creating frequency distributions for numerical data.
When the dataset is large, then the following procedure has to be followed in excel for constructing frequency distribution.
Step-by-step software procedure to obtain frequency distribution using EXCEL is as follows:
- Open an EXCEL file.
- Choose Date>Data Analysis>Histogram
- Enter Input range of the data
- Specify the required Bin Range
- Click Ok