Calculating mean and median and mode values

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

=average(range)

This will give you the average data in the range.

To get the median which is the value exactly in the middle.
=median(range)
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.
=mode(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.

 

 

Obaid

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: