MODE(number1,number2,...) returns the most common value in a data set : MODE « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. MODE
Input the formula: =MODE(B2:B10). Press Enter to get the result.
Input the formula: =MODE(B2:B7)
21.49.MODE
21.49.1.MODE(number1,number2,...) returns the most common value in a data setMODE(number1,number2,...) returns the most common value in a data set