subject

Inputs: 1. (char) filename of an excel file containing information about the applicantsoutputs: 1. (struct) a 1xm structure array representing all the applicants 2. (struct) a 1xn structure array representing the selected applicantsfunction description: you are given information about the candidates in an excel file. the first row of the file contains headers, and is guaranteed to include 'name', 'gpa', 'education', 'experience', and'skills' in no particular order. in order to organize the applicants, create a structure array where each structure contains information about one specific applicant. the fields of the structure array are name (char), gpa (double), education (char), skills (cell), and experience (cell). skills andexperience may span multiple columns in the excel document (see example below); each value should be stored in a cell. first, each applicant should be added to a structure array, which is the first output of your function. it will be of size 1xm, where m is the number of rows in the excel file minus 1. the first structure in the array should contain the information in the second row in the excel file, the second structure contains the information in the third row, and so on. now that you have compiled your pool of applicants, it is time to develop the criteria to select the best candidates. you decide to use the candidategpa as the baseline for comparison, with a few caveats. since you are a proud yellow jacket, if any applicant received his or her education from'georgia institute of technology' or 'georgia tech', their candidate score should be their gpa multiplied by 1.5 since you know how hard it is to earn a good gpa here. if the education is from 'georgia tech university' or 'georgian tech', then you know they were trying their best, so their score will be 1.25 times their gpa. however, if any applicant received his or hereducation from'uga' or'university of georgia', their score will be 0.75 times their gpa. to select the best applicants, remove those who have a score less than the median of all the scores. sort the remaining candidates by their score in descending order. this will be your second output. hints: when a cell in the excel document is empty, the corresponding cell in raw stores nan. the isnan() function only work on inputs of typedouble.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 15:10
David is in week 3 of his current ashford course and has a paper due by monday night at midnight. he has finished everything but the concluding paragraph. as he boots up his computer to work on it, he sees a flash across the screen and then the screen goes black. he begins to panic as he tries desperately to turn the laptop back on. david should have saved his work on what kind of portable device?
Answers: 2
question
Computers and Technology, 23.06.2019 09:30
Facial expressions and gestures are examples of messages.
Answers: 3
question
Computers and Technology, 24.06.2019 10:00
When writing a business letter, how many times can you use the same merge field in a document? once once, unless using the address block feature unlimited it will depend on the type of document you choose
Answers: 1
question
Computers and Technology, 24.06.2019 10:30
You're programming an infinite loop. what must you include in your code to prevent crashes? in roblox
Answers: 2
You know the right answer?
Inputs: 1. (char) filename of an excel file containing information about the applicantsoutputs: 1. (...
Questions
Questions on the website: 13722361