Question

A study was conducted to investigate whether compliance training affected the productivity of the company’s administrative staff. A random sample of 30 administrative staff underwent compliance training. Download and open the Accounts.xlsx file in Excel. This file contains the number of accounts processed by each staff member both in the week before compliance training and again in the week after compliance training.

Use Excel to carry out a suitable test to address the following research question: Is there a difference between the average number of accounts processed by administrative staff before and after compliance training?

before	after
54	65
44	64
54	60
54	54
45	54
42	72
54	61
52	61
52	71
50	48
55	65
47	69
48	61
50	59
45	61
51	64
48	57
54	60
48	64
46	63
49	59
43	61
52	60
56	67
52	61
49	65
47	63
53	59
52	64
49	59

1. (1 mark) The most appropriate test for these data is AnswerA two-sample t-testA paired t-test

2. (1 mark) Referring to the histograms provided, to check the assumption(s) for this test we would use AnswerThe number of accounts processed the week before compliance training (Graph A)The number of accounts processed the week after compliance training (Graph B)The number of accounts processed the week before compliance training and the week after compliance training (Graphs A and B)Differences between the numbers of accounts processed the week before and the week after compliance training (Graph C)None of the other answers

For the remaining questions you may assume that any relevant assumptions have been met.

3. The absolute value of the test statistic is equal to (type your answer with 3 dp) Answer

4. (1 mark) The degrees of freedom is equal to (type your answer as an integer) Answer

5. (1 mark) The p-value is larger than 0.05 Answertruefalse

6. The test indicates that the number of accounts processed: Answer

Answer 1

H0: There is no difference between the average number of accounts processed by administrative staff before and after compliance training

H1: There is difference between the average number of accounts processed by administrative staff before and after compliance training

Histogram of Before:

Histogram of After:

Both Histograms are nearly symmmetric or bell shaped so both variables follows normal distribution

2. Paired t test:

Critical t:              ±2.0452

P-Value:                 0.0000

since t value is not t critical value and P-value < alpha 0.05 so we reject H0

Thus we conclude that there is difference between the average number of accounts processed by administrative staff before and after compliance training