Question
The accompanying table provides data on students' pre-MBA salary and post-MBA salary expectations. Define range names for each of these ranges and then use the
The accompanying table provides data on students' pre-MBA salary and post-MBA salary expectations. Define range names for each of these ranges and then use the range names in formulas to find the expected salary increase for each of the respondents.
LOADING...
Click the icon to view the table on students' pre-MBA salary and post-MBA salary expectations.
Question content area bottom
Part 1
Define range names for each of these ranges. Which is a reasonable range name to give pre-MBA salary? Choose the correct answer below.
A.
Pre_MBA
Your answer is correct.
B.
Pre MBA
C.
pre-MBA-salary
D.
pre-MBA salary
Part 2
Which is a reasonable range name to give post-MBA salary? Choose the correct answer below.
A.
post-MBA-salary
B.
Post MBA
C.
post-MBA salary
D.
Post_MBA
Your answer is correct.
Part 3
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 | $85,000 | $105,000 | $enter your response here |
| 3 | 34 | F | More than 6 | Career Advancement | $85,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 | $93,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 | $46,000 | $70,000 | $enter your response here |
| 8 | 39 | M | More than 6 | Career Advancement | $70,000 | $130,000 | $enter your response here |
| 9 | 26 | F | 4 to 6 | Career Advancement | $53,000 | $75,000 | $enter your response here |
| 10 | 30 | M | More than 6 | Career Change | $76,000 | $110,000 | $enter your response here |
| 11 | 24 | M | 1 to 3 | Higher Financial Earnings | $52,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 | $53,000 | $70,000 | $enter your response here |
| 15 | 27 | F | 4 to 6 | Career Advancement | $61,000 | $90,000 | $enter your response here |
| 16 | 26 | F | 4 to 6 | Career Change | $65,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 | $85,000 | $105,000 | $enter your response here |
| 19 | 39 | F | More than 6 | Genuine Interest | $112,000 | $125,000 | $enter your response here |
| 20 | 24 | M | 1 to 3 | Higher Financial Earnings | $37,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 | $73,000 | $95,000 | $enter your response here |
| 23 | 28 | M | 4 to 6 | Career Advancement | $56,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 | $85,000 | $100,000 | $enter your response here |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started