- Picture and text skills
- Case
MODE is a function used in statistics to return the value that appears most frequently in a set of data.
Syntax: MODE(number1,number2,...)
Number1, number2, ... are 1 to 30 arguments for the mode calculation, or a single array (i.e., a reference to the array range) can be used instead of comma-separated arguments.
Description
• Parameters can be numbers, or names, arrays, or references containing numbers.
• If the array or reference parameter contains text, logical values, or blank cells, those values are ignored; however, cells containing zero values are counted.
• If the data set does not contain duplicate data, the MODE function returns an error value of N/A.
In a set of values, the mode is the value that appears most frequently, the median is the value in the middle, and the mean is the average value. None of these median functions can be completely completed individually. Characterize all data.
For example, assume that the data is spread over three regions, half of which is in a smaller range and the other half in two larger ranges. Functions AVERAGE and MEDIAN may return intermediate values located where data points are sparse; function MODE may return smaller values located where data points are densely packed.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/li-yong-MODE-han-shu-qing-song-zhao-chu-shu-ju-zhong-shu.html
支付宝扫一扫 
评论列表（196条）
测试