(240)-343-2585

 

Anderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., Cochran, J. J., Fry, M. J., & Ohlmann. J. W. (2021). Essentials of modern business statistics with Microsoft® Excel® (8th ed.). Cengage Learning

  • Chapter 1: Data and Statistics
  • Chapter 2: Descriptive Statistics: Tabular and Graphical Displays
  • Chapter 3: Descriptive Statistics: Numerical Measures
  • The full-text version of this ebook is available in your online classroom through Cengage’s MindTap platform. In MindTap, click on the Getting Ready link to access the assigned chapters for the week. This book is a comprehensive text on statistics and how to collect, analyze, and interpret data. Chapter 1 discusses types of data used in statistical analysis, including how the data is obtained and converted into meaningful information. Chapter 2 discusses tabular and graphical displays, and how they are constructed and interpreted. Chapter 3 discusses numerical measures to summarize data in terms of numerical values. These chapters will assist you in your Descriptive Statistics: Case Problem Business Schools of Asia-Pacific discussion forum and Week 1: MindTap Descriptive Statistics assignment this week.

Prior to beginning work on this discussion forum, watch the 

Week 1 Introduction

 (Links to an external site.)
 video, and read Chapters 1, 2, and 3 in the MindTap ebook by clicking on the Getting Ready link for each chapter. You can access the MindTap ebook, 

Essentials of Modern Business Statistics with Microsoft® Excel®

, in your online classroom.

Step 1: Read:

· Review 
Case Problem 3: Business Schools of Asia-Pacific


 
 Download Case Problem 3: Business Schools of Asia-Pacific
from Chapter 3 in the ebook.

Step 2: Do:

· Run descriptive statistics for the Data File AsiaMBA (Chapter 3) using the video 

How 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.

Data

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
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
Chinese University of Hong Kong 90 5 11,140 11,140 29 10 Yes No No 31,000
International University of Japan (Niigata) 126 4 33,060 33,060 28 60 Yes Yes No 87,000
Asian Institute of Management (Manila) 389 5 7,562 9,000 25 50 Yes No Yes 22,800
Indian Institute of Management (Bangalore) 380 5 3,935 16,000 23 1 Yes No No 7,500
National University of Singapore 147 6 6,146 7,170 29 51 Yes Yes Yes 43,300
Indian Institute of Management (Calcutta) 463 8 2,880 16,000 23 0 No No No 7,400
Australian National University (Canberra) 42 2 20,300 20,300 30 80 Yes Yes Yes 46,600
Nanyang Technological University (Singapore) 50 5 8,500 8,500 32 20 Yes No Yes 49,300
University of Queensland (Brisbane) 138 17 16,000 22,800 32 26 No No Yes 49,600
Hong Kong University of Science and Technology 60 2 11,513 11,513 26 37 Yes No Yes 34,000
Macquarie Graduate School of Management (Sydney) 12 8 17,172 19,778 34 27 No No Yes 60,100
Chulalongkorn University (Bangkok) 200 7 17,355 17,355 25 6 Yes No Yes 17,600
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
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
Royal Melbourne Institute of Technology 30 7 13,880 17,765 32 30 No Yes Yes 48,900
Jamnalal Bajaj Institute of Management Studies (Bombay) 240 9 1,000 1,000 24 0 No No Yes 7,000
Curtin Institute of Technology (Perth) 98 15 9,475 19,097 29 43 Yes No Yes 55,000
Lahore University of Management Sciences 70 14 11,250 26,300 23 2.5 No No No 7,500
Universiti Sains Malaysia (Penang) 30 5 2,260 2,260 32 15 No Yes Yes 16,000
De La Salle University (Manila) 44 17 3,300 3,600 28 3.5 Yes No Yes 13,100

Sheet2

Sheet3