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____

Answer 1

Answer:

At the end of year 10 will be 54 faculty.

Explanation:

A spreadsheet is attached,  with the amount at the beginning,  how much faculty are hired and how much leave the university.

The formula applied is

= the faculty at the beginning+ hired + ( the faculty at the beginning x 0.1)

At the end of year 10 will be 54 faculty.

Download xlsx