Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
(REV)00 Edition Edition
ISBN: 9780395977224
Author: Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher: McDougal Littell
Bartleby Related Questions Icon

Related questions

Question

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 Mean of Salary Raises: Calculate the geometric mean of the salary raises using 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)

Hint for the first part of question 2: To assist you with filling out the table in the first part of the question, I have provided the relevant syntax. The following are intended as hints only. For more details, please refer to the PowerPoint slides and the lecture video

Hint for the second part of question 2: To assist you with the second part of the question, which involves calculating the geometric mean, I use the following formulas. More details are provided in the PowerPoint slides and the video.

Geometric mean = GEOMEAN(Select all the values in % raise column + 1) -1

Starting salary

% Raise

Raise

Salary after raise

75000

10%

7500

82500

82500

4%

3300

85800

85800

5%

4290

90090

 

7%

 

 

 

1%

 

 

 

1%

 

 

 

5%

 

 

 

9%

 

 

 

1%

 

 

 

1%

 

 

A
B
Starting salary % Raise
с
D
E
Raise
Salary after raise
1 75000
0.1
=B2*C2
=B2+D2
2 =E2
0.04
=B3*C3
=B3+D3
3 =E3
0.05
=B4*C4
=B4+D4
4 =E4
0.07
=B5*C5
=B5+D5
5 =E5
0.01
=B6*C6
=B6+D6
6=E6
0.01
|=B7*C7
=B7+D7
7
=E7
0.05
=B8*C8
=B8+D8
8
=E8
0.09
=B9*C9
=B9+D9
9=E9
0.01
|=B10*C10
=B10+D10
10=E10
0.01
=B11*C11
=B11+D11
expand button
Transcribed Image Text:A B Starting salary % Raise с D E Raise Salary after raise 1 75000 0.1 =B2*C2 =B2+D2 2 =E2 0.04 =B3*C3 =B3+D3 3 =E3 0.05 =B4*C4 =B4+D4 4 =E4 0.07 =B5*C5 =B5+D5 5 =E5 0.01 =B6*C6 =B6+D6 6=E6 0.01 |=B7*C7 =B7+D7 7 =E7 0.05 =B8*C8 =B8+D8 8 =E8 0.09 =B9*C9 =B9+D9 9=E9 0.01 |=B10*C10 =B10+D10 10=E10 0.01 =B11*C11 =B11+D11
Expert Solution
Check Mark