DMS/DAC/DIB/DBF Apr - Jun 2022

SIM Global Education© Apr 2022 Page 1

QTS0109 BUSINESS STATISTICS
CONTINUOUS ASSESSMENT 1
INDIVIDUAL ASSIGNMENT 100 marks (30%)
Read the instructions in your course documents, in your student portal, Course Outline, CA outline
and Canvas portal carefully. You will be penalized with marks deduction if the instructions are not
strictly followed. If you have queries, read the Canvas Help and then email queries via your student
portal.
Students are to upload their assignment by the due date to through their student portal account. After
the ĚƵĞĚĂƚĞ͕ƐƚƵĚĞŶƚƐ͛ƐƵďŵŝƐƐŝŽŶƐǁŝůůŶŽƚďĞĞŶƚĞƌƚĂŝŶĞĚ͘
Students should a keep a copy of assignment submitted. All workings must be shown. The submitted
ƌĞƉŽƌƚŵƵƐƚƐŚŽǁĞǀŝĚĞŶĐĞƚŚĂƚƚŚŝƐŝƐƐƚƵĚĞŶƚƐ͛ŽǁŶ work.
Write your FULL Name AND your student ID as in the register on the answer script.
Please be reminded that plagiarism and collusion is a serious offence, and all cases will be referred to
the administration. Grades will be withheld if the submission is suspected for plagiarism or collusion
till investigations are completed.
Due date: 22 Apr 2022 (Fri), 11.59 am
Penalty Marks for Late Submission of Assignment
Within 24 hours: 20% to be deducted from total marks
More than 24 hours: submission will be graded zero
CA Submission
CAs must be submitted online via student portal. Please read through instructions in your student
portal, CA outline and your Canvas carefully before submitting. If you have further queries, please
read the Canvas Help. If after you have read the Canvas Help, you need assistance on Canvas
submission, please email to itsd_simge@sim.edu.sg or call 6248 9393. For non-Canvas issues please
email he10@sim.edu.sg or he5@sim.edu.sg. Please email with your student portal accounts. Email
from other addresses will not be entertained. If issues raised are covered, you will be directed to read
these instructions first. Please take time read through before raising issues.


DMS/DAC/DIB/DBF Apr - Jun 2022

SIM Global Education© Apr 2022 Page 2

CONTINUOUS ASSESSMENT 1 [Total marks: 100 marks (30%)]

Answer ALL questions in Sections A and B

Submit two documents in Canvas:

(1) A MS Word document (use the template provided in Canvas) answering Section A.
(Save your Word file using the prescribed format QTS0109yourname e.g. QTS0109johntan.doc)

(2) An Excel file answering Section B.
(Save your Excel file using the prescribed format QTS0109yourname e.g. QTS0109johntan.xls)


Section A (50 marks)

(1) For each variable listed below, state the variable type [Qualitative or Quantitative
(please state Discrete or Continuous)]

Variable Variable Type
0U7D\¶VMREWLWOH
Years of work experience
Number of temporary staff at ABC Co.
Annual staff resignation rate (%)
(8 marks)

