Business Schools of Asia-PacificThe pursuit of a higher education degree in business is now international. A survey shows that more and more Asians choose the master of business administration (MBA) degree route to corporate success. As a result, the number of applicants for MBA courses at Asia- Pacific schools continues to increase.Across the region, thousands of Asians show an increasing willingness to temporarily shelve their careers and spend two years in pursuit of a theoretical business qualification. Courses in these schools are notoriously tough and include economics, banking, marketing, behavioral sciences, labor relations, decision making, strategic thinking, business law, and more. The data set in Table 3.11 shows some of the characteristics of the leading Asia-Pacific business schools.Managerial ReportUse the methods of descriptive statistics to summarize the data in Table 3.11. Discuss your findingsinclude a summary for each variable in the data set. Make comments and interpretations based on maximums and minimums, as well as the appropriate means and proportions. What new insights do these descriptive statistics provide concerning Asia-Pacific business schools?Summarize the data to compare the following: a. Any difference between local and foreign tuition costs.b .Any difference between mean starting salaries for schools requiring and not requiring work experience.c. Any difference between starting salaries for schools requiring and not requiring English tests.3. Do starting salaries appear to be related to tuition?4. Present any additional graphical and numerical summaries that will be beneficial in communicating the data in Table 3.11 to others.Can you please solve the problem by Excel? Business Schools of Asia-PacificThe pursuit of a higher education degree in business is now international. A surveyshows that more and more Asians choose the master of business administration(MBA) degree route to corporate success. As a result, the number of applicants forMBA courses at Asia- Pacific schools continues to increase.Across the region, thousands of Asians show an increasing willingness to temporarilyshelve their careers and spend two years in pursuit of a theoretical businessqualification. Courses in these schools are notoriously tough and include economics,banking, marketing, behavioral sciences, labor relations, decision making, strategicthinking, business law, and more. The data set in Table 3.11 shows some of thecharacteristics of the leading Asia-Pacific business schools.Managerial ReportUse the methods of descriptive statistics to summarize the data in Table 3.11. Discussyour findings.1. include a summary for each variable in the data set. Make comments andinterpretations based on maximums and minimums, as well as the appropriatemeans and proportions. What new insights do these descriptive statistics provideconcerning Asia-Pacific business schools?2. Summarize the data to compare the following:a. Any difference between local and foreign tuition costs.b. Any difference between mean starting salaries for schools requiring and notrequiring work experience.c. Any difference between starting salaries for schools requiring and notС.requiring English tests.3. Do starting salaries appear to be related to tuition?4. Present any additional graphical and numerical summaries that will be beneficialin communicating the data in Table 3.11 to others. TABLE 3.11DATA FOR 25 ASIA-PACIFIC BUSINESS SCHOOLSStudentsForeignTuitionStartingSalary($)LocalFull-TimeperTuitionEnglishWorkBusiness SchoolEnrollmentFaculty($)($)Age% ForeignGMATTestExperience29,60032,5824,30011,14033,0609,00016,0007,17016,000Melbourne Business School20024,42019,9934,30011,14033,060284771,40065,2007,10031,00087,00022,8007,50043,300YesNoYesUniversity of New South Wales (Sydney)Indian Institute of Management (Ahmedabad)Chinese University of Hong KongInternational University of Japan (Niigata)Asian Institute of Management (Manila)Indian Institute of Management (Bangalore)National University of SingaporeIndian Institute of Management (Calcutta)Australian National University (Canberra)Nanyang Technological University (Singapore)University of Queensland (Brisbane)Hong Kong University of Science and TechnologyMacquarie Graduate School of Management (Sydney)22842928YesNoYes39222NoNoNo902910YesNoNo12642860YesYesNo3897,5622550YesNoYes3803,935231YesNoNo1476,1462,88020,3008,5002951YesYesYes463237,40046,60049,30049,60034,00060,100NoNoNo4220,3008,50022,80011,51319,7783080YesYesYes503220YesNoYes1381716,00011,51317,1723226NoNoYes602637YesNoYes123427NoNoYesChulalongkorn University (Bangkok)Monash Mt. Eliza Business School (Melbourne)Asian Institute of Management (Bangkok)University of AdelaideMassey University (Palmerston North, New Zealand)Royal Melbourne Institute of Technology Business20017,35517,35525YesNoYes17,60035016,20022,5003030YesYesYes52,5003001018,20018,20016,42613,1062990NoYesYes25,00066,000201923,10021,6253010NoNoYes30153735NoYesYes41,400Graduate School30713,88017,7653230NoYesYes48,9001,00024YesJamnalal Bajaj Institute of Management Studies (Mumbai)Curtin Institute of Technology (Perth)Lahore University of Management SciencesUniversiti Sains Malaysia (Penang)De La Salle University (Manila)2409.1,000NoNo7,00098159,47519,0972943YesNoYes55,000701411,25026,300232.5NoNoNo7,500305Yes2,2603,3002,2603,6003215NoYes16,0004417283.5YesNoYes13,1005682 2 8 7 3

Question

