Question

The manager of a landline service department wished to investigate the effect of staff development training on the job completion rate among his staff. He selected a random sample of 30 service staff and recorded the number of completed landline services for each staff member both in the week before training and again in the week after training. Download and open the Landline.xlsx file in Excel. This file contains the number of completed landline services both before and again after staff development training.

Use Excel to carry out a suitable test to address the following research question: Is there a difference between the average number of completed landline services before and after staff development training?

Using these Numbers for x and y in excel:

before	after
20	31
20	29
21	33
18	26
18	29
23	35
20	29
18	35
22	36
21	32
23	34
20	28
17	31
19	30
19	37
16	23
18	38
19	26
23	35
21	31
20	32
21	27
21	32
16	32
21	38
17	28
27	29
21	31
22	29
16	28

3. marks) 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

Answer 1