1 / 16

Sorting, DCOUNT, & DAVERAGE

Sorting, DCOUNT, & DAVERAGE. Sorting, DCOUNT, & DAVERAGE. Type in data from WBK p. 7 in Excel Highlight the entire array of data. Sorting, DCOUNT, & DAVERAGE. Sorting:. Click here. Sorting, DCOUNT, & DAVERAGE. Pick a category to “sort by”: Age.

jetta
Download Presentation

Sorting, DCOUNT, & DAVERAGE

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. Sorting, DCOUNT, & DAVERAGE

  2. Sorting, DCOUNT, & DAVERAGE • Type in data from WBK p. 7 in Excel • Highlight the entire array of data

  3. Sorting, DCOUNT, & DAVERAGE • Sorting: Click here

  4. Sorting, DCOUNT, & DAVERAGE Pick a category to “sort by”: Age Choosing this will sort the data from smallest to largest (ascending) or vice versa Click here

  5. Sorting, DCOUNT, & DAVERAGE • And the result: • Sorting by “age” in ascending order

  6. Sorting, DCOUNT, & DAVERAGE • Excel has two special functions for analyzing lots of data with more than one set of criteria • DCOUNT: counts the number of times an event occurs meeting a criteria • DAVERAGE: finds the average of events meeting a criteria

  7. Sorting, DCOUNT, & DAVERAGE Copy & Paste the headers from your original data array somewhere in your worksheet. Type “blue” below where it says favorite color.

  8. Sorting, DCOUNT, & DAVERAGE Click here

  9. Sorting, DCOUNT, & DAVERAGE Clear the text and type in “DCOUNT” Click here and change to “All” Click here

  10. Sorting, DCOUNT, & DAVERAGE Should be highlighted Click here

  11. Sorting, DCOUNT, & DAVERAGE

  12. Sorting, DCOUNT, & DAVERAGE

  13. Sorting, DCOUNT, & DAVERAGE This means DCOUNT found 3 instances where a person’s favorite color was blue

  14. Sorting, DCOUNT, & DAVERAGE • DAVERAGE: • still need correct column headings • will find the average of criteria you specify

  15. Sorting, DCOUNT, & DAVERAGE • Sol: Specify database including column headings Type the name of the heading that you want to average in quotation marks Enter search criteria according to the column headings you copied and pasted

  16. Sorting, DCOUNT, & DAVERAGE

More Related