Statistical gathering

The industrial company Acme is looking at buying new computer based technology to replace similar but older technology. The task the workers have to perform is relatively complex, even with the assistance of the technology, so the company has run a small user trial to compare two alternate pieces of equipment (A & B) available on the market.

Purchase issues such as capital and running costs etc were likely to be very similar so the company was only really concerned with the likelihood of workers making errors with the new technology because errors impact on productivity. The company wanted to see if there was any real difference between A & B in terms of the number of errors experienced by the workers.

Twenty workers were randomly selected from the workforce and were randomly allocated to two groups of 10. Group A trialed the Technology A and Group B trialed technology B. The number & type of errors each worker made was recorded. However because of an unforeseen breakdown in the system, only 6 of Group B workers were able to fully complete their trial – the data are given in Table 1 below and for the purposes of any statistical calculations; it can be assumed that the error data form a normal distribution.

Your solution will need a Word document and 1 worksheet in an Excel spreadsheet. You will need to enter the supplied data into Excel where you can do any calculations (use formulas or fx), graphing and or analysis. Ensure that there is sufficient labeling and analysis of the data. Given the data in Table 1, answer the following questions in the word document:

1. What is the null hypothesis (H0) and alternate hypothesis (H1) for this experiment?
2. Describe the important features of the data in a few lines of text. In this description, refer to a graph of the data which you have drawn in excel (make sure you include the graph in your word document).
3. Calculate the relevant means and standard deviations to test the hypothesis stated above.
4. Determine the 95% confidence limits for the difference stated in H1 above.
5. What kind of statistical test would you use to test the hypothesis stated above?

Price: $10.38

Solution: The downloadable solution consists of 5 pages, 538 words and 1 charts.
Deliverable: Word Document