Description
Prepare a managerial report of no more than 1,050 words for your boss.
Use the following questions for guidelines and directions on what to include in the report:
- 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).
- 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 in this document. Comment on what you observe.
- What are the minimum and maximum full-time enrollments? Which schools have the minimum and maximum full-time enrollments?
- 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?
- What are the mean, median, and modal ages? What does this mean to prospective applicants?
- 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?
- How many schools require work experience and how many of them don't? What percentage of schools require work experience? What is the mean starting salary for schools requiring work experience? From this percentage, does this appear to be a significant factor in gaining admissions? What is the mean starting salary for schools requiring no work experience?
- Evaluate the skewness for the data on starting salaries:
- Plot a histogram and comment on the skewness.
- Find the skewness coefficient.
- Compare the mean, median, and mode for starting salaries to determine skewness.
- Determine whether the starting salaries follow the Empirical Rule.
Include a brief introduction and conclusion.
Format your paper consistent with APA formatting guidelines (see the master's level APA template and APA sample paper in the Resources).
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
check this
Running head: MBA SCHOOLS IN ASIA-PACIFIC
1
QNT 561 MBA Schools in Asia-Pacific
Instructor name
Submitted by
Date
MBA SCHOOLS IN ASIA-PACIFIC
2
Introduction
Considering the given scenario, the MBA Schools of Asia-Pacific are given like
Melbourne Business School, Indian Institute of Management, National University of
Singapore, University of Queensland, Asian Institute of Management, and so on. The analysis
of all these schools has to be done which includes identification of the type of data in the data
set, mean, median, standard deviation, schools having maximum and minimum full-time
enrollment, the average number of students per faculty members in the schools, main tuition
for foreign students and local students, skewness for the data on starting salary, comparison
of mean, median and mode of the starting salary,...