Browse » Home
Monday, November 28, 2011
How to Use the Quartile Function in Excel
1. Open a new Microsoft Excel 2010 spreadsheet. Click on the top-left cell in the spreadsheet.
2. Type your data set into the first column of cells. Each number should have its own cell.
3. Click on cell 'B1.' Type in '=quar' to open a pop-up menu with three options. Double-click 'Quartile.exc' to use the newer version of the quartile function. Double-click 'Quartile.inc' to use the older version of the function. If you need this worksheet to work with earlier versions of Excel, double-click the 'Quartile' function. 'Quartile' and 'Quartile.inc' are the same, but only 'Quartile' works on earlier versions of Excel. Once you make your choice, Excel completes the function name and places an open parenthesis in the formula bar.
4. Click on cell 'A1' and hold down the mouse button. Drag the mouse to the last data entry in the column and release the button. Press the comma key.
5. Enter '1,' '2' or '3' into the formula bar. '1' gives your the first quartile, '2' gives you the second quartile, which is also the median, and '3' gives you the third quartile. If you are using the 'Quartile.inc' function, you can also enter '0' or '4,' which gives your the minimum value and maximum value, respectively.
6. Enter a close parenthesis and press the 'Enter' key. The formula disappears and is replaced by your desired quartile for the data set. The number that appears represents the value where the range of numbers is divided into quarters.