Can someone solve this, shown step by step
1 LastName Terminal Degree Salary 2 Almonte PhD Yrs of Experience Year of Joining Travel Status $153,000.00 2013 Blanchett $167,757.00 $70,925.00 $68,907.00 $168,772.00 $58,181.00 $155,653.00 $90,554.00 $50,145.00 $74,583.00 175,296.00 (A)Fill up Travel status column as follows - First class (salary more than 160 K) Executive status (100 to 160 K) Managerial class (70 to 100k) Regular (50K to 70k), Employee (0 to 50k) Use the most appropriate formula 2002 2015 2014 4 Caldera MS 5 Carroll BS 6 Chugh MS 7 Bertrand BS 8 Dorbor PhD 9 Folami MS 10 Katz 11 Kenney 12 Kimmel MS 2016 2015 (b) Questions: does year of joining affect salary? 2014 2002 Kolodziej 13 czyk 14 LaVoye PhD 15 Lecours MS $75,976.00 $194,465.00 $170,285.00 (c) Question: how does total average salary of all of employees, and average salary of PhDs, MS, BS vary with year of joining. Draw an appropriate chart BS $95,514.00 16 Mahoney MS McGover $53,529.00 $98,555.00 $53,969.00 2010 2011 2010 BS 18 McKeon MS 19 McKinlay BS McNaugh $193,410.00 $57,311.00 $63,303.00 $154,046.00 $59,666.00 $67,042.00 $70,943.00 20 ton PhD 12 21 Ortensi MS 2013 2014 2001 2014 2012 2016 er 23 Rivera BS 24 Rota 25 Schultz BS 26 Hurley PhD 27 Spellman MS 28 Sullivan MS 29 Weiss BS 30 Oh $91,898.00 $169,824.00 $94,138.00 $94,067.00 2013 Zegarows BS $82,881.00 2013 Zegarows 2 $82,881.00 $73,610.00 $75,047.00 $189,265.00 94,009.00 $194,163.00 $185,584.00 $195,421.00 5 32 Arsenis PhD 2015 34 Chace 35 Conro 36 Diaz MS 2002 2003 8 38 Dulieu PhD Frauendo $75,735.00 $50,193.00 $92,128.00 $74,886.00 6 40 lamele MS 41 Italia 42 Leone MS 2002 2 7 2 McCoriso 44 Mitchell PhD 45 Moise MS Nicholso $73,131.00 $58,582.00 $65,246.00 2012 $181,287.00 $63,773.00 $51,404.00 $77,228.00 $50,099.00 $69,715.00 $77,491.00 $88,481.00 $74,248.00 47 Nothe BS 48 Nunes MS 49 Park 50 Resnick PhD 2015 uza MS 52 Stafford MS 53 Stahr BS 54 Talbot MS Terranov 2003 2002 $65,533.00 $57,895.00 $66,556.00 $82,753.00 $81,209.00 $67,089.00 $69,775.00 $271,135.00 $66,009.00 56 Walker PhD 2012 58 Bedigian MS 59 Boyle BS 60 Conry 61 D'Andrea BS 62 Dans 63 Kansara MS 2015 2003 61 D'Andrea BS 62 Dans 63 Kansara MS 64 Kearney MS 65 Lang 66 Lawson MS $69,775.00 $271,135.00 $66,009.00 $83,966.00 $88,937.00 $68,363.00 2010 2003 2010 PhD 8 2003 McName $65,699.00 $51,408.00 $59,220.00 96,284.00 2011 2010 68 Mitchell PhD 69 Morgado MS 70 Norat MS Parentea 2013 $61,084.00 $92,146.00 $82,976.00 2012 2016 2014 72 Parks MS 73 Pasca BS Pasquare 74 Ili PhD $79,040.00 $175,866.00 $97,185.00 Patterso MS Patterso MS Penkofsk 78 Reardon MS 79Richard BS 80 Rushton PhD 81 Schurch MS 82 Smith MS 83 Storm BS 84 Tasillo MS 85 Teixeira BS 86 Tucker PhD 87 Vargas MS 88 Walsh MS 89 Didino BS $53,951.00 $157,379.00 $58,078.00 $87,232.00 $97,119.00 $74,201.00 $174,312.00 $81,809.00 $73,686.00 $281,614.00 $176,766.00 $83,499.00 $96,065.00 10 2016 2014 9 2003 2014 2010 2001 2014 10 90 Jaslowski MS $71,445.00 $54,245.00 2015 91 Miller BS 1 LastName Terminal Degree Salary 2 Almonte PhD Yrs of Experience Year of Joining Travel Status $153,000.00 2013 Blanchett $167,757.00 $70,925.00 $68,907.00 $168,772.00 $58,181.00 $155,653.00 $90,554.00 $50,145.00 $74,583.00 175,296.00 (A)Fill up Travel status column as follows - First class (salary more than 160 K) Executive status (100 to 160 K) Managerial class (70 to 100k) Regular (50K to 70k), Employee (0 to 50k) Use the most appropriate formula 2002 2015 2014 4 Caldera MS 5 Carroll BS 6 Chugh MS 7 Bertrand BS 8 Dorbor PhD 9 Folami MS 10 Katz 11 Kenney 12 Kimmel MS 2016 2015 (b) Questions: does year of joining affect salary? 2014 2002 Kolodziej 13 czyk 14 LaVoye PhD 15 Lecours MS $75,976.00 $194,465.00 $170,285.00 (c) Question: how does total average salary of all of employees, and average salary of PhDs, MS, BS vary with year of joining. Draw an appropriate chart BS $95,514.00 16 Mahoney MS McGover $53,529.00 $98,555.00 $53,969.00 2010 2011 2010 BS 18 McKeon MS 19 McKinlay BS McNaugh $193,410.00 $57,311.00 $63,303.00 $154,046.00 $59,666.00 $67,042.00 $70,943.00 20 ton PhD 12 21 Ortensi MS 2013 2014 2001 2014 2012 2016 er 23 Rivera BS 24 Rota 25 Schultz BS 26 Hurley PhD 27 Spellman MS 28 Sullivan MS 29 Weiss BS 30 Oh $91,898.00 $169,824.00 $94,138.00 $94,067.00 2013 Zegarows BS $82,881.00 2013 Zegarows 2 $82,881.00 $73,610.00 $75,047.00 $189,265.00 94,009.00 $194,163.00 $185,584.00 $195,421.00 5 32 Arsenis PhD 2015 34 Chace 35 Conro 36 Diaz MS 2002 2003 8 38 Dulieu PhD Frauendo $75,735.00 $50,193.00 $92,128.00 $74,886.00 6 40 lamele MS 41 Italia 42 Leone MS 2002 2 7 2 McCoriso 44 Mitchell PhD 45 Moise MS Nicholso $73,131.00 $58,582.00 $65,246.00 2012 $181,287.00 $63,773.00 $51,404.00 $77,228.00 $50,099.00 $69,715.00 $77,491.00 $88,481.00 $74,248.00 47 Nothe BS 48 Nunes MS 49 Park 50 Resnick PhD 2015 uza MS 52 Stafford MS 53 Stahr BS 54 Talbot MS Terranov 2003 2002 $65,533.00 $57,895.00 $66,556.00 $82,753.00 $81,209.00 $67,089.00 $69,775.00 $271,135.00 $66,009.00 56 Walker PhD 2012 58 Bedigian MS 59 Boyle BS 60 Conry 61 D'Andrea BS 62 Dans 63 Kansara MS 2015 2003 61 D'Andrea BS 62 Dans 63 Kansara MS 64 Kearney MS 65 Lang 66 Lawson MS $69,775.00 $271,135.00 $66,009.00 $83,966.00 $88,937.00 $68,363.00 2010 2003 2010 PhD 8 2003 McName $65,699.00 $51,408.00 $59,220.00 96,284.00 2011 2010 68 Mitchell PhD 69 Morgado MS 70 Norat MS Parentea 2013 $61,084.00 $92,146.00 $82,976.00 2012 2016 2014 72 Parks MS 73 Pasca BS Pasquare 74 Ili PhD $79,040.00 $175,866.00 $97,185.00 Patterso MS Patterso MS Penkofsk 78 Reardon MS 79Richard BS 80 Rushton PhD 81 Schurch MS 82 Smith MS 83 Storm BS 84 Tasillo MS 85 Teixeira BS 86 Tucker PhD 87 Vargas MS 88 Walsh MS 89 Didino BS $53,951.00 $157,379.00 $58,078.00 $87,232.00 $97,119.00 $74,201.00 $174,312.00 $81,809.00 $73,686.00 $281,614.00 $176,766.00 $83,499.00 $96,065.00 10 2016 2014 9 2003 2014 2010 2001 2014 10 90 Jaslowski MS $71,445.00 $54,245.00 2015 91 Miller BS
