. Create Subtotals within Data

- Subtotal Retirement-Matching

- For "At each change in" use Department

- Explore all 3 levels in the Subtotal.

- Remove the Subtotals

A B C D E F G . I Faculty Data: Pair#2 Exploration and Practice 1 2 3 4 General Instructions appear to the right. Max Percent 3% Participates in Retirement Plan Sex F M F F M F Yes Yes Yes Yes Yes No F No Yes F F Yes F Yes M M Yes Yes Yes No 5 Last Name 6 Smith 7 Jacobson 8 Comensoli 9 Nelsen 10 Coats 11 Jackson 12 Bressette 13 Brown 14 Wolter 15 Mikkola 16 Downs 17 Nelson 18 Elemshire 19 Blackwell 20 Scheib 21 Fitzgerald 22 Rothenberger 23 Smythe 24 Young 25 Lu 26 Weeks 27 Garafano 28 Lewis 29 Bordeau 30 Lee 31 Neumann 32 Mack 33 Anderson 34 Stewart 35 Rais 26 Darkar First Name Alicia Andrew Angela Beth Bill Carole Cheryl Cheryl Christine Claudia Clifton Dale David Robin Earl Edmond James Janice Jeff Jim Jodie Karen Karl Katherine Kell Kenneth Kevin Kristen Mark Mary Department Accounting Management Finance Finance Accounting Accounting Accounting Accounting Accounting Finance Accounting Accounting Accounting Finance Management Management Management Management Management Accounting Finance Finance Management Management Finance Finance Management Accounting Accounting Finance Accounting Rank Full Prof Full Prof Associate Full Prof Assistant Instructor Instructor Full Prof Associate Associate Associate Full Prof Full Prof Instructor Instructor Associate Full Prof Associate Assistant Instructor Instructor Associate Associate Assistant Assistant Instructor Assistant Assistant Assistant Instructor CUL Draf Year Hired 2003 1985 1992 1991 2004 2006 2001 1992 1997 1990 1996 2002 2000 2006 2003 2004 2004 2000 2004 2004 2002 1993 1993 2000 2008 2002 2003 2002 2000 2007 M M . M M M Salary $97,569 $ 108,955 $87,231 $101,860 $89,317 $68,455 $73,497 $101,439 $88,502 $ 108,955 $92,046 $105,890 $103,375 $75,684 $ 74,950 $95,412 $118,855 $92,046 $85,973 $ 77,635 $67,143 $90,450 $94,746 $83,809 $81,450 $71,335 $84,150 $85,329 $93,358 $56,250 111 055 No Yes Yes Yes Yes Retirement- Matching $ $2,927 $3,269 $2,617 $3,056 $2,680 $0 $0 $3,043 $2,655 $3,269 $2,761 $3,177 $3,101 $0 $0 $2,862 $3,566 $2,761 $2,579 $0 $0 $2,714 $2,842 $2,514 $2,444 $0 $2,525 $2,560 $2,801 $0 2256 F M M F No No F Yes Yes M F M Yes Yes M M F No Yes Yes Yes No M F M Matbou 1000 Voo A B C D E F G . I Faculty Data: Pair#2 Exploration and Practice 1 2 3 4 General Instructions appear to the right. Max Percent 3% Participates in Retirement Plan Sex F M F F M F Yes Yes Yes Yes Yes No F No Yes F F Yes F Yes M M Yes Yes Yes No 5 Last Name 6 Smith 7 Jacobson 8 Comensoli 9 Nelsen 10 Coats 11 Jackson 12 Bressette 13 Brown 14 Wolter 15 Mikkola 16 Downs 17 Nelson 18 Elemshire 19 Blackwell 20 Scheib 21 Fitzgerald 22 Rothenberger 23 Smythe 24 Young 25 Lu 26 Weeks 27 Garafano 28 Lewis 29 Bordeau 30 Lee 31 Neumann 32 Mack 33 Anderson 34 Stewart 35 Rais 26 Darkar First Name Alicia Andrew Angela Beth Bill Carole Cheryl Cheryl Christine Claudia Clifton Dale David Robin Earl Edmond James Janice Jeff Jim Jodie Karen Karl Katherine Kell Kenneth Kevin Kristen Mark Mary Department Accounting Management Finance Finance Accounting Accounting Accounting Accounting Accounting Finance Accounting Accounting Accounting Finance Management Management Management Management Management Accounting Finance Finance Management Management Finance Finance Management Accounting Accounting Finance Accounting Rank Full Prof Full Prof Associate Full Prof Assistant Instructor Instructor Full Prof Associate Associate Associate Full Prof Full Prof Instructor Instructor Associate Full Prof Associate Assistant Instructor Instructor Associate Associate Assistant Assistant Instructor Assistant Assistant Assistant Instructor CUL Draf Year Hired 2003 1985 1992 1991 2004 2006 2001 1992 1997 1990 1996 2002 2000 2006 2003 2004 2004 2000 2004 2004 2002 1993 1993 2000 2008 2002 2003 2002 2000 2007 M M . M M M Salary $97,569 $ 108,955 $87,231 $101,860 $89,317 $68,455 $73,497 $101,439 $88,502 $ 108,955 $92,046 $105,890 $103,375 $75,684 $ 74,950 $95,412 $118,855 $92,046 $85,973 $ 77,635 $67,143 $90,450 $94,746 $83,809 $81,450 $71,335 $84,150 $85,329 $93,358 $56,250 111 055 No Yes Yes Yes Yes Retirement- Matching $ $2,927 $3,269 $2,617 $3,056 $2,680 $0 $0 $3,043 $2,655 $3,269 $2,761 $3,177 $3,101 $0 $0 $2,862 $3,566 $2,761 $2,579 $0 $0 $2,714 $2,842 $2,514 $2,444 $0 $2,525 $2,560 $2,801 $0 2256 F M M F No No F Yes Yes M F M Yes Yes M M F No Yes Yes Yes No M F M Matbou 1000 Voo