Though grouped data can also be multimodal we will solve problems having only a single mode. MEDIAN IF logical_testvalue_if_truevalue_if_false Since the IF function is nested inside the MEDIAN function the entire IF function becomes the sole argument for the MEDIAN function. Mode Formula for Grouped Data.
The median for the grouped data is given by l n 2- c.
Select a blank cell and type this MEDIANB2. As here we are excluding the frequency of the median class from the CF. Formula to calculate median of ungrouped data. W is the group width.