Use the range names in formulas to find the expected salary increase for each of the respondents. Fill in the expected salary increases below.

My Apps Dash x Content X Do Homework X G - Grammarly x Country Insigh x Mail - Behnou X * 2020-10-21 (1 X MBAMotivation x Pre-MBA Sala X + > C A mylab.pearson.com/Student/PlayerHomework.aspx?homeworkld=651133402&questionld=1&flushed=false&cld=7427705&back=https://mylab.pearson.com/... * * Update : Login Page e O My Apps Dashboa Courses Bb Supported File Ty.. Writing Center | B... Writing Center Sc... P General Format //... P APA Sample Pape.. PAPA Style Introdu. M Sign In | Connect.. MBA624-MSF624 - Business Analysis for Decision Making - T301 behnoush binesh 06/16/23 6:07 PM Homework: Assignment 2.0 - Database Analytics Question 1, 2.1.1 HW Score: 0%, 0 of 20 points Part 3 of 3 Points: 0 of 1 Save 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 Question list K O Question 1 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 C D E G O Question 2 1 Age Gender Years Work Experience Motivation Pre-MBA Salary Post-MBA Salary Expected Salary Increase 2 30 M More than 6 Career Advancement $87,000 $105,000 $ 3 3 F More than 6 Career Advancement $89,000 $100,000 O Question 3 4 2 M 4 to 6 Career Advancement $72,00 $100,000 5 35 M More than 6 Higher Financial Earnings $96,000 $125,000 6 2 M 1 to 3 Career Advancement $52,000 $60,000 O Question 4 7 28 F 4 to 6 Career Advancement $46,000 $70,000 8 39 M More than 6 Career Advancement $70,000 $130,000 O Question 5 9 26 F to 6 Career Advancement $55,000 $75,000 10 30 M More than 6 Career Change $74,000 $110,000 11 24 M 1 to 3 Higher Financial Earnings $52,000 $80,000 Question 6 12 23 M 1 to 3 Higher Financial Earnings $42,500 $85,000 13 28 M 1 to 6 Career Advancement $72,000 $90,000 14 28 M 1 to 6 Career Advancement $54,000 $70,000 O Question 7 15 27 F 4 to 6 Career Advancement $61,000 $90,000 16 26 F 4 to 6 Career Change $65,000 $80,000 17 31 M More than 6 Career Advancement $90,000 $100,000 O Question 8 18 35 M More than 6 Higher Financial Earnings $85,000 $105,000 19 39 F More than 6 Genuine Interest $1 10,000 $125,000 Help me solve this View an example Get more help - Clear all Check answerMy Apps Dash x Content X Do Homework X G - Grammarly x Country Insigh x Mail - Behnou X * 2020-10-21 (1 X MBAMotivation x Pre-MBA Sala X + > C A mylab.pearson.com/Student/PlayerHomework.aspx?homeworkld=651133402&questionld=1&flushed=false&cld=7427705&back=https://mylab.pearson.com/... * * Update : Login Page e O My Apps Dashboa Courses Bb Supported File Ty.. Writing Center | B... Writing Center Sc... P General Format //... P APA Sample Pape.. PAPA Style Introdu. M Sign In | Connect.. MBA624-MSF624 - Business Analysis for Decision Making - T301 behnoush binesh 06/16/23 6:07 PM Homework: Assignment 2.0 - Database Analytics Question 1, 2.1.1 HW Score: 0%, 0 of 20 points Part 3 of 3 Points: 0 of 1 Save 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 Question list K 5 35 M More than 6 Higher Financial Earnings $96,000 $125,000 O Question 1 6 23 M 1 to 3 Career Advancement $52,000 $60,000 7 28 F 4 to 6 Career Advancement $46,000 $70,000 O Question 2 8 39 M More than 6 Career Advancement $70,000 $130,000 9 26 F 4 to 6 Career Advancement $55,000 $75,000 10 30 M More than 6 Career Change $74,000 $110,000 O Question 3 11 24 M 1 to 3 Higher Financial Earnings $52,000 $80,000 12 23 M 1 to 3 Higher Financial Earnings $42,500 $85,000 13 28 M 4 to 6 Career Advancement $72,000 $90,000 O Question 4 14 28 M 4 to 6 Career Advancement $54,000 $70,000 15 27 F 4 to 6 Career Advancement $61,000 $90,000 16 26 F 4 to 6 Career Change $65,000 $80,000 O Question 5 17 31 M More than 6 Career Advancement $90,000 $100,000 18 35 M More than 6 Higher Financial Earnings $85,000 $105,000 19 39 Question 6 More than 6 Genuine Interest $1 10,000 $125,000 20 24 M 1 to 3 Higher Financial Earnings $35,000 $70,000 21 30 M 4 to 6 Career Change $62,000 $75,000 O Question 7 22 35 M More than 6 Career Advancement $71,000 $95,000 23 28 M 4 to 6 Career Advancement $56,000 $75,000 24 23 F None Higher Financial Earnings $44,000 $80,000 O Question 8 25 29 F 4 to 6 Career Advancement $63,000 $90,000 26 33 M More than 6 Higher Financial Earnings $84,000 $100,000 Help me solve this View an example Get more help - Clear all Check