Business Statistics Project
Statistical Analysis of Top Asia-Pacific B-Schools

7/19/2013
IMT Ghaziabad
By: Shagun Agarwal (1301-406) Ishpreet Singh Arora (1301-090)
Section G

Table Of Contents

Analysis 3 References 10

Table of Figures Figure 1: Showing the Students Enrollment Graph 3 Figure 2: Relationship between Full Enrollment & Students per Faculty 4 Figure 3: Relationship between Foreign Students & Full Enrollments 4 Figure 4: The number of colleges which include English test 5 Figure 5: Percentage of Colleges taking GMAT Scores 5 Figure 6: Starting Salary of the Faculty 6 Figure 7: Starting Salary of colleges requiring English Test 6 Figure 8: Starting Salaries of Colleges not requiring English Tests 7 Figure 9: The variation between the Local Tuition & Foreign Tuition 7 Figure 10: The no. of Colleges preferring experience candidates 8 Figure 11: Coefficient of Variation between enrollment, local tuition fee, foreign tuition cost & Starting Salary 9

Analysis

The project provides us details about the top 25 B-schools in Asia-Pacific region. Using different variables like Full-Time Enrollment, Students per Faculty, Local Tuition, Foreign Tuition, Age, Starting Salary, %Of Foreign, GMAT, English Test, & Work Experience various descriptive analysis has been done.
The observations made are presented in the report in different formats using graphs.

Figure 1: Showing the Students Enrollment Graph
Since the values range from as low as 12 & as high as 463 hence this variable cannot be used as a reliable source for calculation the central tendency. The mean of the above enrollment variable is 165.16. µ = 165.16

Figure 2: Relationship between Full Enrollment & Students per Faculty
This is the another graph showing the relation between the students per faculty and the number of enrollments because the faculty is the heart of the colleges. Hence a relationship between them will help in the central tendency.

Figure 3: Relationship between Foreign Students & Full Enrollments
The above graph shows the analogy between the foreign students out of the fully enrolled students.

Figure 4: The number of colleges which include English test The above figure shows that 68% of colleges do not take English test and the rest takes.

Figure 5: Percentage of Colleges taking GMAT Scores
Its shows that 44% of colleges do not take GMAT score and the rest takes.

Figure 6: Starting Salary of the Faculty

Figure 7: Starting Salary of colleges requiring English Test

Figure 8: Starting Salaries of Colleges not requiring English Tests
The above 2 graphs shows the variation in the starting salaries of colleges requiring English tests and not requiring English tests. The mean of starting salaries for colleges requiring English test is $45,088 & the mean for students not requiring English tests is $33,624.

Figure 9: The variation between the Local Tuition & Foreign Tuition
The most important observation from the analysis is the comparison between starting salary and local and foreign tuition costs. The correlation coefficient between starting salary and foreign tuition costs has turned out to be 0.667 while the same for local tuition costs is 0.786. These numbers illustrate that starting salary is more positively related to local tuition costs than to foreign tuition costs. Another insight leads to the difference between mean values of local and foreign tuition costs. While the mean local tuition cost is 12375$, the mean foreign tuition cost is considerably higher at the value of 16582$. The following is a combination of a column and a line diagram giving a clear picture of the above analysis.

Figure 10: The no. of Colleges preferring experience candidates
The above chart shows that only 24% of colleges do not prefer experienced candidates which are a very small ratio. Hence the colleges prefer experienced candidates in the competitive world.

It has also been observed that there is a difference in the mean starting salaries for schools requiring and not requiring work experience. The mean starting salary for schools requiring work experience is 41,305$ while the same for schools not requiring work experience turns out to be 24,583$. Moreover, there is a difference between the starting salaries for schools requiring English test and not requiring the test. The mean starting salary for the ones requiring the test is 45,088$ and for the ones not requiring the test is 33,624$.
One of the important measures to check consistency in statistical data is coefficient of variation. It is calculated by dividing the standard deviation of the variable by its mean. In our analysis, we have calculated the coefficient of variation of four variables – enrolment, local tuition fee, foreign tuition cost and starting salary.

Figure 11: Coefficient of Variation between enrollment, local tuition fee, foreign tuition cost & Starting Salary

References

1. Book of Statistics for Business & Economics 11th Edition by David R. Anderson, Dennis J Sweeny & Thomas A Williams.