Y
yitbos
I’m giving exams to students and want to see if the students are missin
the same questions in every class. I have a simple spreadsheet tha
has me enter the question number into the column each time a questio
is missed. The MODE function can tell me which number is occurrin
most often. However, I need to see if there is any other numbers tha
are occurring often as well.
Is there a command that will allow me to look at the second mos
entered number? For example, if I have 5,3,3,2,3,4,3,4,1,3,4, my mod
would be 3 as that’s the number that repeats the most. However,
happens 3 times and that is a number I need to be concerned with a
well.
Hopefully someone has a suggestion for this. Thanks to all of you fo
reviewing my question and providing feedback.
Joh
the same questions in every class. I have a simple spreadsheet tha
has me enter the question number into the column each time a questio
is missed. The MODE function can tell me which number is occurrin
most often. However, I need to see if there is any other numbers tha
are occurring often as well.
Is there a command that will allow me to look at the second mos
entered number? For example, if I have 5,3,3,2,3,4,3,4,1,3,4, my mod
would be 3 as that’s the number that repeats the most. However,
happens 3 times and that is a number I need to be concerned with a
well.
Hopefully someone has a suggestion for this. Thanks to all of you fo
reviewing my question and providing feedback.
Joh