Explain the procedure for constructing frequency distribution for categorical data

aortiH

aortiH

Answered question

2021-10-20

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

Answer & Explanation

Demi-Leigh Barrera

Demi-Leigh Barrera

Skilled2021-10-21Added 97 answers

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

Do you have a similar question?

Recalculate according to your conditions!

New Questions in High school statistics

Ask your question.
Get an expert answer.

Let our experts help you. Answer in as fast as 15 minutes.

Didn't find what you were looking for?