Excel(エクセル)基本講座:最頻値を求める関数 |
||
| B | C | |
| 2 | データ | |
| 3 | 80 | |
| 4 | 55 | |
| 5 | 90 | |
| 6 | 55 | |
| 7 | 55 | |
| 8 | 80 | |
| 9 | 最頻値 | 55 |
| B | C | |
| 2 | データ | |
| 3 | 80 | |
| 4 | 55 | |
| 5 | 90 | |
| 6 | 55 | |
| 7 | 55 | |
| 8 | 80 | |
| 9 | 最頻値 | =MODE(C2:C7) |
| B | C | |
| 2 | データ | |
| 3 | 80 | |
| 4 | 55 | |
| 5 | 90 | |
| 6 | 55 | |
| 7 | 55 | |
| 8 | 80 | |
| 9 | 最頻値 | 55 |
| B | C | |
| 2 | データ | |
| 3 | 80 | |
| 4 | 55 | |
| 5 | 90 | |
| 6 | 55 | |
| 7 | 55 | |
| 8 | 80 | |
| 9 | 最頻値 | =MODE.SNGL(C2:C7) |
| B | C | |
| 2 | データ | |
| 3 | 70 | |
| 4 | 80 | |
| 5 | 70 | |
| 6 | 55 | |
| 7 | 55 | |
| 8 | 80 | |
| 9 | 90 | |
| 10 | 55 | |
| 11 | 80 | |
| 12 | 最頻値 | 80 |
| 13 | 最頻値 | 55 |
| 14 |
| B | C | |
| 2 | データ | |
| 3 | 70 | |
| 4 | 80 | |
| 5 | 70 | |
| 6 | 55 | |
| 7 | 55 | |
| 8 | 80 | |
| 9 | 90 | |
| 10 | 55 | |
| 11 | 80 | |
| 12 | 最頻値 | =MODE.MULT(C3:C11) |
| 13 | 最頻値 | |
| 14 |
| B | C | |
| 2 | データ | |
| 3 | 70 | |
| 4 | 80 | |
| 5 | 70 | |
| 6 | 55 | |
| 7 | 55 | |
| 8 | 80 | |
| 9 | 90 | |
| 10 | 55 | |
| 11 | 80 | |
| 12 | 最頻値 | {=MODE.MULT(C3:C11)} |
| 13 | 最頻値 | {=MODE.MULT(C3:C11)} |
| 14 | {=MODE.MULT(C3:C11)} |
| B | C | |
| 2 | データ | |
| 3 | 70 | |
| 4 | 80 | |
| 5 | 70 | |
| 6 | 55 | |
| 7 | 55 | |
| 8 | 80 | |
| 9 | 90 | |
| 10 | 55 | |
| 11 | 80 | |
| 12 | 最頻値 | 80 |
| 13 | 最頻値 | 55 |
| 14 | #N/A |
| B | C | D | E | |
| 2 | データ | |||
| 3 | 70 | |||
| 4 | 80 | |||
| 5 | 70 | |||
| 6 | 55 | |||
| 7 | 55 | |||
| 8 | 80 | |||
| 9 | 90 | |||
| 10 | 55 | |||
| 11 | 80 | |||
| 12 | 最頻値 | {=TRANSPOSE(MODE.MULT(C3:C11))} | {=TRANSPOSE(MODE.MULT(C3:C11))} | {=TRANSPOSE(MODE.MULT(C3:C11))} |
| B | C | D | E | |
| 2 | データ | |||
| 3 | 70 | |||
| 4 | 80 | |||
| 5 | 70 | |||
| 6 | 55 | |||
| 7 | 55 | |||
| 8 | 80 | |||
| 9 | 90 | |||
| 10 | 55 | |||
| 11 | 80 | |||
| 12 | 最頻値 | 80 | 55 | #N/A |
PageViewCounter
Since2006/2/27