1 / 10

Calculating Statistics in Microsoft Excel

Calculating Statistics in Microsoft Excel. Mean (Average). Click on the type of statistic you would like to create. If you need to learn how to round your answers, click below. Median. Mode. Range. On any page, click this button to return home. Angelene Hanna eTAG Herrington Elementary.

kineta
Download Presentation

Calculating Statistics in Microsoft Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Calculating Statistics in Microsoft Excel Mean (Average) Click on the type of statistic you would like to create. If you need to learn how to round your answers, click below. Median Mode Range On any page, click this button to return home. Angelene Hanna eTAG Herrington Elementary Rounding

  2. Mean Step 2: Type “Average” or “Mean,” and click on the box where you want the statistic to appear. Step 1: Enter the data. Step 3: Click on the “Formulas” tab. Select “More Functions.” Go to the “Statistical” Menu, and choose “AVERAGE.” Click to continue.

  3. Mean (continued) Step 4: When the “Function Arguments” window appears enter the first cell and last cell of the list of numbers you want averaged separated by a colon (:). Example: first:last. The average will appear in the cell you selected. Alternate: Type “=AVERAGE(firstcell:lastcell) in the formula bar.

  4. Median Step 2: Type “Median,” and click on the box where you want the statistic to appear. Step 1: Enter the data. Step 3: Click on the “Formulas” tab. Select “More Functions.” Go to the “Statistical” Menu, and choose “MEDIAN.” Click to continue.

  5. Median (continued) The median will appear in the cell you selected. Step 4: When the “Function Arguments” window appears enter the first cell and last cell of the list of numbers you want the median of separated by a colon (:). Example: first:last. Alternate: Type “=AVERAGE(firstcell:lastcell) in the formula bar.

  6. Mode Step 2: Type “Mode,” and click on the box where you want the statistic to appear. Step 1: Enter the data. Step 3: Click on the “Formulas” tab. Select “More Functions.” Go to the “Statistical” Menu, and choose “MODE.” Click to continue.

  7. Mode (continued) The mode will appear in the cell you selected. Step 4: When the “Function Arguments” window appears enter the first cell and last cell of the list of numbers you want the mode of separated by a colon (:). Example: first:last. Alternate: Type “=MODE(firstcell:lastcell) in the formula bar.

  8. Range Step 2: Type “Range,” and click on the box where you want the statistic to appear. Step 3: Tell Excel to find the difference in the maximum (max) and minimum (min) values. Type: =MAX(firstcell:lastcell)-MIN(firstcell:lastcell) In the formula bar. Step 1: Enter the data.

  9. Rounding to the Nearest Whole If you need to round to the nearest whole, click on the cell, right click, and select “Format Cells.” In the “Format Cells” window, choose the “Number Tab.” Select “Number,” and set the decimal places to “0.” This will round your number.

  10. Sources • Median Image: cityofeastlansing.com

More Related