Home > Topics > excel > body text

Excel groups with a group distance of 10

王林
Release: 2019-10-29 18:04:55
Original
30518 people have browsed it

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.

Excel groups with a group distance of 10

#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)

Excel groups with a group distance of 10

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

Excel groups with a group distance of 10

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

Excel groups with a group distance of 10

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.

Excel groups with a group distance of 10

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

Excel groups with a group distance of 10

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template