Question

In: Computer Science

Lael Masterson works in the Student Activities Office at Valerian State College in Illinois. Lael has...

Lael Masterson works in the Student Activities Office at Valerian State College in Illinois. Lael has started compiling information on students who are interested in helping run student organizations at Valerian State, and she needs your help completing the workbook.
Switch to the Student Representatives worksheet. In cell E2, enter a formula using the HLOOKUP function as follows to determine a student's potential base hourly rate (which is based on the number of years of post-secondary education):

  1. Use a structured reference to look up the value in the Post-Secondary Years column. Retrieve the value in the 2nd row of the table in the range P13:U14, using an absolute reference. Because base hourly rate is tiered based on the number of years of education, find an approximate match.
  2. Fill the formula into the range E3:E31, if necessary.

Solutions

Expert Solution

a.

Student ID Name Age Post-Secondary Years Base Rate Class Finance Certified Grad Student Elected Qualified Driver Leadership Training Mentor Officer Qualified Tier
G62918 Kay Colbert 24 6 #REF! 2022 Yes Yes No Yes Yes Yes Yes 2 Student ID G62918
P49234 Michael Crozier 25 7 #REF! 2023 Yes Yes Yes Yes Yes Yes Elected 2 Student Name Kay Colbert
W99035 Brandon Miles 21 3 #REF! 2022 Yes No Yes No Yes Yes Elected 1
V42056 Michael Alvarez 22 4 #REF! 2023 Yes No No No Yes Yes Yes 2
T59828 Ida Smith 19 2 #REF! 2024 No No Yes No Yes No Elected 1
F72412 Betty Garza 24 6 #REF! 2025 Yes Yes No Yes Yes Yes Yes 2 Total Students Average Post-Secondary Years
W20999 Leroy Pirkle 28 10 #REF! 2022 Yes Yes No Yes Yes Yes Yes 2 Elected Students 11 4
Q18870 Warren Stewart 18 0 #REF! 2026 No No No No No No No 1 All Students 30 3.8
W75774 Stacy Wiggins 24 6 #REF! 2025 Yes Yes Yes Yes Yes Yes Elected 2
N25220 Billy Herald 21 3 #REF! 2022 No No No No Yes Yes No 1
O94361 Margaret Cruz 23 5 #REF! 2023 Yes No No Yes Yes Yes Yes 2
G87578 Chester Keese 18 0 #REF! 2024 No No No No No No No 1 Postsecondary Years 0 1 2 5 8
B68170 Claudette Littell 19 1 #REF! 2026 Yes No No No Yes No Yes 1 Base Rate 15 15.25 15.75 16.5 17.5
M89375 Florence Miller 21 3 #REF! 2023 Yes No No No Yes Yes Yes 1
S63900 Kimberly Gerace 26 8 #REF! 2023 Yes Yes No Yes Yes Yes Yes 2
Y96036 Roman Goble 22 4 #REF! 2025 Yes No No No Yes Yes Yes 2
C82505 Jocelyn Allen 22 4 #REF! 2022 Yes No Yes No Yes Yes Elected 2
Y75358 Ron Morse 20 2 #REF! 2022 Yes No No No Yes No Yes 1
J60811 Roberta Ervin 21 3 #REF! 2026 No No No No Yes Yes No 1
Q56783 James Rusnak 19 1 #REF! 2022 Yes No Yes No Yes No Elected 1
Q75281 Suzanne Lawrence 24 2 #REF! 2025 Yes No Yes Yes Yes No Elected 1
V73596 Shannon Garner 18 0 #REF! 2024 No No No No No No No 1
L86947 Emory Little 25 5 #REF! 2023 Yes Yes Yes Yes Yes Yes Elected 2
W90960 Laura L i 24 6 #REF! 2022 Yes Yes Yes Yes Yes Yes Elected 2
P40886 Floretta Cauthen 18 0 #REF! 2025 No No No No No No No 1
U88627 Beverly Berry 23 5 #REF! 2023 Yes No No Yes Yes Yes Yes 2
Y88831 Stephanie Papa 19 1 #REF! 2023 Yes No Yes No Yes No Elected 1
P83373 Wallace Rivera 29 9 #REF! 2023 Yes Yes No Yes Yes Yes Yes 2
B53454 Larry Russell 19 1 #REF! 2022 No No No No No No No 1
A60088 Aaron Sifford 25 7 #REF! 2023 Yes Yes Yes Yes Yes Yes Elected 2

