Statistic

Statistic mid term assignment

Part 1 (20 marks)

1. Which variables in the survey are categorical, numerical (discrete or continuous)?

Categorical: gender, major, employment status,

numerical discrete: age, number of jobs, expected salary, anticipated salary in 5 year, spending

numerical continuous: height, graduate GPA, under grated specialization, GMAT, satisfaction advise employment

2. How or in what format should categorical and numerical data be respectively organised and presented? (hint: please illustrate the presentation of data)

the presentation of data is pivot table of version contingency table for bond data

it is easy to convert to overall percentage table, add variables to existing table, change statistic display, compute and display other descriptive statistics and drill down to any cell in a pivot table.

Part 2 (20 marks)

1. Compute the mean, median, first quartile, third quartile, range, inter-quartile range for

“Age”.

22, 23, 24, 24, 25.25,25, 25, 25, 26, 26,26, 27, 27, 27, 28,28, 28, 29.29, 30,30,30, 30, 31,31, 31, 32, 32, 32, 33, 33, 34,35, 35,36, 37. 38, 39, 41

Mean= 29,725

Median= (40 +1)/2= 25, 5= 31

Q1= (40+1)/4= 10, 25

Q3= 3(40+1)/4= 30, 75

Range= 41-22= 19

Inter –quartile range = 33- 26= 7

2. Construct a box plot and determine whether the data is skewed, if so, how?

22 26 31 33 41

X smallest Q1 Median Q3 X largest

Inter-quartile range= 33-26= 7

Mean < Median => left skewed

Part 3 (28 Marks)

1. Construct a contingency table for

a. gender and graduate major,

b. gender and undergraduate major,

c. gender and employment status,

d. graduate major and undergraduate major and

e. graduate major and employment status