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.

Answer

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.

http://smallbusiness.chron.com/use-excel-mean-median-mode-ranges-28868.html

Topics

  • Last Updated Oct 12, 2020
  • Views 47
  • Answered By John Doncevic--Warren Library

FAQ Actions

Was this helpful? 0 0