Work Out Median Average. If the data range is not continuous you can use this formula MEDIANA1C3E1G3 A1C3 and E1G3 are the ranges you want to calculate the median from and the comma indicates and. The median is the data value in the middle of the set.
If there is an even number of items of data there will be two numbers in the. The median is also the number that is halfway into the set. Cells that contain text.
The middle numbers are 7 and 13.
For example suppose we want the average of 24 55 17 87 and 100. If there are 2 data values in the middle the median is the mean of those 2 values. If the data range is not continuous you can use this formula MEDIANA1C3E1G3 A1C3 and E1G3 are the ranges you want to calculate the median from and the comma indicates and. The median is the data value in the middle of the set.
