Salary Starting salary % Raise Raise after raise 75000 10% 7500 82500 82500 4% 3300 85800 85800 5% 4290 90090 7% 1% 1% 5% 9% 1% 1%
Question 2: When John started his first job, his first end-of-year salary was $82,500. In the
following years, he received salary raises as shown in the following table.
1. Fill the Table: Fill the following table showing his end-of-year salary for each year. I have
already provided the end-of-year salaries for the first three years. Calculate the end-of-year
salaries for the remaining years using Excel. (If you Excel answer for the top 3 cells is not the same as
the one in the following table, your formula / approach is incorrect) (2 points)
2. Geometric
the percentage figures provided in the second column named “% Raise”. (The geometric
mean for this calculation should be nearly identical to the arithmetic mean. If your answer
deviates significantly from the mean, it's likely incorrect. 2 points)
Step by step
Solved in 2 steps
