1 / 17

Beyond mean and standard Deviation…

Beyond mean and standard Deviation…. AMTRA Presentation – 3/14/09 Presented by: Anne Geraci. Course contents. What do the mean & standard deviation tell us? Overview: Pivot tables Lesson: Mining for data! Lesson: Grouping & Advanced Techniques. Mean. … but what does this mean?.

luisa
Download Presentation

Beyond mean and standard Deviation…

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. Beyond mean and standard Deviation… AMTRA Presentation – 3/14/09 Presented by:Anne Geraci

  2. Course contents • What do the mean & standard deviation tell us? • Overview: Pivot tables • Lesson: Mining for data! • Lesson: Grouping & Advanced Techniques Get started with PivotTable reports

  3. Mean … but what does this mean?

  4. How old are you?

  5. … but what does this mean? • The “typical” age of the individuals in this sample is 51.2 years old. • The youngest person is 37. • The oldest person is 61. • The “average” deviation from 51.2 was 9.2 years. • By the empirical rule, 68% of people in this sample (or in the represented population) will be within 9.2 years (1 standard deviation) of 51.2, a range of 42 to 60 years old.

  6. To get a better understanding of the data, we need to look beyond just the surface … • Is there a difference in age between a “typical” female and a “typical” male? • What about the color of the car that people drive? Are older people more likely to drive a certain color car?

  7. Data-mining

  8. overview What’s a pivot table?

  9. What’s a pivot table? Get started with PivotTable reports

  10. What’s a pivot table? COLUMNVARIABLE ROWVARIABLE Get started with PivotTable reports

  11. What’s a pivot table? DATA SUMMARIZEDDATA Get started with PivotTable reports

  12. What’s a pivot table? ROW & COLUMN TOTALS Get started with PivotTable reports

  13. Step 1. Prepare your data • Each column = 1 field • Field Name in Row 1 • No blank rows or columns • All data in one column must be similar (numeric or text) Get started with PivotTable reports

  14. Step 2. Create PivotTable Excel 2007 – Insert tab, Tables group, click PivotTable, then PivotTable again For Excel 2003, click on Data, then PivotTable Get started with PivotTable reports

  15. Step 2. Create PivotTable … select the range for your data and click OK. Get started with PivotTable reports

  16. Step 3. Select fields Get started with PivotTable reports

  17. Let’s try it! Get started with PivotTable reports

More Related