Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to use the Frequency Statistics function FREQUENCY

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Internet Technology >

Share

Shulou(Shulou.com)06/01 Report--

Frequency statistics function FREQUENCY how to use, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Today, I would like to share with you a frequency statistical function-FREQUENCY function!

When counting the frequency of each quantitative segment of a group of data, if we can make good use of the frequency function, the work efficiency will be greatly improved. Of course, the frequency statistics can also be completed through the classified summary and PivotTable in excel. Today we only talk about the function method.

First, the syntax of frequency statistics is given:

= FREQUENCY (A2:A30, {300400500600700})

Explain the meaning of this grammar to the blow:

The first parameter in parentheses is the target data area to be counted, and the second braced parameter is the statistical fractional segment data point.

The statistical functions that the above syntax will complete are:

The frequency of six segmented data regions such as 300, 400, 400, 500, 500, 600, 600, 700 and above.

But to emphasize here, the syntax of this FREQUENCY frequency statistics function looks simple, but because it is an array function, it needs to use selected multiple areas and a set of keyboard shortcuts at the same time, because of the skill.

This is to show you a small case:

We need to divide the above data into six groups: less than 300, 300, 400, 400, 500, 600, 600, 700 and above.

First, we need to construct the output region of the frequency.

The grouping of the output area must be consistent with the data packet constructed in the function.

Then select the 6 cells of the frequency to be stored.

Then type the following function syntax in the bulletin bar

= FREQUENCY (B2:G27, {300400500600700})

Next is a very important and often wrong step. After typing the formula, hold down the Ctrl+ shift key with your left hand, and then press enter with your right hand.

When it is finished, the frequency will be counted automatically.

At this point, you will find that the formula in the formula bar will automatically add a pair of curly braces "{}" before and after the formula, which is a special form of the excel array formula.

If you master this function, you can save a lot of tedious operation steps and greatly improve your work efficiency.

After reading the above, have you mastered the method of how to use the frequency statistical function FREQUENCY? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 208

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Internet Technology

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report