Business Schools of Asia-PacificThe pursuit of a higher education degree in business is now international. A survey shows that more and more Asians choose the master of business administration (MBA) degree route to corporate success. As a result, the number of applicants for MBA courses at Asia- Pacific schools continues to increase.Across the region, thousands of Asians show an increasing willingness to temporarily shelve their careers and spend two years in pursuit of a theoretical business qualification. Courses in these schools are notoriously tough and include economics, banking, marketing, behavioral sciences, labor relations, decision making, strategic thinking, business law, and more. The data set in Table 3.11 shows some of the characteristics of the leading Asia-Pacific business schools.Managerial ReportUse the methods of descriptive statistics to summarize the data in Table 3.11. Discuss your findingsinclude a summary for each variable in the data set. Make comments and interpretations based on maximums and minimums, as well as the appropriate means and proportions. What new insights do these descriptive statistics provide concerning Asia-Pacific business schools?Summarize the data to compare the following:  a. Any difference between local and foreign tuition costs.b .Any difference between mean starting salaries for schools requiring and not requiring work experience.c. Any difference between starting salaries for schools requiring and not requiring English tests.3. Do starting salaries appear to be related to tuition?4. Present any additional graphical and numerical summaries that will be beneficial in communicating the data in Table 3.11 to others.Can you please solve the problem by Excel? Business Schools of Asia-PacificThe pursuit of a higher education degree in business is now international. A surveyshows that more and more Asians choose the master of business administration(MBA) degree route to corporate success. As a result, the number of applicants forMBA courses at Asia- Pacific schools continues to increase.Across the region, thousands of Asians show an increasing willingness to temporarilyshelve their careers and spend two years in pursuit of a theoretical businessqualification. Courses in these schools are notoriously tough and include economics,banking, marketing, behavioral sciences, labor relations, decision making, strategicthinking, business law, and more. The data set in Table 3.11 shows some of thecharacteristics of the leading Asia-Pacific business schools.Managerial ReportUse the methods of descriptive statistics to summarize the data in Table 3.11. Discussyour findings.1. include a summary for each variable in the data set. Make comments andinterpretations based on maximums and minimums, as well as the appropriatemeans and proportions. What new insights do these descriptive statistics provideconcerning Asia-Pacific business schools?2. Summarize the data to compare the following:a. Any difference between local and foreign tuition costs.b. Any difference between mean starting salaries for schools requiring and notrequiring work experience.c. Any difference between starting salaries for schools requiring and notС.requiring English tests.3. Do starting salaries appear to be related to tuition?4. Present any additional graphical and numerical summaries that will be beneficialin communicating the data in Table 3.11 to others. TABLE 3.11DATA FOR 25 ASIA-PACIFIC BUSINESS SCHOOLSStudentsForeignTuitionStartingSalary($)LocalFull-TimeperTuitionEnglishWorkBusiness SchoolEnrollmentFaculty($)($)Age% ForeignGMATTestExperience29,60032,5824,30011,14033,0609,00016,0007,17016,000Melbourne Business School20024,42019,9934,30011,14033,060284771,40065,2007,10031,00087,00022,8007,50043,300YesNoYesUniversity of New South Wales (Sydney)Indian Institute of Management (Ahmedabad)Chinese University of Hong KongInternational University of Japan (Niigata)Asian Institute of Management (Manila)Indian Institute of Management (Bangalore)National University of SingaporeIndian Institute of Management (Calcutta)Australian National University (Canberra)Nanyang Technological University (Singapore)University of Queensland (Brisbane)Hong Kong University of Science and TechnologyMacquarie Graduate School of Management (Sydney)22842928YesNoYes39222NoNoNo902910YesNoNo12642860YesYesNo3897,5622550YesNoYes3803,935231YesNoNo1476,1462,88020,3008,5002951YesYesYes463237,40046,60049,30049,60034,00060,100NoNoNo4220,3008,50022,80011,51319,7783080YesYesYes503220YesNoYes1381716,00011,51317,1723226NoNoYes602637YesNoYes123427NoNoYesChulalongkorn University (Bangkok)Monash Mt. Eliza Business School (Melbourne)Asian Institute of Management (Bangkok)University of AdelaideMassey University (Palmerston North, New Zealand)Royal Melbourne Institute of Technology Business20017,35517,35525YesNoYes17,60035016,20022,5003030YesYesYes52,5003001018,20018,20016,42613,1062990NoYesYes25,00066,000201923,10021,6253010NoNoYes30153735NoYesYes41,400Graduate School30713,88017,7653230NoYesYes48,9001,00024YesJamnalal Bajaj Institute of Management Studies (Mumbai)Curtin Institute of Technology (Perth)Lahore University of Management SciencesUniversiti Sains Malaysia (Penang)De La Salle University (Manila)2409.1,000NoNo7,00098159,47519,0972943YesNoYes55,000701411,25026,300232.5NoNoNo7,500305Yes2,2603,3002,2603,6003215NoYes16,0004417283.5YesNoYes13,1005682 2 8 7 3

Accepted Answer

Since you have posted a question with multiple sub-parts, we have answered first 3 sub-parts.
If you…