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 (PSORHH V-RE7LWOHHJ0DQDJHU$GPLQ2IILFHUHWF Years of work experience (PSORHH 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) ([SODLQZK3YHDUVRIVHUYLFHV′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 QDPHO3’LVDJUHH′IRUUDWLQJRIDQG31HXWUDO′IRUUDWLQJRIDQG3$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.
