Ask Your Question
0

How to select the top "values" in each row of the spreadsheet [closed]

asked 2013-02-20 16:03:35 +0100

bobarags gravatar image

I teach a math class and when I give 8 quizzes, I drop the two or three lowest grades for each student. How can I accomplish this in Libreoffice Spreadsheet?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-22 19:42:52.428600

1 Answer

Sort by » oldest newest most voted
2

answered 2013-02-21 05:44:20 +0100

mahfiaz gravatar image

It depends how you need your data next. But let's assume you want just a sum of the points minus 2 lowest:

=SUM(A1:A9)-SMALL(A1:A9;1)-SMALL(A1:A9;2)

or maybe you need the average:

=(SUM(A1:A9)-SMALL(A1:A9;1)-SMALL(A1:A9;2))/(COUNT(A1:A9)-2)

Or you might find =QUARTILE(A1:A9;1) an interesting function :)

edit flag offensive delete link more

Comments

@bobarags -- did this Answer help you out?

qubit gravatar imagequbit ( 2013-03-12 01:25:24 +0100 )edit

Question Tools

Stats

Asked: 2013-02-20 16:03:35 +0100

Seen: 1,165 times

Last updated: Feb 21 '13