A company has a database about employees. They want the following to be done:

• Create binary variables for if the employee has a bachelor's degree.
• Create binary variables for the categorical number of companies worked with categories for less than or equal to 5, 6 to 10, and greater than 11.
• Formulate a binary variable for if the person comes from a West Coast State or not (Hint: Get a map and look at Continental US states that border the pacific).
• Formulate a binary variable for low earners (those who earn less than 40,000 a year)

Employee Years in Present Joy Base Pay | Number of raises |Number of promotion|Number of companies worked fo |Education |Age Salary in detail Age in Det v Log(Salary) * Categoric Categorical Number of Cor + Modified Bas |Modified Age 44649.6055 45.9821541 3 45000 0 13 Less than BA 48 44432.78 50.43796 9.577257 0 11+ 15 Less than BA 53 52870.48 51.204527 10.0376 0 11+ 50543.0491 49.1173857 55000 85000 12 Less than BA 53 84279.06 52.189452 10.90189 0 11+ 82577.9699 51.5327146 55000 15 Less than BA 43 56873.2 41.817301 10.19888 1 11+ 53116.133 47.1871095 20 Less than BA 48 34954.48 45.660903 8.508047 0 11+ 37072.8278 45.0257931 w 35000 Ow O 12 Less than BA 53 35471.62 54.607753 8.60733 0 11+ 33901.7714 49.9849224 35000 35000 13 12 Less than BA 53 33682.32 53.72348 8.211299 2 11+ 38799.7623 53.0953425 20 Less than BA 43 34749.55 42.507336 8.465804 0 11+ 37133.4546 43.2544125 W W W w CO 35000 34191.51 48.931226 8.340816 35459.2696 35000 15 Less than BA 48 0 11+ 46.1769275 65000 11 BA or greater 48 67396.04 48.962022 10.52932 0 11+ 65961.223 49.2248312 23 Less than BA 38 34227.69 39.457427 8.349411 0 11+ 32029.4487 37.1271199 35000 35000 20 Less than BA 53 37316.56 54.372729 8.897896 2 11+ 38823.8982 48.0669321 W W W W 35000 12 Less than BA 33 37202.68 31.196554 8.882209 2 11+ 39201.9905 30.1650396 ONOOUI H W O O O O O N N O O O O NO O HO O 65000 12 BA or greater 38 67105.42 37.596536 10.52152 0 11+ 69805.1379 40.2073669 ANNENOAWONNEO 20 BA or greater 48 46721.17 47.49872 9.724431 0 11+ 49426.3306 51.8968668 23 15000 3 55000 12 Less than BA 53 55074.67 55.149062 10.12961 0 11+ 54381.1828 50.1617956 3 450000000 11 BA or greater 43 44563.62 42.185825 9.586282 0 11+ 40427.4593 38.1311196 10.10233 0 11+ 59822.6126 52.1523462 3 55000 12 BA or greater 53 54399.71 53.138173 15 Less than BA 43 42504.9 44.112535 9.433876 3+ 11+ 47423.6789 45.5860257 13 45000 1 BA or greater 23 35153.02 20.535211 8.547338 1