Calculating mean and median and mode values

To have the average of a certain data you can use the following


This will give you the average data in the range.

To get the median which is the value exactly in the middle.
If the values are even number, then the median would be the average of the 2 values in the middle.

To get the mode; which is the most common value in the range.

To get multiple most common values
=mode.mult(range) you can use after typing this formula what is called an array function using ctrl+shift+enter … this would be after selecting 2 cells.




Pharmacist, CPHQ, CHQO, Quality Coordinator, Chemotherapy Preparation incharge. Graduated pharmacy school in 2009 I stood with my classmates as we recited the “Oath of a Pharmacist” in. There is one particular vow that stood out to me as we recited the Oath and I embrace this vow, “I will apply my knowledge, experience, and skills to the best of my ability to assure optimal outcomes for my patients.” I love being a pharmacist because it allows me to use my knowledge, abilities, and talents to improve patient outcomes in the community hospital in which I am employed as the pharmacy clinical coordinator.

%d bloggers like this: