# Explain the procedure for constructing frequency distribution for categorical data

Explain the procedure for constructing frequency distribution for categorical data using Excel.
Explain the procedure for constructing frequency distributions for numerical data using Excel.

• Questions are typically answered in as fast as 30 minutes

### Plainmath recommends

• Get a detailed answer even on the hardest topics.
• Ask an expert for a step-by-step guidance to learn to do it yourself.

Demi-Leigh Barrera
Constructing frequency distributions for categorical data:
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