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.
MEDIAN
In a numerical data
set, the median is the point at which there are an equal number of data
points whose values lie above and below the median value.
The MEDIAN Function in Excel returns the median of the given numbers. The median is
the number in the middle of a set of numbers.
=MEDIAN(number1,number2,...)
In
case of an even number of numbers in the set, then MEDIAN calculates the
average of the two numbers in the middle.
In the
Data Sheet, we have Data from A2:A101, A1 being the header of the Data.
=MEDIAN(A2:A101)
Result
is 75
Median
in this context is that half of the students scored above 75 marks and other
half of the students scored below 75 marks.
No comments:
Post a Comment