Count and Categorical Variables...

In summary, the conversation discusses the concept of a frequency table for categorical variables, where the count or frequency of each level is shown. It also touches on the use of bar charts for single categorical variables, and whether count can be represented on a scatterplot. The conversation then moves on to the difference between count being a discrete non-negative numerical variable and a summary statistic, and whether binning a continuous variable into intervals turns it into an ordinal categorical variable. The conversation ends with an example of working with patient data and how age can be represented as both a floating point and categorical variable.
  • #1
fog37
1,569
108
TL;DR Summary
Count and Categorical Variables...
Hello,
In the context of categorical variables, a frequency table which gives us the count (aka frequency) for each level of the categorical variable. Count is a number telling us how many times a specific level occurs. A bar-chart handles a single categorical variable (nominal or ordinal) with its levels indicated on the x-axis and count (frequency), or relative frequency, on the y-axis.

My question: is count a discrete non-negative numerical variable? If not, what is it? I don't think it is a numerical variable...
Can count ever be represented as one of the axes of a scatterplot? A scatterplot is designed to accommodate two numerical variables (both discrete, both continuous, one discrete and one continuous) on its two axes.

Here another example that confuses me: a dataset where each row represents a different country and there is a variable that reports the percentage of the country population who is religious (which is the count of people who responded YES to being religious divided by the total country population). That column contains % values and seems to represent a numeric variable even if it represents the relative count of a categorical variable. Is that correct? See attached table:

1676427604467.png


Also, cost and profit are generally considered continuous variables but I believe they are discrete numeric variables since money is a multiple of the cent, the smallest increment. When we build a histogram, we bin the continuous variable values into intervals. Does that turn the continuous variable into an ordinal categorical variable since the data now belongs in a finite number of groups?

Thank you!
 
Physics news on Phys.org
  • #2
fog37 said:
My question: is count a discrete non-negative numerical variable?
It certainly could be.

fog37 said:
If not, what is it?
It is a summary statistic.

fog37 said:
Can count ever be represented as one of the axes of a scatterplot?
Sure. Just like you could put medians or standard deviations on one of the axes of a scatter plot you could also put counts on an axis of a scatter plot.

fog37 said:
Does that turn the continuous variable into an ordinal categorical variable since the data now belongs in a finite number of groups?
It could if you wanted to.
 
  • Like
Likes fog37
  • #3
fog37 said:
My question: is count a discrete non-negative numerical variable? If not, what is it? I don't think it is a numerical variable...
It is a natural number (where 0 is included). They are ordered and have arithmetic properties.
fog37 said:
Can count ever be represented as one of the axes of a scatterplot? A scatterplot is designed to accommodate two numerical variables (both discrete, both continuous, one discrete and one continuous) on its two axes.
I wouldn't call it a "scatter plot", but you certainly can make charts where the categories are along one axis, in order of the count. It happens all the time when you are interested in what category occurs the most. From https://inferentialthinking.com/chapters/07/1/Visualizing_Categorical_Distributions.html:
Visualizing_Categorical_Distributions_21_0.png

fog37 said:
Here another example that confuses me: a dataset where each row represents a different country and there is a variable that reports the percentage of the country population who is religious (which is the count of people who responded YES to being religious divided by the total country population). That column contains % values and seems to represent a numeric variable even if it represents the relative count of a categorical variable. Is that correct? See attached table:

View attachment 322281

Also, cost and profit are generally considered continuous variables but I believe they are discrete numeric variables since money is a multiple of the cent, the smallest increment. When we build a histogram, we bin the continuous variable values into intervals. Does that turn the continuous variable into an ordinal categorical variable since the data now belongs in a finite number of groups?
No. The counting numbers have too many arithmetic properties to just be considered "categorical". They are ordered. You can add them. You can subtract them, although it might give a negative result. You can divide them if you allow rational numbers. The natural numbers are a subset of the integers, the rational numbers, and the real numbers and should not be considered only "categorical".
 
Last edited:
  • Like
Likes WWGD and fog37
  • #4
fog37 said:
When we build a histogram, we bin the continuous variable values into intervals. Does that turn the continuous variable into an ordinal categorical variable since the data now belongs in a finite number of groups?
It doesn't "turn it into" a categorical variable, but it creates a new categorical variable. If the original continuous variable was 'income' we could call the new categorical variable 'income range'.
I occasionally work on health system patient data which, amongst hundreds of variables, has age (of patient at time of recorded health system interaction) - a floating point variable, and 'age-range' a categorical variable that classifies patients into 5-year age ranges. Although the database provides both variable, we could just read in 'age' and derive 'age range' from 'age'.
 
  • Like
Likes Dale, WWGD and fog37

FAQ: Count and Categorical Variables...

What are count variables?

Count variables are numerical variables that represent the number of occurrences of an event or item within a specified category or timeframe. They are always non-negative integers (0, 1, 2, ...) and are often used in statistical analyses to quantify discrete events, such as the number of customers visiting a store or the number of defects in a batch of products.

What are categorical variables?

Categorical variables are variables that represent distinct categories or groups. They can be nominal, where the categories have no intrinsic order (e.g., colors, types of fruit), or ordinal, where the categories have a meaningful order (e.g., satisfaction ratings from "unsatisfied" to "very satisfied"). Categorical variables can be analyzed using frequency counts and proportions.

How do you analyze count variables?

Count variables can be analyzed using descriptive statistics such as mean, median, and mode, as well as graphical representations like histograms or bar charts. For inferential statistics, techniques like Poisson regression or negative binomial regression are commonly used, especially when the count data exhibit overdispersion or are not normally distributed.

How do you analyze categorical variables?

Categorical variables can be analyzed using frequency tables to show the count of observations in each category. Chi-square tests are often employed to assess relationships between categorical variables, while bar charts or pie charts can visually represent the distribution of categories. Logistic regression may also be used when predicting a binary outcome based on categorical predictors.

What is the difference between count and categorical variables?

The primary difference between count and categorical variables lies in their nature and measurement. Count variables are quantitative and represent the number of occurrences, while categorical variables are qualitative and represent distinct groups or categories. Count variables are always numerical, whereas categorical variables can be represented by names or labels without inherent numerical value.

Similar threads

Replies
5
Views
3K
Replies
1
Views
2K
Replies
1
Views
3K
Replies
13
Views
2K
Replies
0
Views
2K
Replies
28
Views
4K
Back
Top