Ask Your Question

quantity of numbers

asked 2018-10-25 09:49:09 +0200

antonsson gravatar image

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

edit retag flag offensive close merge delete


@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.

ve3oat gravatar imageve3oat ( 2018-10-30 20:41:46 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2018-10-25 10:40:07 +0200

Lupp gravatar image

Use the FREQUENCY() function.
The tool > Data > Sort can also deliver the sorted result to a different range.
See this attachment for an example

edit flag offensive delete link more

answered 2018-10-28 20:25:53 +0200

ve3oat gravatar image

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.

edit flag offensive delete link more

answered 2018-10-30 18:42:35 +0200

Rickard gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-25 09:49:09 +0200

Seen: 219 times

Last updated: Oct 30 '18