Question

I am trying to obtain the median and mode from a data sheet and cannot figure out how to get it working. What am I doing wrong in the function? I pasted an image to give an idea. This data goes up to row 409 for both destination and pallets.

Ive tried =MEDIAN(IF(Data!$A$5:$A$409="Riverside CA",Data!$B$5:$B$409))

Clipboard Font Alignment Number Styles Cells Editing D4 -MEDIAN(IF(Data !A1:A409-84, Data !B2:B409)) Mean pallet shipment Median pallet shipment Mode pallet shipment Oakland CA Portland OR Riverside CA Seattle WA #VALUE! #VALUE ! 22.2 19.0 22.2 23.0 0.0 10 #VALUE ! 12 13

Answer 1

Microsoft's Excel blog details the intricacies of the feature, but the short version is this: hit the End key on your keyboard to switch End mode on, then use shift plus an arrow key to select all the cells containing content in a given row or column

To find the median, your numbers have to be listed in numerical order from smallest to largest, so you may have to rewrite your list before you can find the median. The "mode" is the value that occurs most often. If no number in the list is repeated, then there is no mode for the list.
The Mean, Median and Mode are the arithmetic average of a data set. This is found by adding the numbers in a data set and dividing by how many numbers there are. ... The mode is the value that occurs the most often in a data set, and the range is the difference between the highest and lowest values in a data set.

Alignment Font Clipboard E1 RiversideCA SeattleWA 48 Portland 1 OklandCA 48 48 24 48 48 28 12 12 28 24 24 24 24 24 24 24 24 24 24 24 10 12 13 14 MEDIAN(A2:A13)MEDIAN(B2:B12) MEDIAN(C2:C13) MEDIAN(D2:D6) 15 24 24 24 16 MODE(A2:A13) MODE(B2:B12) MODE(C2:C13) MODE(D2:D6) 24 48 24 17 18 19 20 21