Question

Assume that the differences are normally distributed. Complete parts ​(a) through ​(d) below.

Observation	1	2	3	4	5	6	7	8
Upper X Subscript iXi	43.2	43.4	44.0	42.342.3	50.4	43.4	52.5	49.6
Upper Y Subscript iYi	45.8	45.1	47.8	46.1	49.8	46.1	52.9	48.8

​(a) Determine

d Subscript i Baseline equals Upper X Subscript i Baseline minus Upper Y Subscript idi=Xi−Yi

for each pair of data.

Observation	1	2	3	4	5	6	7	8
di

​(Type integers or​ decimals.)

Answer 1

using excel

enter the X value in column A from A1 to A8

and Y values in column B from B1 to B8

In Cell C1, type the formula A1-B1

and drag down the formula from C1 to C8

we get the following output

x	43.2	43.4	44	42.3	50.4	43.4	52.5	49.6
y	45.8	45.1	47.8	46.1	49.8	46.1	52.9	48.8
x-y	-2.6	-1.7	-3.8	-3.8	0.6	-2.7	-0.4	0.8

Row (x-y) shows us the required values for di row

(We simply subtracted each value of y row from x row)