How old are you?

Under 18 19-25 26-40 41-60 60+

The chart above shows how the data can be plotted in an Excel column chart that follows the natural order. Another example of ordinal data is data collected with a rating scale like: How satisfied are you with your internet provider? 1 - Very unsatisfied 2 - Mostly unsatisfied 3 - Indifferent 4 - Usually satisfied 5 - Very satisfied   Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.