Excel HW

WWCHiringAnalysis.xlsx

Sheet1

Application for Employment
Name	College GPA	Major Code	Refer-ences	Personal Interview Rating	Work Experience	Employ- ment Exam Score	School Rank	Invalid Scores/ Major?	Automatically Disqualified	Not Automatically Disqualified	Automatically Hired	Not Automatically Hired	No Decision
Anderson	3.7	2	2	5	TRUE	650	12	FALSE	FALSE	TRUE
Ryan	4.0	18	3	5	TRUE	800	1	FALSE	FALSE	TRUE
Greg	2.0	15	2	3	TRUE	780	5	TRUE	TRUE	FALSE
Jackie	3.2	30	2	4	TRUE	710	3	TRUE	FALSE	TRUE
Sandra	3.0	20	1	5	TRUE	600	26	FALSE	TRUE	FALSE
Lindsey	3.9	4	3	4	TRUE	740	15	FALSE	FALSE	TRUE
Carolyn	3.8	16	5	6	FALSE	720	8	FALSE	FALSE	TRUE
Steven	2.6	500	2	3	FALSE	299	55	TRUE	TRUE	FALSE
Max	3.8	19	4	1	TRUE	760	6	FALSE	TRUE	FALSE
All values True
Any values True
Number of True values