Q. How do I use Excel to find the Mean, Median & Mode of two columns of numbers?

It keeps doing the Mean, Median, & Mode of one column at a time.


According to the Small Business Chron website, select a blank cell and enter the following formula =AVERAGE(A1:B23). Change A1 and B23 to match the first cell in your first column (A1) and the last cell in your last column (B23). You will see a border appear around the columns outlining which columns you have selected. Hit Enter on your keyboard. This will give you the Mean of the two columns. To find the Median and the Mode, select a new blank cell and enter the formula as above, but change AVERAGE to MEDIAN. Repeat for the Mode, but change AVERAGE to MODE.



  • Last Updated Feb 02, 2017
  • Views 2
  • Answered By Elizabeth Fairall

FAQ Actions

Was this helpful? 0   0