hello world,
I have a calc-file in with the ages of all students of my university are listed.
Is there a way to find out what is the most common age in my university?
And how to sort them by by appearance?
thanks in advance
@antonsson : If any of the answers below satisfactorily answers your question, please click on the Check mark at the left of the relevant answer(s) so that other users will know that your question or problem has been solved.
Use the FREQUENCY() function.
The tool > Data > Sort can also deliver the sorted result to a different range.
See this attachment for an example
If you like statistics, the menu Data -> Statistics -> Descriptive Statistics tool can also be informative.
Simply highlight the column of age data that you want to study, invoke the Descriptive Statistics tool, and specify the first cell where you want the stats to appear (the output will occupy 2 columns and 16 rows). The output includes the average (mean), mode, and median values, as well as the range of values and the number (count) of values included in the calculations. Also a bunch of esoteric stuff that can be safely ignored. It is a quick way to get a “picture” of the data. I use these descriptive statistics for much of my data as well as the Frequency function described by @Lupp.
The easy way is to take all of there ages in colom A or where ever they are and use =AVERAGE(A2:A6) where A2:A6 is all of there ages