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 03:10
Fill in the following program so that it will correctly calculate the price of the orange juice the user is buying based on the buy one get one sale.#include //main functionint main() { int cartons; float price, total; //prompt user for input information printf("what is the cost of one container of oj in dollars? \n"); scanf(" [ select ] ["%d", "%c", "%f", "%lf"] ", & price); printf("how many containers are you buying? \n"); scanf(" [ select ] ["%d", "%c", "%f", "%lf"] ", & cartons); if ( [ select ] ["cartons / 2", "cartons % 1", "cartons % 2", "cartons % price", "cartons / price", "cartons / total"] [ select ] ["=", "==", "! =", "< =", "> =", "< "] 0) total = [ select ] ["price * cartons", "cartons * price / 2 + price", "(cartons / 2) * price", "cartons / (2.0 * price)", "(cartons / 2.0) * price + price", "((cartons / 2) * price) + price"] ; else total = ((cartons / 2) * price) + price; printf("the total cost is $%.2f.\n", total); return 0; }
Answers: 2
question
Computers and Technology, 23.06.2019 18:30
List 3 items that were on kens resume that should have been excluded
Answers: 1
question
Computers and Technology, 23.06.2019 22:20
Read “suburban homes construction project” at the end of chapters 8 and 9 (in the textbook) and then develop a wbs (work breakdown structure) in microsoft excel or in microsoft word (using tables)
Answers: 1
question
Computers and Technology, 23.06.2019 22:30
The output voltage of a power supply is assumed to be normally distributed. sixteen observations are taken at random on voltage are as follows: 10.35, 9.30, 10.00, 9.96, 11.65, 12.00, 11.25, 9.58, 11.54, 9.95, 10.28, 8.37, 10.44, 9.25, 9.38, and 10.85
Answers: 1
You know the right answer?
Inputs: 1. (char) filename of an excel file containing information about the applicantsoutputs: 1. (...
Questions
question
Mathematics, 07.07.2019 17:00
question
Mathematics, 07.07.2019 17:00
question
Geography, 07.07.2019 17:00
question
Mathematics, 07.07.2019 17:00
Questions on the website: 13722359