BUSINESS STATISTICS - MCD2080
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
BUSINESS STATISTICS - MCD2080
Trimester One 2022 Sample Exam
Data Used
Question 1 & 2
Here we look at some analysis on a Computer Technology Company (TechCom) employee and their experience, education and their annual salary. In addition, the company examines various departments and their relationship with the employee profiles. The data is based on the records from 2003 to 2010.
Question 3
The data in the file “US Income.xlsx” captures the US annual income. We want to find how
individuals’ income is distributed between a few characteristics.
Question 4
The Data is about a direct marketer of electronic equipment and wants to investigate the efficacy in their company named HyTex. HyTex sent catalogues to the customers and the question might be that, if it is sending the catalogues to the right customers and if not, to whom should it send the catalogues to. The file “Catalogue Marketing.xlsx” contains customer demographic attributes including the Marital Status of the customer and the Region they live in.
Question 5
The Data is about Australian production of electricity from Quarter 1 2010 to Quarter 3 2018. The data contains quarterly electricity production in million KWH (m.KWH).
Use the data to answer the following questions.
Question 1 [2 + 2 + 2 + 4 + 1 + 1 + 3 + 1 + 1 + 5 = 22 marks]
a) Shown below is the table illustrating the number of employees from two different
depart5ments: Production and Engineering (P&E) and Purchasing by gender and the
educational attainment (in years).
Use Exhibit 1 below to answer the following questions.
Exhibit 1 |
||||||||
|
|
|
|
|
||||
Count of Employee |
Gender |
Count of Employee |
Gender |
|||||
Education |
Female |
Male |
Grand Total |
Education |
Female |
Male |
Grand Total |
|
0 |
4 |
1 |
5 |
0 |
2 |
|
2 |
|
2 |
3 |
1 |
4 |
2 |
4 |
4 |
8 |
|
4 |
27 |
22 |
49 |
4 |
20 |
14 |
34 |
|
6 |
8 |
9 |
17 |
6 |
10 |
8 |
18 |
|
8 |
1 |
2 |
3 |
8 |
4 |
1 |
5 |
|
Grand Total |
43 |
35 |
78 |
Grand Total |
40 |
27 |
67 |
Using the two pivot tables in Exhibit 1,
(i) Calculate the proportion of the female and the proportion of the male employees from the P&E department. Show all workings to 4 decimal places.
(ii) Similarly, calculate the proportion of the female and male employees from the Purchasing
department. Show all workings to 4 decimal places.
(iii) From part (i) and (ii), compare the percentage of the employees from the two departments.
b) Next, we want to examine the variable of employee’s experience and the distribution of employees. Pivot tables (Exhibit 2) below show the employee experience from P&E and Purchasing departments.
Exhibit 2 |
||||||||
Department |
Production and Engineering |
|
Department |
Purchasing |
||||
|
|
|
|
|||||
Prior Experience (years) |
Female |
Male |
Grand Total |
Prior Experience (years) |
Female |
Male |
Grand Total |
|
0-4 |
21.79% |
15.38% |
37. 18% |
0-4 |
25.37% |
17.91% |
43.28% |
|
5-9 |
21.79% |
7.69% |
29.49% |
|
5-9 |
14.93% |
10.45% |
25.37% |
10- 14 |
11.54% |
17.95% |
29.49% |
|
10- 14 |
14.93% |
11.94% |
26.87% |
15-20 |
0.00% |
3.85% |
3.85% |
|
15-20 |
4.48% |
0.00% |
4.48% |
Grand Total |
55. 13% |
44.87% |
100.00% |
|
Grand Total |
59.70% |
40.30% |
100.00% |
Based on the above reported probabilities, discuss how the employees prior experience affects
the distribution of the employees as their experience increases. Give examples.
c) The pivot table below (Exhibit 3) gives the employee’s prior experience by employees’ gender for all company’s departments.
Exhibit 3: % of Grand Total |
|||
|
|
||
Count of Employee |
Gender |
||
Prior Experience (years) |
Female |
Male |
Grand Total |
0-4 |
23.04% |
15.69% |
38.73% |
5-9 |
18. 14% |
9.80% |
27.94% |
10- 14 |
13.73% |
14.22% |
27.94% |
15-20 |
3.43% |
1.96% |
5.39% |
Grand Total |
58.33% |
41.67% |
100.00% |
2022-05-23