Case Study MBA Schools In Asia-Pacific

/in /by

Purpose of Assignment 

The purpose of this assignment is to develop students’ analytical capabilities to evaluate, analyze, and apply descriptive statistics techniques to real-world datasets.

Assignment Steps 

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:
    1. Plot a histogram and determine the skewness.
    2. Find the skewness coefficient.
    3. Find the mean, median, and mode for starting salaries and compare the three measures to determine skewness.
  15. Finally, use Empirical Rule on the starting salaries and determine whether the salaries follow the Empirical Rule.

Format your assignment consistent with APA format. 

 

 

 

 

 

Grading Guide

 

Content Met Partially Met Not Met Comments:
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 below in a table for all the columns (variable).

o

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 it below in a table on this document. Comment on what you observe.

o

3.     What are the minimum and maximum full-time enrollments? Which schools have the minimum and maximum full-time enrollments?

o

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?

o

5.     What are the mean, median, and modal ages? What does this mean to prospective applicants?

o

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.

o

7.     What percentage of schools require the GMAT test?

o

8.     What percentage of schools require English tests such as Test of English as a Foreign Language (TOEFL)?

o

9.     What percentage of schools require work experience? From this percentage, does this appear to be a significant factor in gaining admissions?

o

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?

o

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?

o

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?

o

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?

o

14.  Comment on the skewness for the data on starting salaries.

a.     Plot a histogram and determine the skewness.

b.     Find the skewness coefficient.

c.     Find the mean, median, and mode for starting salaries and compare the three measures to determine skewness.

 

Finally, use Empirical Rule on the starting salaries and determine whether the salaries follow the Empirical Rule.

 

        
 

 

 

   Total Available Total Earned  
    3 #/3  

 

 

Writing Guidelines Met Partially Met Not Met Comments:
The paper—including tables and graphs, headings, title page, and reference page—is consistent with APA formatting guidelines and meets course-level requirements.        
Intellectual property is recognized with in-text citations and a reference page.        
Paragraph and sentence transitions are present, logical, and maintain the flow throughout the paper.        
Sentences are complete, clear, and concise.        
Rules of grammar and usage are followed including spelling and punctuation.        
    Total Available Total Earned  
    2 #/2  

Briefly describe the company and its product and the ethical dilemma associated with the production and distribution of its products.

/in /by

Establishing a culture of sound business ethics within an organization is challenging, to say the least. Companies that market products which are not considered to be “healthy” for consumers have additional challenges. Using the CSU Online Library, research a company that markets “unhealthy” products. Examples might include tobacco or alcohol companies, but these examples are not exclusive. Respond to the following questions.

 

1. Briefly describe the company and its product and the ethical dilemma associated with the production and distribution of its products.

2. Examine how the perception of the product differs within cultures—both within the United States and globally.

3. How has this company handled the ethical implications of its product with a focus on social responsibility, integrity, and business ethics?

4. Explain how leadership within the organization can instill a culture of ethics within the marketing department as they strive to advertise a product that is not healthy for the customer.

 

Your response must be a minimum of two double-spaced pages, not including the title and reference pages. You are required to use at least one peer-reviewed source. Referenced sources must have accompanying citations, complying with APA guidelines.

 

Information about accessing the Grading Rubric for this assignment is provided below

Compare your summary results from #1 and #2. Discuss any specific statistical results that would help a real estate agent understand the condominium market.

/in /by

ulf Real Estate Properties, Inc. is a real estate firm located in southwest Florida. The company, which advertises itself as an “expert in the real estate market,” monitors condominium sales by collecting data on location, list price, sale price, and the number of days it takes to sell each unit. Each condominium is classified as Gulf View if it is located directly on the Gulf of Mexico, or No Gulf View if it is located on the bay or a golf course (near but not on the Gulf). Sample data from the Multiple Listing Service in Naples, Florida, provided sales data for 40 Gulf View condominiums and 18 No Gulf View condominiums. The complete data set is in the file named Real Estate, linked at the bottom of the page.

Managerial Report
Prepare a report (see below) that summarizes your assessment of the nature of the housing market in southwest Florida. Be sure to include the following seven (7) items in your report.

1.      Descriptive statistics (mean, median, range, and standard deviation) to summarize each of the three variables for the 40 Gulf View condominiums. Are there any outliers in the data set for any of the three variables? If there are any outliers in any category, please list them and state for which category they are an outlier. Describe which method you used to make your determination.

2.      Descriptive statistics (mean, median, range, and standard deviation) to summarize each of the three variables for the 18 No Gulf View condominiums. Are there any outliers in the data set for any of the three variables? If there are any outliers in any category, please list them and state for which category they are an outlier. Describe which method you used to make your determination.

3.      Compare your summary results from #1 and #2. Discuss any specific statistical results that would help a real estate agent understand the condominium market.

4.      Develop a 95% confidence interval estimate of the population mean sales price and population mean number of days to sell for Gulf View condominiums. Interpret your results.

5.      Develop a 95% confidence interval estimate of the population mean sales price and population mean number of days to sell for No Gulf View condominiums. Interpret your results.

6.      Assume the branch manager requested estimates of the mean selling price of Gulf View condominiums with a margin of error of $40,000 and the mean selling price of No Gulf View condominiums with a margin of error of $15,000. Using 95% confidence, how large should the sample sizes be for each?

7.      Gulf Real Estate Properties just signed contracts for two new  listings: a Gulf View condominium with a list price of $589,000 and a No  Gulf View condominium with a list price of $285,000. What is your  estimate of the final selling price (based on the percent difference for  the sale and list price) and number of days required to sell each of  these units

Your report must contain the following:

·         A title page in APA style.

·         An introduction that summarizes the problem.

·         The body of the paper should answer the questions posed in the problem by communicating the results of your analysis. Include results of calculations, as well as charts and graphs, where appropriate.

·         A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis.

 Submit your Excel file in addition to your report.

Philosophy Essay

/in /by

On January 1, 2014, Brittany Maynard, of Anaheim, California, was diagnosed with brain cancer. By April, she was given just six months to live. Brittany wanted to have the option of ending her own life with the help of her doctor before the cancer became unbearable, so she moved to Oregon to take advantage of the state’s ‘Death with Dignity’ law. On November 1, 2014, surrounded by family members, Brittany ended her own life by ingesting drugs prescribed by her doctor.

 

Oregon is currently one of five states in which physician-assisted suicide is legal. In June 2016, California became the fifth state to legalize physician-assisted suicide.

 

 

Please write an essay on the following topics…

 

 

Do you morally approve or disapprove of California’s decision to legalize physician-assisted suicide?

 

 

Your paper should carefully address the following questions:

 

1. What is physician-assisted suicide, and how does it differ from active and passive euthanasia?

2. Using his article “The Wrongfulness of Euthanasia,” would J. Gay-Williams approve of California’s decision to legalize physician-assisted suicide? (Why/why not?)

3. Using his article “Active and Passive Euthanasia,” would James Rachels approve of California’s decision to legalize physician-assisted suicide? (Why/why not?)

4. Do you approve of California’s decision to legalize physician-assisted suicide? (Why/why not?)

 

 

 

**Your paper should be 4 typed, double-spaced pages and is due by 6:00 P.M. on Sunday, July 30th pacific time. Please upload your essay to Turnitin (on Blackboard). Late essays will be penalized 2 letter grades for each day late (e.g., A → C, B- → D-, etc.).