(2) For each of the following variables, state the Level of Measurement (Nominal, Ordinal
or Ratio).
Variable Level of Measurement
(PSOR\HH¶V-RE7LWOHHJ0DQDJHU$GPLQ2IILFHUHWF
Years of work experience
(PSOR\HH¶VHYDOXDWLRQVFRUH on a scale of 1 to 5
(1= Excellent to 5= Poor)

Monthly Salary ($)
Age group (1= Below 30 years; 2 = 30 to 55 years; 3 =
Over 55 years)

(5 marks)
(3) Tiptop Property Inc is a property agency. It has 300 customers who purchased private
properties through the agency last year. The agency decides to take a sample of 50
customers to assess their satisfaction with the services provided by their property
agents. The company has information about the customers Age, Gender and Amount
paid for the property.

(a) Describe how a simple random sample may be selected.

(b) Describe how a stratified sample may be selected.
[Use your own words. Do not copy from any sources]
(8 marks)

DMS/DAC/DIB/DBF Apr - Jun 2022

SIM Global Education© Apr 2022 Page 3

(4) State and briefly explain whether the statements below refer to descriptive or inferential
statistics.

(a) The proportion of companies with three or more women in corporate board
rooms is expected to grow from the current 15% to 22% in the next five years.

(b) The median age of employees in the services sector is estimated to increase by
three years to 39 years in the next two years.

(c) In a survey of twenty persons who have just turned 62, 50% said that they
would like to work until they are 67.
(9 marks)

(5) A company carried out an employee satisfaction survey in view of the recent high
resignation rate in the company. Many employees have concerns over the
confidentiality of the information that they provide in the survey and decided not to
provide any negative feedback. What type of research bias might this result in? Explain
the bias stated.
(4 marks)
(6) For each of the following situations stated below identify which refers to a population
and which refers to a sample.

(a) 50 business graduates who entered the job market five years ago were randomly
selected for a survey about their job progression.

(b) The results of all 500 candidates who sat for the 2021 Real Estate Salesperson
Examination were analysed.
(4 marks)

(7) All candidates who applied for management trainee posts in a company were required
to sit for an aptitude test. The scores of these applicants are shown in the stem and leaf
diagram below:

(a) How many candidates applied for the post of management trainees?

(b) State lowest and highest score obtained for the aptitude test.

DMS/DAC/DIB/DBF Apr - Jun 2022

SIM Global Education© Apr 2022 Page 4


(c) What is the median score?

(d) Looking at the diagram, would you expect the mean score to be higher than the
median score? Explain. [Note: you do not need to compute the mean]

(e) A minimum score of 65 is required before a job candidate is called to attend a
personal interview. What percent of applicants will qualify for the interview?
(12 marks)

Section B (50 marks)

You are the chief research analyst to the Consultant of a management-consulting firm. Your
client is a large public accounting. Its audit division has 5 teams in the organization. Employee
turnover rate was high and your firm has been commissioned to carry out an independent
Employee Satisfaction survey of its staff in this division.

The Consultant has decided to do a preliminary study by surveying a sample of 50 audit staff.
This was done by randomly selecting 10 employees from each Team and getting the responses
via an online questionnaire which all selected employees have to respond.

The questionnaire used to collect the data is shown below:

Survey of Audit Officers (selected items)
Q1. Would you recommend this organization as a good place to work? M Yes N No
Q2. How likely are you to remain in this organisation in the next two years? M Likely N Unlikely
Q3. Approximately how many years have you worked with the organization (e.g. 2.5 years)? ______ years

Q4. Employment status: M Permanent staff N Contract staff

Please select your level of agreement for the following statements [5=Strongly Agree (SA), 4= Agree (A),
3=Neutral(N), 2= Disagree (D), 1= Strongly Disagree(SD)]:


The detailed data collected from 50 respondents are shown in Appendix 1 (Page 6).

SD D N A SA
Q5a On my job, I am given clearly defined quality goals. 1 2 3 4 5
Q5b The organisation does an excellent job of keeping
employees informed about developments and changes.
1 2 3 4 5
Q5c I am given recognition for my achievement and efforts. 1 2 3 4 5
Q5d I am happy with opportunities for personal and
professional growth in the organisation.
1 2 3 4 5
Q5e There is good work-life balance in the organisation. 1 2 3 4 5
Q5f Distribution of tasks across individuals/teams is fair. 1 2 3 4 5
DMS/DAC/DIB/DBF Apr - Jun 2022

SIM Global Education© Apr 2022 Page 5

Using EXCEL, carry out relevant analyses to answer the following questions:

(1) Create a frequency distribution for the variable Q3 (Years of Service) as follows:
Years of Service Frequency Relative frequency
0 up to 5
5 up to 10
10 up to 15
15 up to 20
20 up to 25
Total 50
What percentage of staff has worked in the organization for less than 5 years?
(5 marks)

(2) Based on the results from Part(1), create a histogram for variable Q3 (Years of Service).
Label all axes clearly.
(4 marks)

(3) Calculate the following statistics for Q3 (Years of service) for the two types of
employment status. Tabulate your statistics as follows:
Employment status Mean Median Maximum Standard Deviation
Permanent staff
Contract staff
Discuss your results.
(12 marks)

(4) You would like to look at the relationship between years of service for some permanent
status employees and their gross annual salaries. The following data were collected:
Years of
service
8.0 7.0 7.5 8.0 9.0 12.0 10.0 8.5 19.0 13.0 8.0 4.0 13.0 16.0
Gross annual
salary ($000)
65 58 60 56 78 80 55 73 75 76 80 38 82 62

(a) Input above data in an excel worksheet.

(b) Construct a scatter diagram using Years of Service on the horizontal axis and Gross
Annual Salary on the vertical axis. Explain the direction of relationship.

(c) ([SODLQZK\³YHDUVRIVHUYLFHV´LVSORWWHGRQWKHhorizontal axis.
(10 marks)

(5) Create a contingency table with Q2 (Remain with company) as the Row variable and
Q1 (Recommend organization) as the column variable. Comment on the results.
(5 marks)

(6) Create a pie chart for the variable Q5e (Good work-life balance) with 3 categories
QDPHO\³'LVDJUHH´IRUUDWLQJRIDQG³1HXWUDO´IRUUDWLQJRIDQG³$JUHH´IRU
rating of 4 and 5) . Label your chart clearly. (4 marks)

(7) Summary (maximum: 200 words):
Using appropriate excel analysis, discuss the overall satisfaction of employees in this
Division suggesting areas that the organisation may wish to address. [Hint: You may
wish to analyse Q5a to Q5f or other suitable variables]
DMS/DAC/DIB/DBF Apr - Jun 2022

SIM Global Education© Apr 2022 Page 6

(10 marks)
APPENDIX 1
s/no Q1 Q2 Q3 Q4 Q5a Q5b Q5c Q5d Q5e Q5f
1 1 2 4.5 1 5 4 4 4 1 1
2 2 1 8.0 1 4 3 4 3 3 1
3 1 1 7.0 1 5 5 4 5 1 1
4 2 1 7.5 1 4 4 3 1 4 3
5 1 1 8.0 1 5 5 3 1 2 2
6 2 1 9.0 1 5 3 3 3 1 3
7 1 1 12.0 1 4 3 3 3 3 4
8 2 1 10.0 1 5 3 3 3 4 3
9 1 1 8.5 1 1 3 3 5 1 1
10 1 1 19.0 1 1 5 3 1 2 2
11 2 1 13.0 1 4 2 3 2 4 2
12 2 1 8.0 1 4 2 3 2 3 3
13 1 1 4.0 1 4 5 3 5 2 1
14 1 1 13.0 1 3 2 3 2 5 3
15 2 1 4.0 1 5 4 3 3 2 3
16 2 2 16.0 1 3 2 3 1 3 1
17 1 1 1.5 1 5 5 3 5 2 1
18 2 2 18.0 1 4 2 3 3 1 2
19 1 1 21.0 1 3 3 3 3 2 2
20 2 1 4.5 1 4 3 4 4 4 2
21 2 1 4.0 1 4 3 3 5 3 4
22 2 1 4.5 1 3 1 3 3 3 3
23 1 1 7.0 1 4 2 3 4 2 2
24 2 2 8.5 1 4 4 4 1 3 4
25 2 1 9.0 1 4 4 4 1 3 2
26 2 2 4.5 1 3 1 3 2 2 3
27 1 1 2.0 1 4 3 3 5 3 2
28 2 1 2.0 1 5 3 3 5 2 1
29 1 1 9.0 1 4 4 4 2 2 4
30 2 2 22.0 1 3 1 3 1 3 5
31 1 1 18.0 1 4 3 3 3 3 3
32 1 1 4.0 1 4 2 3 3 2 2
33 1 2 16.0 1 5 2 3 4 3 2
34 1 1 1.0 1 2 4 4 5 3 2
35 2 2 18.0 1 3 1 3 2 4 2
36 1 1 21.0 1 5 2 3 5 3 2
37 2 2 5.0 1 4 3 3 5 2 2
38 1 1 4.0 1 2 4 4 4 2 3
39 1 2 5.0 1 4 1 3 3 3 4
40 2 1 4.0 1 3 2 3 2 3 3
DMS/DAC/DIB/DBF Apr - Jun 2022

SIM Global Education© Apr 2022 Page 7

41 1 1 9.0 2 4 4 4 2 4 3
42 1 1 7.0 2 5 1 2 1 2 4
43 1 1 8.0 2 5 3 2 5 3 3
44 2 1 8.0 2 3 3 4 1 4 3
45 1 2 11.0 2 3 2 5 2 3 1
46 1 1 2.0 2 3 3 3 1 2 3
47 1 1 8.0 2 4 3 3 4 5 3
48 1 1 3.0 2 4 3 3 5 2 4
49 1 1 13.0 2 3 1 3 3 2 2
50 1 1 4.0 2 4 2 3 4 3 4


Note: Please retrieve a copy of this Excel datafile from Canvas for your Section B analysis. You are
NOT required to do input of above data into Excel.