{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

6 Excel calculations (procedures)

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

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

© 2009 by Harvey A. Singer 1 OM 210 Statistical Analysis for  Management Data Summarization: Part 6. MS Excel ® Calculation of Some Common Statistics Dr. Harvey A. Singer School of Management George Mason University

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

View Full Document
© 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.
© 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.

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

View Full Document
© 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.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}