HOW TO
FIND MEDIAN OF DATA [SCORES] IN EXCEL
Procedures and concepts to
consider:
- Have a data into cells [that are to be processed] Example 13,25,14, . . .
Example
Columns
[B, C and D]
and Row
[3]
…....... [In horizontal]
OR
Column
[B]
and Rows
[3,4,5,6,7 and 8]
…........ [In vertical]
- Identify the range of data into cells [that are to be processed]
Example B3 to
D3 (B3:D3)
- Syntax: '' = MEDIAN(B2:D2) '' …...............Median Score
- Syntax: '' = MEDIAN(B3:B8) '' …...............Median Subject Score
NOTE:
In writing formula, use semi-colon [;] if you use OpenOffice
otherwise use comma only [,] if you use Microsoft office
OTHER EXCEL FUNCTIONS [SYNTANX]
No comments:
Post a Comment