business statisc

 

Anderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., Cochran, J. J., Fry, M. J., & Ohlmann. J. W. (2021).

Don't use plagiarized sources. Get Your Custom Essay on
business statisc
Just from $13/Page
Order Essay

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.

2

>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

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

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper