Paper, Order, or Assignment Requirements
STATS1900 Business Statistics
Major Assignment
27/2014
Date Due: Refer to Unit Description
Total Marks: 40 marks
Worth: 20% of final assessment
This 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 
EstEFT  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 SampleGenerator102.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 SampleGenerator102 to reproduce the first sample.
To prepare your data file ready for analysis you must follow the following steps:

Provide a printout of the data in your sample, with ID numbers in ascending order.
Assignment Tasks


Determine the mean, standard deviation and standard error for the last three years of quarterly data. Use this information to carry out a ttest to see if the average number of quarterly accidents for the last three years is significantly less than 56.



Obtain a scatterplot of the quarterly number of accidents vs working days lost per quarter. Think carefully about which variable should go on the vertical axis – remember, it is the independent variable that goes on the horizontal axis (i.e. the xaxis). Make sure you label your axes properly and your graph has an appropriate title. Briefly describe the nature of the relationship between these two variables.

Using Tools>Data Analysis in XL carry out a regression analysis on these two variables. Copy the output into your assignment and use it to determine the following:

Write down the regression equation

State the RSquare value and the Standard Error and explain what they mean with respect to this data.

Write down the value of the gradient of the regression line and explain what it means in this case.

Is the constant or intercept value significant in this case? How do you know this?

Briefly explain why you think this regression model is, or is not, a good model.

Obtain a time series plot of the number of accidents per quarter. Describe the nature of this time series and identify which of the four time series components are present in this case.

Compare the first half of the time series to the second half (i.e. the first three years with the last three years), and briefly describe any differences.


By right clicking on one of the data points, add a trend line to the time series, making sure you include the regression equation and the RSquare value. Interpret the meaning of the slope coefficient in this case and state whether or not this is good for the company.


Use the regression equation to detrend the data placing the detrended data in another column. Obtain a time series plot of the detrended data and explain what it shows.

Using information from your analyses write a short concluding paragraph about whether or not the company has been successful in trying to reduce the number of quarterly accidents for its workers.
Delivering a highquality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a moneyback guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarismdetection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more