A university begins Year 1 with 80 faculty. They hire 4 faculty each year. Durin

Question

A university begins Year 1 with 80 faculty. They hire 4 faculty each year. During each year 10% (rounded to the nearest integer) of the facuity present at the beginning of the year leave the university. For example, in a year where there are 73 faculty at the beginning of the year, 7 would leave the university at the end of the year. The university wants to know how many faculty they will have at the end of year 10. The resulting spreadsheet can be found below. In cell G9 the first cell address referred to was cell E9. If the formula is entered in cell G9 and is copied down to G10:G18, what is it followed by? O-ROUND(E9 SES3,0) +INT(SES3 E9,0) -ROUNDUP(E9 SES3,0) 3 Quit rate 4 Hires per year 5 Starting number of facutly None of the above et Starting faculty Hires faculty Ending s Year 10 72 69 12 13 14 63 61 59 57 16 17 18 19 10

Explanation / Answer

In G9 apply

E9 - ROUND(E9*$E$3, 0) + F9

And for the final answer, we can apply at G18

E9:E18 - ROUND(E9:E18*$E$3,0) + F9:F18

where E9: E18 means, the sum of numbers of column E from 9 to 18 row

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.