commonly used numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I determine the most common number used in either a column or row.
Numbers ranging from 1 to 50 are listed in each cell randomly, and would like to determine which number i
used the most
 
How can I determine the most common number used in either a column or row.
Numbers ranging from 1 to 50 are listed in each cell randomly, and would like
to determine which number is used the most.
Click to expand...

Read about the MODE function in online help.
 
This may be more than you need - Select the data to analize - Tools/Data Analysis/Descriptive Statistics/Summary Statistics - the mode is the number used the most.
 
Back
Top