STATS1900 Business StatisticsMajor AssignmentSemester 2, 2012Date Due: Refer to Unit DescriptionTotal Marks: 40 marks Worth: 20% of final assessmentThis assignment requires an amount of computer work and written comment. You may need to seek guidance from your tutor along the way. Do not leave things until too late!! Each question carefully describes what you are required to do so please follow these carefully!In this assignment you will examine quarterly accident data obtained from a large company that employs up to 18000 people. Document Preview: STATS1900 Business StatisticsMajor AssignmentSemester 2, 2012Date Due: Refer to Unit DescriptionTotal Marks: 40 marks Worth: 20% of final assessmentThis assignment requires an amount of computer work and written comment. You may need to seek guidance from your tutor along the way. Do not leave things until too late!! Each question carefully describes what you are required to do so please follow these carefully!In this assignment you will examine quarterly accident data obtained from a large company that employs up to 18000 people. Each accident costs the company time and money, and the worker usually has considerable pain and suffering. This company has introduced new work procedures in the hope that the numbers of accidents can be reduced and that their safety performance might be improved. The data is contained in the file Accident Data.xls and contains the following columns (variables):Variable Description ID Identification number from original file Qtr Quarter Accidents Number of accidents Est-EFT Estimated number of Full Time Employees #/1000 Number of accidents per 1000 Full Time Employees WDL/Qtr Number of Working Days Lost per Quarter WDL/1000EFT Number of Working Days Lost per 1000 Full Time Employees Random Sample: Before you begin your analysis you are required to take a random sample of size 24 from the 38 cases in the file. Use the file Sample-Generator-102.xls to do this. Your tutor will show you how this can be done in EXCEL. Your answers to the assignment tasks below are to be based on your sample of 24 cases. Make sure to keep a safe copy of your sample since you cannot use Sample-Generator-102 to reproduce the first sample. To prepare your data file ready for analysis you must follow the following steps:Use the Sample-Generator-102 file to generate a random sample of 24 from the file Accident Data.xls.After you have generated your sample you need to sort your data by the column headed ID remember to highlight all of Attachments: STATS1900-Maj.doc Sample-Genera.xls EDAStats.xls Accident-Data.xls