• EJF consulting is dedicated to income equality and wants to know if there is a difference in income based solely on gender, please select the appropriate analysis (one sample t-test, independent samples t-test or paired samples t-test) and conduct the analysis in Excel.

Employee Age Race Gender Tenure Income Yearly Yearly ID 2015 Sales Sales 2014 2015 Joe 22 Caucasia Male 1 year $60,000 $200,000 $210,000 Keylah 34 African- Female 10 years $80,000 $175,000 $170,000 American Ashley 54 Caucasia Female 27 years $150,000 $600,000 $650,000 Yukiko 27 Asian Female 3 years $70,000 $250,000 $240,000 Marrissa 45 Native- Female 12 years $90,000 $400,000 $350,000 American Zach 36 African- Male 8 years $75,000 $300,000 $320,000 American John 50 Caucasia Male 25 years $130,000 $1,000,00 $1,000,00 0 0 Ruth 62 Caucasia Female 33 years $250,000 $3,500,00 $4,000,00 n 0 Yuta 34 Asian Male 8 years $73,000 $275,000 $300,000 Tyrell 25 African- Male 2 years $63,000 $100,000 $90,000 American Lori 40 Caucasia Female 11 years $82,000 $320,000 $350,000 n Adoette 34 Native- Female 3 years $70,000 $245,000 $250,000 American Mary 29 Caucasia Female 4 years $72,000 $100,000 $150,000 n Dontae 38 African- Male 16 years $100,000 $450,000 $490,000 American Hikaru 42 Asian Male 17 years $105,000 $530,000 $600,000