b.HLOOKUP([@post-secontary years]),$p$13:$u$14,2,TRUE)

venereology answered 3 weeks ago
Next > < Previous

Related Solutions

A survey on the number of hours a college student works per week showed that the...
A survey on the number of hours a college student works per week showed that the hours varied from 5 to 61 where 5 was the lowest number and 61 was the highest number. Determine the class width, classes, class marks and class boundaries of a frequency distribution table if the work hours were grouped using 8 classes. You can make a table to help you do this. Note: there is no frequency column.
Assuming that a college is conducting a survey on student union activities. One of the questions...
Assuming that a college is conducting a survey on student union activities. One of the questions on the survey asks students what they think of the quality of work the student union is doing on campus. The possible responses are excellent, good, fair and poor. Another question on the survey asks students how they feel about a proposed fee increase to help fund the cost of building a new student dorm. The possible responses to this question are favor, oppose...
Scenario: You are the member of a student organization at Northeast State University which works to...
Scenario: You are the member of a student organization at Northeast State University which works to provide professional development opportunities for students. You saw an interesting article in a college magazine describing a “Suitable Suits” program another university implemented. Its career development office kept a closet with 21 crisp black suits of all sizes that students could borrow for job interviews. Students would make an appointment with the office and agree to dry clean the suits before returning them. The...
For ten years, Illinois Tool Works (ITW) has followed an acquisition strategy where it focused on...
For ten years, Illinois Tool Works (ITW) has followed an acquisition strategy where it focused on growing from 800 to 1,000 businesses, each of which sought to follow an 80/20 rule where 80% of revenues business came from 20% of its products or customers. In support of this strategy, ITW sent hundreds of managers for training to sharpen their negotiating and deal making skills. As a result, ITW bought 201 companies between 2004 and 2008. Indeed, new acquired companies added...
Illinois State is worried about the rise in crimes in the state. The State Crime Control...
Illinois State is worried about the rise in crimes in the state. The State Crime Control Unit engaged the services of a researcher to identify the factors that are contributing to rise in crime in the state. The researcher collected data for 50 cities within Illinois to ascertain the cause of rising crime. She collected data on seven variables including overall crime rate per 1 million residents in each of the 50 cities and reported violent crime rate per 100,000...
Illinois State is worried about the rise in crimes in the state. The State Crime Control...
Illinois State is worried about the rise in crimes in the state. The State Crime Control Unit engaged the services of a researcher to identify the factors that are contributing to rise in crime in the state. The researcher collected data for 50 cities within Illinois to ascertain the cause of rising crime. She collected data on seven variables including overall crime rate per 1 million residents in each of the 50 cities and reported violent crime rate per 100,000...
A college student has been looking for a new tires. The student feels that the warranty...
A college student has been looking for a new tires. The student feels that the warranty period is a good estimate of the tire life and that 10% interest rate is appropriate. Given 4 options find the minimum Equivalent Uniform Monthly Cost. (Note: the student wants to buy 4 tires) Hint use i/12 for computing the annual costs. Warranty time (months) Tire price (all 4 tires) Warranty time (months) Tire price (all 4 tires) 12 36 24 54 36 68...
Sam is a 25-year-old college student. He works full time in addition to taking a full...
Sam is a 25-year-old college student. He works full time in addition to taking a full course load. He usually eats fast-food cheeseburgers and fries in his car for lunch and a take-out pepperoni pizza right before bed. Sam has noticed that he has put on some extra weight in the past few months, and his clothes are fitting very tight. He also has been experiencing severe heartburn several nights a week. Come up with some changes that Sam can...
Janet is 22, and college student that recently moved out onto her own. She works part...
Janet is 22, and college student that recently moved out onto her own. She works part time and pays all her own bills. She has been vegan for about 8 months, and likes to go jogging 2-3 times per week. Because of limited finances, she often eats ramen, apples, carrots, whatever bread or pasta is on sale. She avoids going out to eat, and mostly packs her own lunch. She doesn’t usually eat breakfast, and often forgets to drink water...
(Please answer sub parts: A, B) The student population at the state college consists of 55%...
(Please answer sub parts: A, B) The student population at the state college consists of 55% females and 45% males. A. The college theater department recently staged a production of a modern musical. A researcher recorded the gender of each student entering the theater and found a total of 385 females and 215 males. Is the gender distribution for theater goers significantly different from the distribution for the general college? (Test at the .05 significance level using CV = 3.84)....
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT