Excel groups with a group distance of 10

1. Enter the original data in the cell and find the maximum value, minimum value, experience group distance and number of experience groups. As shown below. This article mainly takes the daily sales of supermarkets as an example.

#2. Draw a frequency distribution table according to different needs and data display conditions. As shown below, (the group distance can be set according to personal needs)

3. Calculate the frequency of each group, select B16:B23, and click "Insert" in "Tools" Function", select the "Statistics" function FREQUENCY

4. Select the area and determine the values ​​of the two parameters of the FREQUENCY function, as shown in the figure

5. Press the Shift Ctrl Enter key combination and calculate the frequency density, frequency, upward and downward accumulated frequency and frequency density, as shown in the figure below.

6. Select the table data and draw the histogram. The specific performance is as shown in the figure below

Recommended tutorial: excel tutorial

The above is the detailed content of Excel groups with a group distance of 10. For more information, please follow other related articles on the PHP Chinese website!