answersLogoWhite

0


Best Answer

The median can be calculated using the Median function. Assuming the values you wanted the median of were in cells B2 to B20, you could use the function like this:

=MEDIAN(B2:B20)

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you calculate the median using Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you calculate mid value in statistics using Excel?

You would use the MEDIAN function. If the cells with your data were from A2 to D50, then the function would be:=MEDIAN(A2:D50)


How do you calculate standard deviation using median?

You cannot because the standard deviation is not related to the median.


What is definition of average command in Excel?

The Average function in Excel totals a range of cells and divides the total by the amount of values in those cells. In mathematics this is known as the Arithmetic Mean.


What are the benefits in using Excel in bakery?

it can make your work easy 2 calculate....^_^ ^_^


How can you use Excel to calculate the remainder of a division question?

By using the =MOD function.


How do you find the median of a dataset in Microsoft access?

This is a tricky problem. There is no built in functionality to find the median in Access, but you can write some VBA code to do it for you: http://support.microsoft.com/kb/210581 Excel is generally a quicker way to calculate the median unless the dataset is too large.


How do I calculate compound average growth rate using excel?

use the rate function


How do you calculate Spearman's rank using excel?

See video at related links for instructions.


How do you calculate mean absolute deviation on excel?

There is no single function in Excel.You calculate the mean (average).For each observation, you calculate its deviation from the mean.Convert the deviation to absolute deviation.Calculate the mean (average) of these absolute deviations.


Can you calculate the mode mean and median of goals scored in a month?

You can calculate the mode, mean and median of any set of integers.


How do you calculate amount of data transfer?

If you are using Microsoft Word Excel then you could just use the Auto Sum.


How do you calculate mean and Median smaller then Standard deviation?

In the same way that you calculate mean and median that are greater than the standard deviation!