Question: Use the range names in formulas to find the expected salary increase for each of the respondents. Fill in the expected salary increases below.(Simplify your
Use the range names in formulas to find the expected salary increase for each of the respondents. Fill in the expected salary increases below.(Simplify your answers.)
| A | B | C | D | E | F | G | |
| 1 | Age | Gender | Years Work Experience | Motivation | Pre-MBA Salary | Post-MBA Salary | Expected Salary Increase |
| 2 | 30 | M | More than 6 | Career Advancement | $86,000 | $105,000 | $enter your response here |
| 3 | 34 | F | More than 6 | Career Advancement | $89,000 | $100,000 | $enter your response here |
| 4 | 28 | M | 4 to 6 | Career Advancement | $70,000 | $100,000 | $enter your response here |
| 5 | 35 | M | More than 6 | Higher Financial Earnings | $94,000 | $125,000 | $enter your response here |
| 6 | 23 | M | 1 to 3 | Career Advancement | $51,000 | $60,000 | $enter your response here |
| 7 | 28 | F | 4 to 6 | Career Advancement | $47,000 | $70,000 | $enter your response here |
| 8 | 39 | M | More than 6 | Career Advancement | $72,000 | $130,000 | $enter your response here |
| 9 | 26 | F | 4 to 6 | Career Advancement | $54,000 | $75,000 | $enter your response here |
| 10 | 30 | M | More than 6 | Career Change | $74,000 | $110,000 | $enter your response here |
| 11 | 24 | M | 1 to 3 | Higher Financial Earnings | $50,000 | $80,000 | $enter your response here |
| 12 | 23 | M | 1 to 3 | Higher Financial Earnings | $42,500 | $85,000 | $enter your response here |
| 13 | 28 | M | 4 to 6 | Career Advancement | $71,000 | $90,000 | $enter your response here |
| 14 | 28 | M | 4 to 6 | Career Advancement | $55,000 | $70,000 | $enter your response here |
| 15 | 27 | F | 4 to 6 | Career Advancement | $62,000 | $90,000 | $enter your response here |
| 16 | 26 | F | 4 to 6 | Career Change | $63,000 | $80,000 | $enter your response here |
| 17 | 31 | M | More than 6 | Career Advancement | $90,000 | $100,000 | $enter your response here |
| 18 | 35 | M | More than 6 | Higher Financial Earnings | $87,000 | $105,000 | $enter your response here |
| 19 | 39 | F | More than 6 | Genuine Interest | $111,000 | $125,000 | $enter your response here |
| 20 | 24 | M | 1 to 3 | Higher Financial Earnings | $36,000 | $70,000 | $enter your response here |
| 21 | 30 | M | 4 to 6 | Career Change | $60,000 | $75,000 | $enter your response here |
| 22 | 35 | M | More than 6 | Career Advancement | $72,000 | $95,000 | $enter your response here |
| 23 | 28 | M | 4 to 6 | Career Advancement | $55,000 | $75,000 | $enter your response here |
| 24 | 23 | F | None | Higher Financial Earnings | $43,000 | $80,000 | $enter your response here |
| 25 | 29 | F | 4 to 6 | Career Advancement | $63,000 | $90,000 | $enter your response here |
| 26 | 33 | M | More than 6 | Higher Financial Earnings | $83,000 | $100,000 | $enter your response here |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help