Constructing a frequency distribution chart

P

Peter Atherton

Type a List in C1 to C4 -0, 1, 2, 3. Type this formula in
D1. =COUNTIF(Grades,C22) where grades is a range name
(change the range if you want or insert a range name.

Copy the formula in D1 down to D4. This is your frequency
distribution.

If the data is text entry e.g. High school then the
fromula should be =COUNTIF(Grades,"High school")

If you have a column with 0, 1, 2, 3 s entered use this
formula

Regards
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-demensional frequency distribution 4
Combining two formulas 0
How to use AUTOFILTER to update FREQUENCY distribution 7
Varying cell ranges in formulas according to number of cells with certain value 1
return multiple cells meeting a condition 1
If Condition 4
Countifs with different restrictions 1
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1

Top