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, 23.06.2019 17:00
The camera still is bad even with the new iphone xr and especially in low light it is even worst because you can see the pixels more if its in low light. if all you apple customers want apple to fix this then lets fill there feedback with complaints about the
Answers: 1
question
Computers and Technology, 23.06.2019 22:30
You draw two cards from a standard deck of 52 cards, but before you draw the second card, you put the first one back and reshuffle the deck. (a) are the outcomes on the two cards independent? why?
Answers: 3
question
Computers and Technology, 24.06.2019 05:30
Someone plzz me which of these defines a social search? a. asking a search engine a question that is answered by a real person on the other sideb. modifying search results based on popularity of a web pagec.modifying search results based on a ranking of a web page
Answers: 2
question
Computers and Technology, 24.06.2019 09:30
Retype the statements, correcting the syntax errors. system.out.println("num: " + songnum); system.out.println(int songnum); system.out.println(songnum " songs"); note: these activities may test code with different test values. this activity will perform two tests: the first with songnum = 5, the second with songnum = 9. see how to use zybooks.
Answers: 1
You know the right answer?
Inputs: 1. (char) filename of an excel file containing information about the applicantsoutputs: 1. (...
Questions
question
Mathematics, 04.05.2020 22:44
question
Mathematics, 04.05.2020 22:44
question
English, 04.05.2020 22:44
question
Mathematics, 04.05.2020 22:44
question
Mathematics, 04.05.2020 22:44
question
Mathematics, 04.05.2020 22:44
Questions on the website: 13722363