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 faculty 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. The formula copied down from E10 to E11:E18 was Note: If the answer is a formula, there is no need to begin that answer with =. Please do not put any unnecessary spaces or 0 in your response 3 4 S Quit rate Hires per year Starting number of facutly Starting faculty Hires faculty Ending 8 Year 80 76 72 69 63 61 59 57 4 69 12 13 14 15 16 17 10 19

Explanation / Answer

Answer :

The formula in cell G9 should be

E9 - ROUND (0.1 * E9, 0) + F9

Since the first reference is to cell E9, the round function should be used to subtract the number of faculties leaving each year (rounds to the nearest integer)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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