frequency

%3CLINGO-SUB%20id%3D%22lingo-sub-2189187%22%20slang%3D%22en-US%22%3Efrequency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2189187%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20do%20I%20find%20a%20frequency%20of%20a%20range%20of%20numbers%20in%20a%20table%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2189187%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2189628%22%20slang%3D%22en-US%22%3ERe%3A%20frequency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2189628%22%20slang%3D%22en-US%22%3EDoes%20this%20help%3F%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffrequency-function-44e3be2b-eca0-42cd-a3f7-fd9ea898fdb9%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffrequency-function-44e3be2b-eca0-42cd-a3f7-fd9ea898fdb9%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2189836%22%20slang%3D%22de-DE%22%3ESubject%3A%20frequency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2189836%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F988734%22%20target%3D%22_blank%22%3E%40martin_vazquez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWith%20the%20permission%20of%20everyone%2C%20add%20some%20information%20to%20the%20link%20from%20Mr.%20Cuong.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EDetermine%20the%20frequency%20of%20entries%20in%20Excel%20tables%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWith%20Excel%2C%20you%20can%20quickly%20find%20out%20how%20many%20amounts%20have%20been%20spent%20in%20specific%20classes.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20FREQUENCY%20function%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAs%20mentioned%20at%20the%20beginning%2C%20it%20is%20a%20statistical%20function%20with%20which%20the%20distribution%20of%20the%20values%20of%20a%20list%20over%20certain%20classes%20is%20calculated.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20data%20must%20be%20numeric%20values%20arranged%20in%20a%20list.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20classes%20represent%20the%20intervals%20to%20which%20the%20values%20are%20to%20be%20assigned.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOne%20example%20makes%20the%20whole%20thing%20easier%20to%20understand%2C%20therefore%20two%20examples%20%3A)).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWould%20love%20to%20know%20if%20we%20could%20help.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

how do I find a frequency of a range of numbers in a table?

2 Replies

@martin_vazquez 

With the permission of everyone, add some information to the link from Mr. Cuong.

Determine the frequency of entries in Excel tables

With Excel, you can quickly find out how many amounts have been spent in specific classes.

The FREQUENCY function

As mentioned at the beginning, it is a statistical function with which the distribution of the values of a list over certain classes is calculated.

The data must be numeric values arranged in a list.

The classes represent the intervals to which the values are to be assigned.

One example makes the whole thing easier to understand, therefore two examples :)).

 

Would love to know if we could help.

 

Nikolino

I know I don't know anything (Socrates)