This needs to be a managers report with quantitative analysis.

• Review Case Problem 3: Business Schools of Asia-Pacific Download Case Problem 3: Business Schools of Asia-Pacific from Chapter 3 and below excel spreadsheet

Business School	Full-Time Enrollment	Students per Faculty	Local Tuition ($)	Foreign Tuitiion ($)	Age	%Foreign	GMAT	English Test	Work Experience	Starting Salary ($)
Melbourne Business School	200	5	24,420	29,600	28	47	Yes	No	Yes	71,400		Salaries		Age		Foreign Tuition
University of New South Wales (Sydney)	228	4	19,993	32,582	29	28	Yes	No	Yes	65,200
Indian Institute of Management (Ahmedabad)	392	5	4,300	4,300	22	0	No	No	No	7,100		Mean	35870.83		Mean	28.375		Mean	16039.38
Chinese University of Hong Kong	90	5	11,140	11,140	29	10	Yes	No	No	31,000		Standard Error	4661.795		Standard Error	0.788992		Standard Error	1818.86
International University of Japan (Niigata)	126	4	33,060	33,060	28	60	Yes	Yes	No	87,000		Median	37700		Median	29		Median	17560
Asian Institute of Management (Manila)	389	5	7,562	9,000	25	50	Yes	No	Yes	22,800		Mode	7500		Mode	29		Mode	16000
Indian Institute of Management (Bangalore)	380	5	3,935	16,000	23	1	Yes	No	No	7,500		Standard Deviation	22838.04		Standard Deviation	3.865258		Standard Deviation	8910.558
National University of Singapore	147	6	6,146	7,170	29	51	Yes	Yes	Yes	43,300		Sample Variance	5.22E+08		Sample Variance	14.94022		Sample Variance	79398041
Indian Institute of Management (Calcutta)	463	8	2,880	16,000	23	0	No	No	No	7,400		Kurtosis	-0.74097		Kurtosis	-0.38404		Kurtosis	-0.56119
Australian National University (Canberra)	42	2	20,300	20,300	30	80	Yes	Yes	Yes	46,600		Skewness	0.298944		Skewness	0.102796		Skewness	0.038396
Nanyang Technological University (Singapore)	50	5	8,500	8,500	32	20	Yes	No	Yes	49,300		Range	80000		Range	15		Range	32060
University of Queensland (Brisbane)	138	17	16,000	22,800	32	26	No	No	Yes	49,600		Minimum	7000		Minimum	22		Minimum	1000
Hong Kong University of Science and Technology	60	2	11,513	11,513	26	37	Yes	No	Yes	34,000		Maximum	87000		Maximum	37		Maximum	33060
Macquarie Graduate School of Management (Sydney)	12	8	17,172	19,778	34	27	No	No	Yes	60,100		Sum	860900		Sum	681		Sum	384945
Chulalongkorn University (Bangkok)	200	7	17,355	17,355	25	6	Yes	No	Yes	17,600		Count	24		Count	24		Count	24
Monash Mt. Eliza Business School (Melbourne)	350	13	16,200	22,500	30	30	Yes	Yes	Yes	52,500
Asian Institute of Management (Bangkok)	300	10	18,200	18,200	29	90	No	Yes	Yes	25,000		Foreign %		Local Tuition		Students per
University of Adelaide	20	19	16,426	23,100	30	10	No	No	Yes	66,000
Massey University (Palmerston North, New Zealand)	30	15	13,106	21,625	37	35	No	Yes	Yes	41,400		Mean	27.29167		Mean	11873.04		Mean	8.625
Royal Melbourne Institute of Technology	30	7	13,880	17,765	32	30	No	Yes	Yes	48,900		Standard Error	5.149479		Standard Error	1535.193		Standard Error	1.043983
Jamnalal Bajaj Institute of Management Studies (Bombay)	240	9	1,000	1,000	24	0	No	No	Yes	7,000		Median	26.5		Median	11381.5		Median	7
Curtin Institute of Technology (Perth)	98	15	9,475	19,097	29	43	Yes	No	Yes	55,000		Mode	0		Mode	#N/A		Mode	5
Lahore University of Management Sciences	70	14	11,250	26,300	23	2.5	No	No	No	7,500		Standard Deviation	25.22719		Standard Deviation	7520.881		Standard Deviation	5.114451
Universiti Sains Malaysia (Penang)	30	5	2,260	2,260	32	15	No	Yes	Yes	16,000		Sample Variance	636.4112		Sample Variance	56563644		Sample Variance	26.15761
De La Salle University (Manila)	44	17	3,300	3,600	28	3.5	Yes	No	Yes	13,100		Kurtosis	0.50081		Kurtosis	1.128394		Kurtosis	-0.81081
												Skewness	0.969714		Skewness	0.744817		Skewness	0.694575
47					Enrolled					Range	90		Range	32060		Range	17
												Minimum	0		Minimum	1000		Minimum	2
Mean	27.291667					Mean	163.71					Maximum	90		Maximum	33060		Maximum	19
Standard Error	5.1494791					Standard Error	29.328					Sum	655		Sum	284953		Sum	207
Median	26.5					Median	112					Count	24		Count	24		Count	24
Mode	0					Mode	30
Standard Deviation	25.227192					Standard Deviation	143.68
Sample Variance	636.41123					Sample Variance	20644
Kurtosis	0.5008095					Kurtosis	-0.804
Skewness	0.969714					Skewness	0.7787
Range	90					Range	451
Minimum	0					Minimum	12
Maximum	90					Maximum	463
Sum	655					Sum	3929
Count	24					Count	24

Step 2: Do:

• Run descriptive statistics for the Data File AsiaMBA (Chapter 3) using the videoHow to Add Excel's Data Analysis ToolPak(Links to an external site.) for assistance.

In a managerial report, use the methods of descriptive statistics to

• Summarize the data in Data File AsiaMBA.
• Summarize each variable in the data set.

Step 3: Discuss:

• What new insights do these descriptive statistics provide concerning Asia-Pacific business schools? You should also analyze differences between local and foreign tuition costs, between mean starting salaries for schools requiring and not requiring work experience, and between starting salaries for schools requiring and not requiring English tests.