Resources: Microsoft Excel®,

Case Study: MBA Schools in Asia-Pacific

Review the Case Study: MBA Schools in Asia-Pacific and the

Case Study: MBA Schools in Asia-Pacific Data set

. 

Prepare a 1,050-word managerial report for your boss.

Use the following questions for guidelines and directions on what to include in the report:

1. What is the type of data (Quantitative or Qualitative) for each of the columns (variables) in the dataset? If quantitative, is the data discrete or continuous? Neatly summarize your response in a table for all the columns (variables).
2. Using Excel®, find the mean, median, standard deviation, minimum, maximum, and the three quartiles for each of the quantitative variables identified in part 1 above. Neatly summarize in a table on this document. Comment on what you observe.
3. What are the minimum and maximum full-time enrollments? Which schools have the minimum and maximum full-time enrollments?
4. What is the average number of students per faculty member? Is this low or high? What does this mean to prospective applicants who are interested in pursuing an MBA in one of the leading international business schools?
5. What are the mean, median, and modal ages? What does this mean to prospective applicants?
6. What is the mean percentage of foreign students? How many and which schools have 1% and 0% foreign students? Which schools have highest percentage of foreign students? Please state these percentages.
7. What percentage of schools require the GMAT test?
8. What percentage of schools require English tests such as Test of English as a Foreign Language (TOEFL)?
9. What percentage of schools require work experience? From this percentage, does this appear to be a significant factor in gaining admissions?
10. What are the mean and median starting salaries? Which schools have the minimum and maximum starting salaries? How much are these minimum and maximum salaries?
11. What are the mean tuition for foreign students and for local students? Does there appear to be a significant difference? What is the difference between the two means?
12. How many schools require work experience and how many of them don’t? What is the mean starting salary for schools requiring work experience? What is the mean starting salary for schools requiring no work experience?
13. How many schools require English tests and how many don’t? What is the mean starting salary for schools requiring English tests? What is the mean starting salary for schools requiring no English tests?
14. Comment on the skewness for the data on starting salaries:
15. Plot a histogram and determine the skewness.
16. Find the skewness coefficient.
17. Find the mean, median, and mode for starting salaries and compare the three measures to determine skewness.
18. Finally, use Empirical Rule on the starting salaries and determine whether the salaries follow the Empirical Rule.

Format your assignment consistent with APA format. 

Title ABC/ 1 23 Version X

1

Case Study: MBA Schools in Asia-Pacific

QNT/561 Version 9

1

University of Phoenix Material

Case Study: MBA Schools in Asia-Pacific

The pursuit of a higher education degree in business is now international. A survey shows 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 statistics, economics, banking, marketing, behavioral sciences, labor relations, decision making, strategic thinking, business law, and more.

After your MBA, you get a job at Bloomberg in its media division, Bloomberg Business. Your division publishes reviews and rankings for business schools in the US and internationally. Because of your strong analytical education from University of Phoenix, your boss assigns you to work on preparing an analysis for data gathered for leading business schools in the Asia-Pacific. The data set in the Excel® file shows some of the characteristics of the leading Asia-Pacific business schools.

Copyright © XXXX by University of Phoenix. All rights reserved.

Copyright © 2017 by University of Phoenix. All rights reserved.

2

>Case

0

,

0

,

0

0

Yes

,400

8

4

,993

,582

Yes No Yes

0

5

0

4,

22 0 No No No

0

5

0

11,140 29 10 Yes No No

4

33,060 28 60 Yes Yes No

5

Yes No Yes

0

5

1 Yes No No

6

0

29

Yes Yes Yes

,300

8

16,000 23 0 No No No

42 2

20,300 30 80 Yes Yes Yes

50 5

8,500 32 20 Yes No Yes

8

17 16,000

32 26 No No Yes

60 2

11,513 26

Yes No Yes

,000

8

34

No No Yes

7

17,355 25 6 Yes No Yes

13

30 30 Yes Yes Yes

300 10

18,200 29 90 No Yes Yes

20 19

30 10 No No Yes

30

37 35 No Yes Yes

30 7

32 30 No Yes Yes

0

9 1,000 1,000 24 0 No No Yes 7,000

15

29 43 Yes No Yes

14

23

No No No 7,500

30 5

2,260 32 15 No Yes Yes 16,000

17

28

Yes No Yes

Business School	Full-Time Enrollment	Students per Faculty	Local Tuition ($)	Foreign Tuition ($)	Age	%Foreign	GMAT	English Test	Work Experience	Starting Salary ($)
Melbourne Business School	2			0							5	2		4	42					2	9			6			2		8	4		7																																									Yes																																		No	7	1
University of New South Wales (Sydney)		22		19					32	29	28	65,		20
Indian Institute of Management (Ahmedabad)	392		4,								30	300	7,			10
Chinese University of Hong Kong		90		11,	14	3		1,000
International University of Japan (Niigata)	1		26		33,0	60	8	7,000
Asian Institute of Management (Manila)	389	7,562	9,000		25		50	22,	80
Indian Institute of Management (Bangalore)	380	3,9	35				16,000			23		7,500
National University of Singapore	147	6,146	7,		17	51		43
Indian Institute of Management (Calcutta)	463	2,880	7,400
Australian National University (Canberra)		20,300	46,600
Nanyang Technological University (Singapore)		8,500	49,300
University of Queensland (Brisbane)		13	22,800	49,600
Hong Kong University of Science and Technology		11,513		37		34
Macquarie Graduate School of Management (Sydney)	12	17,172	19,778	27	60,100
Chulalongkorn University (Bangkok)	200		17,355	17,600
Monash Mt. Eliza Business School (Melbourne)	350	16,200	22,500	52,500
Asian Institute of Management (Bangkok)		18,200	25,000
University of Adelaide	16,426	23,100	66,000
Massey University (Palmerston North, New Zealand)			15	13,106	21,625	41,400
Royal Melbourne Institute of Technology	13,880	17,765	48,900
Jamnalal Bajaj Institute of Management Studies (Bombay)		24
Curtin Institute of Technology (Perth)	98	9,475	19,097	55,000
Lahore University of Management Sciences	70	11,250	26,300	2.5
Universiti Sains Malaysia (Penang)		2,260
De La Salle University (Manila)	44	3,300	3,600	3.5	13,100

2/20/2020 Originality Report

https://vle.phoenix.edu/webapps/mdb-sa-BB300502SF160441/originalityReport/ultra?course_id=_145825_1&includeDeleted=true&paperId=25954865… 1/

4

SafeAssign Originality Report

QNT/561: Applied Business Research & Statistics • Wk 2 – Case Study: MBA Schools in Asia-Pacific [due Thursday 02/20/… • Submitted on Thu, Feb 20, 2020, 11:50 AM

Cylvania Allen View

Report Summary

View Originality Report – Old Design

INCLUDED SOURCES

Sources

Institutional database
(12)

%4

8

Student paper

Student paper
Student paper
Student paper

S d

Additional co…
Allen-Week 2-Case Study-…

%5

6

4
8

1

1

10

1

2

Case Study: MBA Schools in Asia-Pacific

Cylvania Allen

Applied Business Research & Statistics QNT/561

Professor Vellore Sunder

02/20/2020

Questions

1. The data provided in the case study clearly shows both the qualitative and quantitative data about the
variables under investigation. The variables such as the work experience, GMAT and English Test form the
qualitative variables while the quantitative variables include the discrete data and the continuous data as
shown in the table below. Quantitative variables Continuous and discrete data

Age discrete

Local tuition continuous

Full time enrolment discrete

Foreign tuition continuous

Students per category discrete

Starting salary continuous

% foreign continuous

2. (a) Full time enrolment Mean 165.1578

Median

126.0000

Standard Deviation 140.8411

Maximum 12.0000

Standard Deviation 463.0000

25th Quartile 44.0000

50th Quartile 126.0000

75th Quartile 240.0000

(b) Students per category Mean 8.4800

Median

7.0000

Standard Deviation 5.0589

Maximum 2.0000

Standard Deviation 19.0000

25th Quartile 5.0000

50th Quartile 7.0000

75th Quartile 13.0000

(c) Local tuition Mean 12374.9200

1
2

3

4
4

5

5

High risk

Additional content
Allen-Week 2-Case Study-QNT561

%56

Additional content
Data Set Asia-Pacific Case Study Week 2.xlsx

SafeAssign Originality Report
Report Summary

There is a very high probability that text in these papers was
copied from other sources. These papers include quoted or
paraphrased text in excess and need to be reviewed for
plagiarism.

Overall Text Similarity

Average Match

56 %
Highest Match

56 %
Allen-Week 2-Case Study-QNT5…

Originality Reports (2)

https://vle.phoenix.edu/webapps/mdb-sa-BB300502SF160441/originalityReport/ultra?attemptId=e284f35b-c209-418c-ad84-f6cedd5f32e7&course_id=_145825_1&includeDeleted=true&paperId=2595486573&print=true

https://vle.phoenix.edu/webapps/mdb-sa-BB300502SF160441/originalityReport/ultra?attemptId=e284f35b-c209-418c-ad84-f6cedd5f32e7&course_id=_145825_1&includeDeleted=true&paperId=2595486573&print=true&download=true

https://vle.phoenix.edu/webapps/mdb-sa-BB300502SF160441/originalityReport?attemptId=e284f35b-c209-418c-ad84-f6cedd5f32e7&course_id=_145825_1&includeDeleted=true&paperId=2595486573&force=true

2/20/2020 Originality Report

https://vle.phoenix.edu/webapps/mdb-sa-BB300502SF160441/originalityReport/ultra?course_id=_145825_1&includeDeleted=true&paperId=25954865… 2/4

Median

11513.0000

Standard Deviation 7778.4230

Maximum 1000.0000

Standard Deviation 33060.0000

25th Quartile 6146.0000

50th Quartile 11513.0000

75th Quartile 17172.0000

(d) Foreign tuition

Mean 16581.8000

Median

17765.0000

Standard Deviation 9134.8460

Maximum 1000.0000
Standard Deviation 33060.0000

25th Quartile 6.0000

50th Quartile

27.0000

75th Quartile 43.0000

(e) Age

Mean 28.3600

Median

29.0000

Standard Deviation 3.784618

Maximum 22.0000

Standard Deviation 37.0000

25th Quartile 25.0000

50th Quartile 29.0000

75th Quartile 30.0000

(f) % foreign

Mean 28.0800

Median
27.0000

Standard Deviation 25.0086

Maximum 0.0000

Standard Deviation 90.0000

25th Quartile 9000.0000

50th Quartile 17765.0000

75th Quartile 22500.0000

(h) Starting salary Mean 37292.0000

Median
6

7

6
8
8
High risk
Additional content
Allen-Week 2-Case Study-QNT561
%56
Additional content
Data Set Asia-Pacific Case Study Week 2.xlsx
SafeAssign Originality Report
Report Summary
There is a very high probability that text in these papers was
copied from other sources. These papers include quoted or
paraphrased text in excess and need to be reviewed for
plagiarism.
Overall Text Similarity
Average Match
56 %
Highest Match
56 %
Allen-Week 2-Case Study-QNT5…
Originality Reports (2)

2/20/2020 Originality Report

https://vle.phoenix.edu/webapps/mdb-sa-BB300502SF160441/originalityReport/ultra?course_id=_145825_1&includeDeleted=true&paperId=25954865… 3/4

41400.0000

Standard Deviation 23459.2500

Maximum 7000.0000

Standard Deviation 87000.0000

25th Quartile 16000.0000

50th Quartile 41400.0000

75th Quartile 52500.0000

3. Full-Time Enrollment

Minimum 12.0000

Maximum 463.0000

As observed in the table above, the Mascquarie recorded the lowest full-time enrollment. On the other

hand, Indian Institute of Management (Calcutta) recorded the highest number of full-time enrollment. 4.
The mean for all the faculty students is. Nonetheless, the number is relatively low thus the prospective
applicants interested in taking MBA in any of the best international business schools would not get chance.
5. Ages

Mean 28.36

Median 29

Mode 29

The table above illustrates the descriptive statistics and indicates students of the age of 29 as the ones that
mostly apply for enrollment. 6. The mean percentage of foreign students is 28.08%. The schools

which have 1% and 0% international students are as shown below. Schools %

a). Indian Institute of Management (Ahmedabad) 0

