Data Sets

Data Sets - Recoding Education variable construction...

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

View Full Document Right Arrow Icon
Recoding The VLOOKUP function in the Education variable in the Data sheet looks in cel s I6:I20 and when it finds a match, reports the corresponding value. Education variable construction For example, the formula =VLOOKUP(C5,HGAtoEDUC,2,FALSE) finds where a match to C5 (41) occurs in the range I5:J20 (HGAtoEDUC) and reports the value in the second column, Some Col . Arbitrary mapping of categories to years in school. FALSE forces an exact match to be found. Count of Education VLOOKUP Table Education Total HGA Educ 31 8 32 1 8 32 8 33 2 8 33 8 34 5 8 34 8 35 8 9 35 9 36 18 10 36 10 37 19 11 37 11 To change the Education variable mapping, simply change the values of the cel s in J6:J20. 38 7 11.5 38 11.5 The two buttons are just a short-cut for doing two possible mappings. 39 233 12 39 12 40 105 13 40 13 Remember to refresh the Pivot Table after you change the mapping. 41 46 13 41 13 42 23 14 42 14 43 78 16 43 16 44 40 18 44 18 45 8 18 45 18 46 5 18 46 18 Grand Total 598 Pivot Table deadened by PasteSpecial:Values Use Excel's Help on VLOOKUP to get more information. GMSTCEN State 31 Ohio 32 Indiana 33 Il inois 34 Michigan 35 Wisconsin 0 Children 31 Less than 1st grade 32 1st,2nd,3rd,or 4th grade 33 5th or 6th grade 34 7th and 8th grade 35 9th grade 36 10th grade 37 11th grade 38 12th grade no diploma 39 High school graduate-high school diploma 40 Some col ege but no degree 41 Assc degree-occupation/vocation 42 Assc degree-academic program 43 Bachelor's degree (BA,AB,BS) 44 Master's degree  (MA,MS,MENG,MED,MSW,MBA) 45 Professional school degree (MD,DDS,DVM,L 46 Doctorate degree (PHD,EDD)
Background image of page 1

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

View Full Document Right Arrow Icon
SALES DATA BY DATE AND SALES REP 1/6/2012 East Parent Binder DRing 74 15.99 1,183.26 1/6/2012 East Jones Pencil 95 1.49 141.55 1/6/2012 East Jones Pencil 80 1.49 119.20 1/23/2012 Central Kivel Binder DRing 50 15.99 799.50 1/23/2012 Central Kivel Binder DRing 95 15.99 1,519.05 1/23/2012 Central Gil Binder DRing 5 15.99 79.95 2/9/2012 Central Parent Pen 75 1.99 149.25 2/9/2012 Central Jardine Pencil 36 1.49 53.64 2/9/2012 Central Jardine Pencil 5 1.49 7.45 2/26/2012 Central Gil Pen 27 1.99 53.73 2/26/2012 Central Gil Pen 15 1.99 29.85 2/26/2012 Central Jones Pen 50 1.99 99.50 3/15/2012 West Parent Pen Set 76 4.99 379.24 3/15/2012 West Sorvino Pencil 56 1.49 83.44 3/15/2012 West Sorvino Pencil 62 1.49 92.38 4/1/2012 East Jones Binder DRing 60 15.99 959.40 4/1/2012 East Jones Binder DRing 50 15.99 799.50 4/1/2012 East Gil Binder DRing 7 15.99 111.93 4/18/2012 Central Andrews Pencil 75 1.49 111.75 4/18/2012 Central Andrews Pencil 55 1.49 81.95 4/18/2012 Central Smith Pencil 80 1.49 119.20 5/5/2012 Central Smith Binder DRing 81 15.99 1,295.19 5/5/2012 Central Jardine Pencil 90 1.49 134.10 5/5/2012 Central Jardine Pencil 42 1.49 62.58 5/22/2012 West Smith Desk 87 125 10,875.00 5/22/2012 West Thompson Pencil 32 1.49 47.68 5/22/2012 West Thompson Pencil 3 1.49 4.47 6/8/2012 East Jones Binder DRing 60 15.99 959.40 6/8/2012 East Jones Binder DRing 36 15.99 575.64 6/8/2012 East Gil Pen 7 1.99 13.93 6/25/2012 Central Morgan Pencil 90 1.49 134.10 6/25/2012 Central Morgan Pencil 7 1.49 10.43 6/25/2012 Central Smith Pencil 90 1.49 134.10 7/12/2012 East Howard Binder DRing 29 15.99 463.71 7/12/2012 East Howard Binder DRing 27 15.99 431.73 7/12/2012 East Gil Pencil 11 1.49 16.39 7/29/2012 East Parent Binder DRing 81 15.99 1,295.19 7/29/2012 East Parent Binder DRing 56 15.99 895.44 7/29/2012 East Gil Pencil 11 1.49 16.39 8/15/2012 East Sorvino Binder DRing 90 15.99 1,439.10 8/15/2012 East Jones Pencil 35 1.49 52.15 8/15/2012 East Andrews Pencil
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

Data Sets - Recoding Education variable construction...

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

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