{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Data Sets - Recoding Education variable construction...

Info icon This 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 cells 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 Coll. 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 cells 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 Illinois 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 college 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)
Image of page 1

Info icon This 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 Kivell Binder DRing 50 15.99 799.50 1/23/2012 Central Kivell Binder DRing 95 15.99 1,519.05 1/23/2012 Central Gill 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 Gill Pen 27 1.99 53.73 2/26/2012 Central Gill 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 Gill 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 Gill 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 Gill 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 Gill 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
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 ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern