The
practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet
About the
Data Sheet - The data in this sheet is related to marks scored by 100 Students
in a Statistical Test.
Based on
the data, we will use Microsoft Excel Statistical functions
to analyse the descriptive statistics.
In the Data Sheet, we have Data from A2:A101, A1 being the
header of the Data.
MODE
A statistical
term that refers to the most frequently occurring number found in a set of
numbers.
The mode is
found by collecting and organizing the data in order to count the frequency of
each result. The result with the highest occurrences is the mode of the set.
= MODE(number1,[number2],...])
In the Data Sheet, we have Data from A2:A101, A1 being
the header of the Data.
=MODE(A2:A101)
Result is 80
9 Students got 80
marks and since 80 is the most frequently occurring number in the data set it
is identified as mode.
The MODE.SNGL and the MODE.MULT
functions both find the statistical mode (the most commonly occurring value (or
values) of a supplied set of numbers).
The
difference between the functions occurs when the supplied data set has more
than one mode. The Mode.Sngl function returns the lowest of these values,
whereas the Mode.Mult function returns an array of all of the modes.
No comments:
Post a Comment