MBA Motivation and Salary ExpectationsAgeGenderYears Work Experience30MMore than 634FMore than 628M4 to 635MMore than 623M1 to 328F4 to 639MMore than 626F4 to 630MMore than 624M1 to 323M1 to 328M4 to 628M4 to 627F4 to 626F4 to 631MMore than 635MMore than 639FMore than 624M1 to 330M4 to 635MMore than 628M4 to 623FNone29F4 to 633MMore than 6The Excel file MBA Motivation and SalaryExpectations provides data on students’ pre-MBA salary and post-MBA salary expectations.Define range names for each of these rangesand then use the range names in formulas tofind the expected salary increase for each ofthe respondents.
MotivationPre-MBA SalaryPost-MBA SalaryExpected Salary IncreaseCareer Advancement$85,000$105,000$20,000.00Career Advancement$87,000$100,000$13,000.00Career Advancement$70,000$100,000$30,000.00Higher Financial Earnings$95,000$125,000$30,000.00Career Advancement$52,000$60,000$8,000.00Career Advancement$47,000$70,000$23,000.00Career Advancement$70,000$130,000$60,000.00Career Advancement$55,000$75,000$20,000.00Career Change$75,000$110,000$35,000.00Higher Financial Earnings$50,000$80,000$30,000.00Higher Financial Earnings$42,500$85,000$42,500.00Career Advancement$70,000$90,000$20,000.00Career Advancement$55,000$70,000$15,000.00Career Advancement$60,000$90,000$30,000.00Career Change$65,000$80,000$15,000.00Career Advancement$90,000$110,000$20,000.00Higher Financial Earnings$87,000$105,000$18,000.00Genuine Interest$110,000$125,000$15,000.00Higher Financial Earnings$37,000$70,000$33,000.00Career Change$60,000$75,000$15,000.00Career Advancement$73,000$95,000$22,000.00Career Advancement$57,000$75,000$18,000.00Higher Financial Earnings$45,000$80,000$35,000.00Career Advancement$65,000$90,000$25,000.00Higher Financial Earnings$85,000$100,000$15,000.00
Syringe SamplesSampleSample ObservationsAverage valueSample 14.96004.94604.95004.95604.95804.954Sample 24.95804.92704.93504.94004.95004.942Sample 34.97104.92904.96504.95204.93804.951Sample 44.94004.98204.97004.95304.96004.961Sample 54.96404.95004.95304.96204.95604.957Sample 64.96904.95104.95504.96604.95404.959Sample 74.96004.94404.95704.94804.95104.952Sample 84.96904.94904.96304.95204.96204.959Sample 94.98404.92804.96004.94304.95504.954Sample 104.97004.93404.96104.94004.96504.954Sample 114.97504.95904.96204.97104.96804.967Sample 124.94504.97704.95004.96904.95404.959Sample 134.97604.96404.97004.96804.97204.970Sample 144.97004.95404.96404.95904.96804.963Sample 154.98204.96204.96804.97504.96304.970The Excel file Syringe Samples providesdata for 15 samples of an importantmeasurement in the manufacturingprocess for medical syringes. Definerange names for each of the samplesand then use these range names informulas to find the average value foreach sample.
Convert the Store and Regional Sales database to an Excel table. Use the techniques described in Exaa. the total number of units sold.3177b. the total number of units sold in the South region.763c. the total number of units sold in December.1107Store and Regional Sales DatabaseIDStore No.Sales RegionItem No.Item Description11 South2005 24" Monitor21 South2005 24" Monitor31 South2005 24" Monitor41 South3006 Wireless Keyboard51 South3006 Wireless Keyboard61 South3006 Wireless Keyboard71 South6050 PC Mouse81 South6050 PC Mouse91 South6050 PC Mouse101 South8500 Laptop111 South8500 Laptop121 South8500 Laptop132 South2005 24" Monitor142 South2005 24" Monitor152 South2005 24" Monitor162 South3006 Wireless Keyboard172 South3006 Wireless Keyboard182 South3006 Wireless Keyboard192 South6050 PC Mouse202 South6050 PC Mouse212 South6050 PC Mouse222 South8500 Laptop232 South8500 Laptop242 South8500 Laptop253 South2005 24" Monitor263 South2005 24" Monitor273 South2005 24" Monitor283 South3006 Wireless Keyboard293 South3006 Wireless Keyboard303 South
Upload your study docs or become a
Course Hero member to access this document
Upload your study docs or become a
Course Hero member to access this document
End of preview. Want to read all 66 pages?
Upload your study docs or become a
Course Hero member to access this document
Term
Summer
Professor
THOMAS
Tags
Southern United States, PayPal
