6 Excel calculations (procedures)

6 Excel calculations (procedures) - Dr. Harvey A. Singer...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
© 2009 by Harvey A. Singer 1 OM 210 Statistical Analysis for  Management Data Summarization: Part 6. MS Excel ® Calculation Dr. Harvey A. Singer School of Management George Mason University
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
© 2009 by Harvey A. Singer 2 Mean To use the Excel built-in functions for calculating the mean, use the following procedure: Click on an empty cell under the column containing the data in the spreadsheet. Click the down arrow of the “AutoSum” icon in the ribbon at the top of the window. Click on “Average.” The cursor will change from a pointer to an unfilled cross. The data Excel thinks to use is automatically framed in “marching ants.” If this not correct, you may reselect the data by clicking and dragging the cursor over the data desired. After pressing “Enter” key, the average is calculated and automatically displayed in the selected cell.
Background image of page 2
© 2009 by Harvey A. Singer 3 Median To use the Excel built-in functions for calculating the median, use the following procedure: Click on an empty cell under the column containing the data. Click the down arrow of the “AutoSum” icon in the ribbon at the top of the window. In the “Insert Function” screen that appears, click the down pointing arrow next to “or select a category” and click on “Statistical.” The “Select a function” scroll box lists, in alphabetical order, all the functions statistical functions built into Excel. Scroll down the box. Click on “MEDIAN” to select it and then click “OK.” In the “Function Arguments” screen that appears, the first box for “Number 1” is selected and filled in by default. Disregard what is entered in the “Number 1” box and go to the next step to select the data of interest. Back on the spreadsheet behind this screen, click on the first data value and drag the cursor down the column to the last data value. The cell addresses of the data you want to use are automatically entered into the “Number 1” box. Click “OK.” The median of the selected data will be calculated and automatically entered into the cell.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
© 2009 by Harvey A. Singer 4 Mode To use the Excel built-in functions for calculating the mode, use the following procedure: Click on an empty cell in the spreadsheet. Click the down arrow of the “AutoSum” icon in the ribbon at the top of the window. In the “Insert Function” screen that appears, click the down pointing arrow next to “or select a category” and click on “Statistical.” The “Select a function” scroll box lists, in alphabetical order, all the functions statistical functions built into Excel. Scroll down the box. Click on “MODE” to select it and then click “OK.”
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/19/2011 for the course OM 210 taught by Professor Singer during the Spring '08 term at George Mason.

Page1 / 17

6 Excel calculations (procedures) - Dr. Harvey A. Singer...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online