6. According to camp policy, staff members need to be at least 23 years old to transport students. Dean now wants to determine h
ow many members of his staff will be available to drive. In cell J2, enter a formula using the IF function and a structured reference to determine if Adam Moriarty can be a Transportation team member. a. The IF function should first determine if the staff member’s age is greater than or equal to 23. Use a structured reference to the Age column. b. The function should return the text Yes if the staff member’s age is greater than or equal to 23. c. The function should return the text No if the staff member’s age is not greater than or equal to 23.
1 answer:
Answer:
This seems to be related to MS Excel, here we will discuss the related formula:
<u>=IF(VLOOKUP("Adam Moriarty",$B$3:$C$5,2)>23,"Yes","No")</u>
the name can also be written in adjacent to J2 cell i.e. I2 and its reference to be used in vlookup primary key as follows:
<u>=IF(VLOOKUP(I2,$B$3:$C$5,2)>23,"Yes","No")</u>
Explanation:
We have used simple IF function combined with VLOOKUP function to reference this formula to the table of names and ages of the members (here the table is $B$3:$C$5 and ages are mentioned in 2nd column of the table)
please find attached screenshot for clarification
You might be interested in
Answer:
#section 1
<em>no_of_days= int(input('How many days are we geting the average for: ')) </em>
<em>tem=[] </em>
<em>for i in range(no_of_days): </em>
<em> a= int(input('Enter temperaure: input ' + str(i+1)+' :')) </em>
<em> tem.append(a) </em>
<em />
#section 2<em> </em>
<em>average = round(sum(tem)/len(tem),2) </em>
<em>print('The Average is ',average) </em>
<em>gdays=[] </em>
<em>for i in tem: </em>
<em> if i > average: </em>
<em> gdays.append(i) </em>
<em> </em>
<em>print('The following days are greater than the average: ',gdays)</em>
Explanation:
The above code is written in python 3
#section 1:
An input is gotten for number of days that is to be used in the calculation, and an array is created to hold the temperature that will be inputted into the program.
A range of values from [0 - (no_of_days - 1)] is created from the number of days entered, this is done so that the FOR loop can iterate through every number and call for inputs.
The FOR loop prompts the user for an input based on the range and passes that input to an integer data type before appending it to the tem array.
#section 2:
The sum of the new list and the length is used to calculate the average and the it is rounded up to 2 DP, The average is then printed to the screen.
Another FOR loop is used to check which of the days are greater than the average and passes it to another array (<em>gdays)</em>, this array is also printed to the screen.
check the attachment to see how the code works.
