Expert answer:MBA Schools in Asia-Pacific
Expert answer:Remove plagiarism and attach turintin reportPurpose of AssignmentThe purpose of this assignment is to develop students’ analytical capabilities to evaluate, analyze, and apply descriptive statistics techniques to real-world datasets.Assignment StepsResources: Microsoft Excel®, Case Study: MBA Schools in Asia-Pacific
mba_schools_in_asia_pacific__1_.docx
Unformatted Attachment Preview
Surname 1
Name
Course
Tutor
Date
MBA Schools in Asia-Pacific and the Case Study
1. What is the type of data (Quantitative or Qualitative) for each of the columns (variables) i
n the dataset? If quantitative, is the data discrete or continuous? Neatly summarize your r
esponse in a table for all the columns (variables).
Both quantitative and qualitative data is found within the given data. The variables that
fall under qualitative data are;
i.
GMAT
ii.
English test
iii.
Work experience
However, we have quantitative variables of which we find some variable that fall under
continuous data category and others that fall under the discrete data category as below;
iv.
Full time enrollment- discrete
v.
Student per category- discrete
vi.
Local tuition- continuous
vii.
Foreign tuition- continuous
viii.
Age- discrete
ix.
% foreign- continuous
x.
Starting salary-continuous
Surname 2
2. Using Excel, find the mean, median, standard deviation, minimum, maximum, and the thr
ee quartiles for each of the quantitative variables identified in part 1 above. Neatly summ
arize in a table on this document. Comment on what you observe.
Full-Time
Enrollment
Mean
Median
Standard
Deviation
Minimum
Maximum
Students
per Faculty
165.16
126
140.841
1
12
463
Mean
Median
Standard
Deviation
Minimum
Maximum
Age
Mean
Median
Standard
Deviation
Minimum
Maximum
8.48
7
5.05898
5
2
19
Mean
Median
Standard
Deviation
Minimum
Maximum
Foreign
Tuition ($)
12374.9
2
11513
7778.42
3
1000
33060
Mean
Median
Standard
Deviation
Minimum
Maximum
16581.8
17765
9134.84
6
1000
33060
Starting Salary
($)
%Foreign
28.36 Mean
29 Median
Standard
3.784618 Deviation
22 Minimum
37 Maximum
Full-Time
Enrollment
25th
Quartile
50th
Quartile
75th
Quartile
Local
Tuition ($)
28.08 Mean
27 Median
Standard
25.00862 Deviation
0 Minimum
90 Maximum
37292
41400
23459.25
7000
87000
Students Local Foreign
Starting
per
Tuition Tuition
Salary
Faculty
($)
($)
Age %Foreign
($)
44
5
6146
9000
25
6
16000
126
7
11513
17765
29
27
41400
240
13
17172
22500
30
43
52500
Surname 3
3. What are the minimum and maximum full-time enrollments? Which schools have the
minimum and maximum full-time enrollments?
Full-Time Enrollment
Minimum
Maximum
12
463
The school with the minimum full-time enrollment is Macquarie Graduate School of
Management (Sydney). However, Indian Institute of Management (Calcutta) has the
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?
The average number of students per faculty member is 8.48 ≅ 8. The number can be termed
to be relatively low. This means that prospective applicants who are interested in pursuing
an MBA in one of the leading international business schools will have very low chances
of being accepted.
5. What are the mean, median, and modal ages? What does this mean to prospective
applicants?
Age
Mean
Median
Mode
28.36
29
29
The above descriptive statistics indicate that most of those are applying for enrolled are
aged 29 years of age.
Surname 4
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.
The mean percentage of foreign students is 28.08%. The schools that have 1% and 0%
foreign students are
i.
0%
a. Indian Institute of Management (Ahmedabad)
b. Indian Institute of Management (Calcutta)
c. Jamnalal Bajaj Institute of Management Studies (Bombay)
ii.
1%
a. Indian Institute of Management (Bangalore)
The schools that have highest percentage of foreign students are; Asian Institute of
Management (Bangkok) with 90%, Australian National University (Canberra) with
80%, Asian Institute of Management (Manila) with 50% and International University
of Japan (Niigata) with 60%
7. What percentage of schools require the GMAT test?
The total number of school that require GMAT test are 14
ℎ ℎ ℎ =
14
∗ 100 = 56%
25
8. What percentage of schools require English tests such as Test of English as a Foreign
Language (TOEFL)?
The total number of schools require English tests are 8
ℎ ℎ ℎ =
8
∗ 100 = 32%
25
Surname 5
9. What percentage of schools require work experience? From this percentage, does this
appear to be a significant factor in gaining admissions?
The total number of schools require work experience are 19
ℎ =
19
∗ 100 = 76%
25
This percentage significantly appears to be a factor in gaining admission
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?
Starting Salary ($)
Mean
Median
Minimum
Maximum
37292
41400
7000
87000
The mean and median starting salaries are $37292 and $41400 respectively. The schools
that have the 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. 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?
The mean tuition for foreign students and for local students are $16581.8 and $12374.92
respectively. Yes there is a significant difference.
= $(16581.8 − 12374.92 )
= $4206.88
Surname 6
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?
Require work experience
No work experience
19
6
mean starting salary
41,305
24,583
From the above table, 19 schools require work experience while only 6 does not require
work experience. The mean starting salary for schools requiring work experience is
$41305 while the mean starting salary for schools requiring no work experience is
$24583.
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?
Require English tests
No English tests
8
17
mean starting salary
45,088
33,624
From the above table, 8 schools require English tests while only 17 does not require
English tests. The mean starting salary for schools requiring English tests is $45088
while the mean starting salary for schools requiring no English tests is $33624.
14. Does there appear to be a correlation between age and starting salaries? Comment on the
strength and the direction of the correlation.
Starting
Salary
($)
Starting Salary
($)
Age
1
0.577557
Age
1
There is a moderate positive correlation (0.5776) between age and starting salaries as
indicated above.
Surname 7
15. Comment on the skewness for the data on starting salaries:
1.
Plot a histogram and determine the skewness.
Histogram
9
8
7
Frequency
6
5
4
Frequency
3
2
1
0
7000 23000 39000 55000 71000 More
Bin
2.
Find the skewness coefficient.
The coefficient of skewness is;
Skewness
3.
0.222903
Find the mean, median, and mode for starting salaries and compare the three
measures to determine skewness.
Starting
Salary ($)
Mean
Median
Mode
37292
41400
7500
Surname 8
16. Finally, use Empirical Rule on the starting salaries and determine whether the salaries
follow the Empirical Rule.
Starting
Salary ($)
Mean
Standard
Deviation
37292
23459.25
± 1
37292 ± 23459.25
(13832.75, 60751.25)
68% of the data falls within 1 standard deviation
± 2
37292 ± 2(23459.25)
(−9626.5, 84210.5)
95% of the data falls within 2 standard deviation
± 2
37292 ± 3(23459.25)
(−33085.75, 107669.75)
99% of the data falls within 3 standard deviation
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades