Question

The paired data values for this test are

Pair	First Value	Second Value
1	-14.59	-10.74
2	-9	-8.03
3	-9.51	-8.83
4	-6.63	-6.99
5	-7.66	-11.63
6	-14.51	-5.1
7	-6.22	-9.65

There are 7 data pairs. In the test, subtract the First Value from the Second Value. Also,Δ₀ = 0. Compute the test statistic t₀

Answer 1

Ans.

Pair	First Value	Second Value	d	(d_i-d_bar)^2
1	-14.59	-10.74	-3.85	8.000816327
2	-9	-8.03	-0.97	0.002644898
3	-9.51	-8.83	-0.68	0.116573469
4	-6.63	-6.99	0.36	1.908344898
5	-7.66	-11.63	3.97	24.91435918
6	-14.51	-5.1	-9.41	70.36813061
7	-6.22	-9.65	3.43	19.81521633
			-7.15	125.1260857
	n=	7
	d_bar	-1.021428571
	s_d^2	20.85434762
	SD	4.566656065
	Test statistics is
	t0	(d_bar-mu)/(s_d/sqrt(n))
		-0.591777866

Test Statistics  

Pair	First Value	Second Value	d	(d_i-d_bar)^2
1	-14.59	-10.74	=F7-G7	=(H7-$G$19)^2
2	-9	-8.03	=F8-G8	=(H8-$G$19)^2
3	-9.51	-8.83	=F9-G9	=(H9-$G$19)^2
4	-6.63	-6.99	=F10-G10	=(H10-$G$19)^2
5	-7.66	-11.63	=F11-G11	=(H11-$G$19)^2
6	-14.51	-5.1	=F12-G12	=(H12-$G$19)^2
7	-6.22	-9.65	=F13-G13	=(H13-$G$19)^2
			=SUM(H7:H13)	=SUM(I7:I13)
	n=	7
	d_bar	=H14/G17
	s_d^2	=I14/6
	SD	=SQRT(G21)
	Test statistics is
	t0	(d_bar-mu)/(s_d/sqrt(n))
		=G19/(G23/SQRT(7))