Contents: Watch the video to see how to calculate the median: Can’t see the video? Click here. The median tells you where the middle of a data set is. It’s used for many real-life situations, like Bankruptcy law, where you can only claim bankruptcy if you are below the
median income in your state. The median formula is {(n + 1) ÷ 2}th, where “n” is the number of items in the set and “th” just means the (n)th number. To find the median, first order the numbers from smallest to largest. Then find the middle number. For example, the middle for this set of numbers is 5, because 5
is right in the middle: The 4th number in 1, 2, 3, 5, 6, 7, 9 is 5. A caution with using the median formula: The steps differ slightly depending on whether you have an even or odd amount of numbers in your data set. Example question: Find the median for the following data set: Step 1: Sort your data from the smallest number to the highest number. For this example data set, the order is: Step 2: Find the number in the middle (where there
are an equal number of data points above and below the number): Tip: If you have a large data set, divide the number in the set by 2. That tells you how many numbers should be above and how many numbers should be below. For example, 101/2 = 55.5. Ignore the decimal; 55 numbers should be above and 55 below. Example question: Find the median for the following data set: Step 1: Place the data in ascending order (smallest to highest). Step 2: Find the TWO numbers in the middle (where there are an equal number of data points above and below the two middle numbers). Step 3: Add the two middle numbers and then divide by two, to get the average: The median is 72.5. The median is very useful for describing things like salaries, where large figures can throw off the mean. The median salary in the U.S. as of 2012 was
$51,017. If an average was used, those American billionaires could skew that figure upwards. Let’s say you wanted to work for a small law firm that paid an average salary of over $73,000 to its 11 employees. You might think there’s a good chance you’ll land a great paying job. But take a closer look at how the average is calculated for those eleven employees: Average (Mean) = The two partners in the firm—Ted and Carly, have increased the average way beyond most of the salaries paid in the firm. See how the “average” can be misleading? A better way to describe income is to figure out the median — or the middle wage. If you took that same list of incomes and found the median, you would get a more realistic representation of income. The median is the middle number, so if you placed all of the incomes in a list (from smallest to largest) you would get: $17,400, $18,500, $20,000, $20,500 $21,000, $22,000, $27,000, $28,000, $29,000, $300,000, $300,000 It’s a more accurate representation of what people are actually being paid. Calculation for a Grouped Frequency DistributionAn easy way to ballpark the median(MD) for a grouped frequency distribution is to use the midpoint of the interval. If you need something more precise, use the formula: Step 1: Use (n + 1) / 2 to find out which interval has the MD. For example, if you have 11 intervals, then the MD is in the sixth interval: (11 + 1) / 2 = 12 / 2 = 6. This interval is called the MD group. Step 2: Calculate “A”: the cumulative percentage for the interval immediately before the median group. Step 3: Calculate “B”: subtract your step 2 value from 50%. For example, if the cumulative percentage is 45%, then B is 50% – 45% = 65%. Step 4: Find “C”: the range (how many numbers are in the interval). Step 5: Find “D”: the percentage for the median interval. Step 7: Find the median: Median = lower value + (B ÷ D) x C. That’s it! Find the median in ExcelContents:
Excel 2013Watch the video or read the steps below:
How to Find a Median in Excel 2013 There are two ways to find the median in Excel — with a function or with the Data Analysis tool. The Data Analysis Toolpak has several advantages over just entering formulas. First, it gives you access to many functions that aren’t available in the standard package of Excel (like histograms). Second, you won’t have to remember formulas, as the Toolpak is a Click and Go interface. MEDIAN functionStep 1: Type “=MEDIAN(A1:A12)” into a blank cell where “A1:A12” is the location of your data. For example, if you’ve typed your data into D1 to D12, change to “=MEDIAN(D1:D12)”. Data Analysis ToolpakStep 1: Click the “Data” tab and then click
“Data Analysis.” Median in Excel 2007-2010.Example question: Find the median for the following set: 123, 563, 567, 22, 498, 593, 947, 4, 46, 876, 223, 567.1 ,222.22. Step 1: Enter your data into a single column. For this example, type “123” into cell A1, press “Enter” and continue entering the numbers down the column from A1 to A13. Step 2: Click an empty cell. Step 3: Click the “Formulas” tab and then click “Insert Function.” Step 4: Type “Median” into the ‘Search for a function’ text box and then click “Go.” Median should be highlighted in the results list. Click “OK.” Step 5: Type the cell range into the “Number1” cell. In most cases, Excel will automatically populate this with your list already. If it doesn’t, type “A1:A13” into the Number1 box, where “A1:A13” is the actual location of your data. Step 6: Click “OK.” The answer will be displayed in the cell you selected in Step 2. For this sample, the median is 498. To Place Your Data in Order:
Median in Minitab (video)This video shows you how to find the median
in Minitab in under a minute: How to find the median in Minitab Can’t see the video? Click here. ---------------------------------------------------------------------------
Need help with a homework or test question? With Chegg Study, you can get step-by-step solutions to your questions from an expert in the field. Your first 30 minutes with a Chegg tutor is free! Comments? Need to post a correction? Please Contact Us. How do you find the median in math step by step?If there is an even number of numbers locate the two middle numbers so that there is an equal number of values to the left and to the right of these two numbers. Step 3: If there is an odd number of numbers, this middle number is the median. If there is an even number of numbers add the two middles and divide by 2.
How do you find median if it is between two numbers?In that case we find the middle pair of numbers, and then find the value that is half way between them. This is easily done by adding them together and dividing by two.
What is the median of 4 and 7?The mean of these middle values is (4 + 7) / 2 = 5.5 , so the median is 5.5.
|