| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find out the representive mark from a list?
My class has 30 students, their marks are shown below
100,97,96,93,88,85,84,77,76,71, 66,62,62,55,53,49,48,46,46,43, 43,43,43,43,35,33,31,31,31,13 I would like to determine the most representative mark for this class for comparing with another class. I think the functions - average, mode are not a very representative in this case. Does anyone have any suggestions on how to define the most representative mark for this class? Thank you in advance Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find/replace paragraph mark | Excel Discussion (Misc queries) | |||
| How can I find and mark double entries in a customer database? | Excel Worksheet Functions | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Find and mark duplicates | Excel Discussion (Misc queries) | |||
| Looping Macro to Find and Mark | New Users to Excel | |||
Threaded Mode
