Analyzing multiple data sets

[charliec02]

I have 54 columns of data and I need to find the mean, median, mode, and stndev for each. Is there a way to find a different statistic for the same data easily.

EX
Mode of
A2-A28
B2-B28
C2-C28
D2-D28

after i analyze this data is there a way to then find the median of these different sets of data.

[MrShorty]

You can calculate the arithmetic mean from the AVERAGE() function, the median from the MEDIAN() function, the mode from one of the MODE() functions and the standard deviation from the STDEV() function (help files for all functions: https://support.office.com/en-us/art...rs=en-US&ad=US )

If you use relative references, you can copy a function and it will refer to data relative to its position (see here for an introduction to using formulas and functions in a spreadsheet: https://support.office.com/en-us/art...es_in_formulas ). For example, you could enter =AVERAGE(A2:A28) in A30 and it will calculate the average/mean of the data in column A. If you copy/fill this formula across, the relative references will follow the copy, so that B30 becomes =AVERAGE(B2:B28) and so on across. You can do the same for the other functions as well.