How can I create a frequency table with breaks in R?

Creating a frequency table with breaks in R involves categorizing numerical data into intervals and then counting the number of observations that fall into each interval. Here's how you can achieve this using the cut() and table() functions:

1. Using the cut() function:

- The cut() function is used to divide the range of your data into intervals (or "breaks"). You specify the breaks, and cut() returns a factor variable indicating which interval each data point belongs to.

2. Using the table() function:

- The table() function then takes the output of cut() and creates a frequency table, showing how many observations fall into each interval.

3. Example Code:

# Sample data
data <- c(12, 15, 18, 22, 25, 28, 32, 35, 38, 42, 45, 48, 52, 55, 58)

# Define breaks for the intervals
breaks <- c(10, 20, 30, 40, 50, 60)

# Use cut() to categorize data into intervals
data_cut <- cut(data, breaks = breaks, right = FALSE)

# Create a frequency table using table()
freq_table <- table(data_cut)

# Print the frequency table
print(freq_table)


4. Explanation of the Code:

- The data vector contains the numerical data you want to analyze.

- The breaks vector defines the boundaries of the intervals. In this example, the intervals are [10, 20), [20, 30), [30, 40), [40, 50), and [50, 60). The right = FALSE argument in cut() specifies that the intervals are left-closed and right-open.

- The cut() function assigns each data point to the appropriate interval.

- The table() function counts the number of data points in each interval, creating the frequency table.

5. Customizing Breaks:

- You can customize the breaks vector to create intervals that are appropriate for your data. You can also use functions like seq() to generate a sequence of breaks.

6. Output:

- The output will be a table showing the frequency of data points in each interval. For the example data and breaks, the output might look like this:

data_cut
[10,20) [20,30) [30,40) [40,50) [50,60)
3 3 3 3 3

By using cut() and table(), you can easily create frequency tables with breaks in R, allowing you to analyze the distribution of your numerical data effectively.

Learn more about this