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
0
, 0
, 0
0
Yes ,400
8
4 ,993
,582
Yes No Yes 0
5 0
4, 22 0 No No No 0
5 0
11,140 29 10 Yes No No 4 33,060 28 60 Yes Yes No 5 Yes No Yes 0
5 1 Yes No No 6 0
29 Yes Yes Yes ,300
8 16,000 23 0 No No No 42 2 20,300 30 80 Yes Yes Yes 50 5 8,500 32 20 Yes No Yes 8
17 16,000 32 26 No No Yes 60 2 11,513 26 Yes No Yes ,000
8 34 No No Yes 7 17,355 25 6 Yes No Yes 13 30 30 Yes Yes Yes 300 10 18,200 29 90 No Yes Yes 20 19 30 10 No No Yes 30 37 35 No Yes Yes 30 7 32 30 No Yes Yes 0
9 1,000 1,000 24 0 No No Yes 7,000 15 29 43 Yes No Yes 14 23 No No No 7,500 30 5 2,260 32 15 No Yes Yes 16,000 17 28 Yes No Yes 2
Business School
Full-Time Enrollment
Students per Faculty
Local Tuition ($)
Foreign Tuitiion ($)
Age
%Foreign
GMAT
English Test
Work Experience
Starting Salary ($)
Melbourne Business School
2
0
5
2
4
42
2
9
6
2
8
4
7
Yes
No
7
1
University of New South Wales (Sydney)
22
19
32
29
28
65,
20
Indian Institute of Management (Ahmedabad)
392
4,
30
300
7,
10
Chinese University of Hong Kong
90
11,
14
3
1,000
International University of Japan (Niigata)
1
26
33,0
60
8
7,000
Asian Institute of Management (Manila)
389
7,562
9,000
25
50
22,
80
Indian Institute of Management (Bangalore)
380
3,9
35
16,000
23
7,500
National University of Singapore
147
6,146
7,
17
51
43
Indian Institute of Management (Calcutta)
463
2,880
7,400
Australian National University (Canberra)
20,300
46,600
Nanyang Technological University (Singapore)
8,500
49,300
University of Queensland (Brisbane)
13
22,800
49,600
Hong Kong University of Science and Technology
11,513
37
34
Macquarie Graduate School of Management (Sydney)
12
17,172
19,778
27
60,100
Chulalongkorn University (Bangkok)
200
17,355
17,600
Monash Mt. Eliza Business School (Melbourne)
350
16,200
22,500
52,500
Asian Institute of Management (Bangkok)
18,200
25,000
University of Adelaide
16,426
23,100
66,000
Massey University (Palmerston North, New Zealand)
15
13,106
21,625
41,400
Royal Melbourne Institute of Technology
13,880
17,765
48,900
Jamnalal Bajaj Institute of Management Studies (Bombay)
24
Curtin Institute of Technology (Perth)
98
9,475
19,097
55,000
Lahore University of Management Sciences
70
11,250
26,300
2.5
Universiti Sains Malaysia (Penang)
2,260
De La Salle University (Manila)
44
3,300
3,600
3.5
13,100
Sheet2
Sheet3