b). Indian Institute of Management (Calcutta) 0

c). Jamnalal Bajaj Institute of Management Studies (Bombay) 0

d). Indian Institute of Management (Bangalore) 1

In this regard, the schools having the highest percentage of foreign students are Australian National

University (Canberra), International University of Japan (Niigata), Asian Institute of Management (Bangkok)
and Asian Institute of Management (Manila) which are 80%, 60%, 90% and 60% respectively. 7. All

schools that require GMAT test are 14.

8. All schools that require English tests are 8.

9. All schools that require work experience are 19.

This percentage significantly seems to an important factor securing admissions. 10. Starting Salary ($)

Mean 37292

Median 41400

Minimum 7000

Maximum 87000

The mean and median starting salaries are $37292 and $41400 respectively. The schools with

minimum and maximum starting salaries are Jamnalal Bajaj Institute of Management Studies (Bombay) and
International University of Japan (Niigata) respectively. These minimum and maximum salaries are $7000
and $87000 respectively. 11. The mean for local students and foreign tuitions are $12374.92 and

$16581.8 respectively. Hence, there appears to be a significant difference.

12.

Number Mean for starting salary

Need work experience 19.00 41,305

Has no experience 6.00 24,583

In the table above, the nineteen (19) schools require work experience while six (6) does not require

work experience, whereas the mean for starting salary with experience and mean with no experience are

8
1
1
8

4

9

10
10
10
6

11

12

12

13

4
8
4
4
8
4
High risk
Additional content
Allen-Week 2-Case Study-QNT561
%56
Additional content
Data Set Asia-Pacific Case Study Week 2.xlsx
SafeAssign Originality Report
Report Summary
There is a very high probability that text in these papers was
copied from other sources. These papers include quoted or
paraphrased text in excess and need to be reviewed for
plagiarism.
Overall Text Similarity
Average Match
56 %
Highest Match
56 %
Allen-Week 2-Case Study-QNT5…
Originality Reports (2)

2/20/2020 Originality Report

https://vle.phoenix.edu/webapps/mdb-sa-BB300502SF160441/originalityReport/ultra?course_id=_145825_1&includeDeleted=true&paperId=25954865… 4/4

$41305 and 24,583 respectively. 13.

Number Mean starting salary

Require English tests 8 45,088

No English tests 17 33,624

In the table shown above, the eight (8) schools require English tests while only seventeen (17) does not

require it. The mean for starting salary with experience and needs English test and mean with no
experience in English test are $45088 and $33624 respectively. 14.

a) Coefficient of skewness is;

Skewness= 0.222903

b). Starting Salary ($)

Mean 37292.00

Median 41400.00

Mode 7500.00

15. Starting Salary ($)

Mean 37292.00

Standard Deviation 23459.25

Data that falls within 1 std is 68%

Data that falls within 2 std is 95%

Data that falls within 3 std is 99% Reference

Hanington, B., & Martin, B. (2019).

4
8
4
8
9

14

8

Universal Methods of Design Expanded and Revised: 125 Ways to Research Complex Problems,

Develop Innovative Ideas, and Design Effective Solutions. Rockport Publishers.

15 16

Word Count: Submitted on: Submission UUID: Attachment UUID:
849 02/20/20 ee506bae-bc54-8fe2-c224-926367ef5ab9 9ff68233-fda8-28a8-17ec-6b848986e17a

High risk
Additional content
Allen-Week 2-Case Study-QNT561
%56
Additional content
Data Set Asia-Pacific Case Study Week 2.xlsx
SafeAssign Originality Report
Report Summary
There is a very high probability that text in these papers was
copied from other sources. These papers include quoted or
paraphrased text in excess and need to be reviewed for
plagiarism.
Overall Text Similarity
Average Match
56 %
Highest Match
56 %
Allen-Week 2-Case Study-QNT5…
Originality Reports (2)