Question

MATLAB code

Suppose you are a manager in charge of firing and promoting employees. In the interest of fairness, there will be no names attached to your decision, just employee numbers, their rating, and the salary they make. This data (for your 52 employees) is saved as EmployeeData.m (A sample of this data and how it's arranged is seen below). You've decided to fire/promote based on the following conditions: 1. If an employee makes less than $150,000 and they have a performance rating of 95 or higher, they get promoted. 2. If an emplyee makes $150,000 or more and has a rating of 65 or lower, they are fired 3. All other employees are uneffected. Employee Number Performance Rating Salary 5875511 64 5875510 78 5875509 5875508 58755071 5875506 5875505 93 5875504 52 5875503 86 146100 192700 189700 171800 56400 142500 84400 43000 175300 49 Create a script that will do the following: • Load in the file EmployeeData.mat • Separates the data into 3 column vectors (EmpNumber, EmpRating & EmpSalary respectively) • Calculate the number of people promoted (store this value as NumPromoted) • Calculate the number of people fired (store this value as Numfired) • Create a column vector of employee numbers for those who were promoted (Call it EmpGetting Promoted) • Create a column vector of employee numbers for those who were fired (Call it EmpGetting Fired)

Answer 1

code :

Here ,I used sample data . Use your .mat file to get results for 52 entries

Employee. mx 1 load EmployeeData.mat floading EmployeeData.mat file separating into three column vectors 3 EmpNumber = data (:,1); EmpRating = data (:, 2); EmpSalary = data (:,3); 7 calculating number of people promoted and Fired 8 NumPromoted = sum( EmpSalary < 150000 & EmpRating >= 95) 9 Numfire = sum (EmpSalary > 150000 & EmpRating <= 65) 13 14 15 16 columns with employee numbers of promoted and fired EmpGettingPromoted = EmpNumber(find (EmpSalary < 150000 & EmpRating >=95)) EmpGettingFired = EmpNumber(find (EmpSalary > 150000 & EmpRating <= 65))

>> data data = 5875511 5875510 5875509 5875508 5875507 5875506 5875505 5875504 5875503 146100 192700 189700 171800 56400 142500 84400 95000 175300

output :

Command Window >> Employee NumPromoted = 4 Numfire = 2 EmpGetting Promoted = 5875511 5875507 5875505 5875504 EmpGettingFired = 5875509 5875508 >> |

raw_code :

load EmployeeData.mat %loading EmployeeData.mat file

EmpNumber = data(:,1); %separating into three column vectors
EmpRating = data(:,2);
EmpSalary = data(:,3);

%calculating number of people promoted and Fired
NumPromoted = sum( EmpSalary < 150000 & EmpRating >= 95)
Numfire = sum(EmpSalary > 150000 & EmpRating <= 65)

%columns with employee numbers of promoted and fired
EmpGettingPromoted = EmpNumber(find(EmpSalary < 150000 & EmpRating >=95))
EmpGettingFired = EmpNumber(find(EmpSalary > 150000 & EmpRating <= 65))