代做QTS0109 BUSINESS STATISTICS CONTINUOUS ASSESSMENT 1

2024.04.22 - 首页 >> Java编程

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 due date, students’ submissions will not be entertained.

Students should a keep a copy of assignment submitted. All workings must be shown. The submitted report must show evidence that this is students’ own 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: 24 Apr 2024 (Wed), 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_si[email protected] or call 6248 9393. For non-Canvas issues please email students@ @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 through instructions first. Please take time read through before raising issues.

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

Answer ALL questions in Sections A and B

Submit an Excel answer file in Canvas:

(1) Use Section A sheet in the Excel data template provided in Canvas to answer questions from Section A.

(2) Use Section B sheet in the Excel data template provided in Canvas to answer questions from 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, Quantitative (Discrete) or Quantitative Continuous)]

Variable	Variable Type
Mr Yip’sjob title
Number of contract staffat AK Co.
Years of work experience
Estimated annual sales growth (%) for XYZ Co.

(8 marks)

(2) For each of the following variables, state the Level of Measurement (Nominal, Ordinal or Ratio).

Variable	Level of Measurement
Employee classification (e.g. Marketing, Research, Finance etc)
Number of female Board members
Employee’s evaluation score on a scale of 1 to 5 (1= Excellent to 5= Poor)
Monthly Salary ($)
Age group (1= Below 35 years; 2 = 35 to 60 years; 3 = Over 60 years)

(5 marks)

(3) TopNex Property Agency has 300 customers who purchased new private condominium units in a property launch last month. 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 maybe selected.

(b) Describe how a stratified sample maybe selected.

[Use your own words. Do not copy from any sources] (8 marks)

(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 16% to 25% in the next five years.

(b) The median age of teachers in secondary schools is estimated to increase by five years to 41 years in the next three years.

(c) In a survey of fifty persons who have just turned 63, 25% said that they would like to work until they are 70. (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 is the main type of research bias that can occur here? 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 IT graduates who entered the job market five years ago were randomly selected for a survey about their job progression.

(b) The results of all 300 candidates who sat for the 2023 Investment Analysis Examination were analysed. (4 marks)

(7) All candidates who applied for financial advisor posts in a bank were required to sit 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 financial advisors? (2 marks)

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

(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] (2 marks)

(e) A minimum score of 68 is required before a job candidate is invited to attend a personal interview. What percent of applicants did not qualify for the interview? (2 marks)

Section B (50 marks)

You are the Chief Statistician of a research firm. Your client is a large public accounting firm. Its audit division has a few teams in the organization. Employee turnover rate was high and your firm has been commissioned to carry out an independent Employee Satisfaction survey of staff in the audit division.

The Consultant has decided to do a preliminary study by surveying a sample of 52 audit staff. This was done by randomly selecting employees from the various teams 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:

The detailed data collected from 52 respondents are shown in Appendix 1 (Page 8).

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

(8a) 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		52

What percentage of staff has worked in the organization for less than 5 years? (6 marks)

(8b) Based on the results from Part (8a), create a histogram for variable Q3 (Years of

Service). Label all axes clearly. (4 marks)

(9) Calculate the following statistics for Q3 (Years of service) for the two types of

employment status (variable Q4). Tabulate your statistics as follows:

Employment status	Mean	Median	Standard Deviation
Permanent staff
Contract staff

Discuss your results. (10 marks)

(10) You would like to look at the relationship between years of service for some permanent

establishment staff 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)

(a) Input above data in an excel worksheet. (2 marks)

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

(11) Given the following frequency distribution of salaries for a sample of 30 employees.

*Annual* *Salary* *($000)*		No of *Employees*
40	up to 60	12
60	up to 80	9
80	up to 100	4
100	up to 120	5
Total		30

Calculate the grouped mean and grouped sample standard deviation. (Format final answers to 2 dec places) (4 marks)

(12) Create a contingency table with Q2 (Remain with company) as the Row variable and

Q1 (Recommend organization) as the column variable. Label clearly and comment on the results. (6 marks)

(13) Create a pie chart for the variable Q5e (Good work-life balance) with 3 categories

namely “Disagree” (for rating of 1 and 2), “Neutral” (for rating of 3) and “Agree” (for rating of 4 and 5) . Label your chart clearly. (4 marks)

(14) Summary (maximum: 150 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 Q5for other suitable variables] (8 marks)