Rank	K6 - 2019	K6 - 2023	Difference	Absolute Difference	Negative Rank	Positive Rank
	4	4	0	0
	4	4	0	0
	0	0	0	0
	1	1	0	0
	2	2	0	0
	0	0	0	0
	0	0	0	0
	6	6	0	0
	0	0	0	0
	0	0	0	0
	0	0	0	0
	2	3	1	1
	9	8	-1	1
	9	8	-1	1
	2	3	1	1
	2	3	1	1
	1	2	1	1
	2	3	1	1
	2	1	-1	1
	8	7	-1	1
	1	2	1	1
	0	2	2	2
	2	0	-2	2
	2	0	-2	2
	0	3	3	3
	5	2	-3	3
	5	2	-3	3
	7	10	3	3
	6	3	-3	3
	2	5	3	3
	6	2	-4	4
	0	4	4	4
	2	6	4	4
	2	6	4	4
	4	10	6	6
	2	9	7	7
	2	9	7	7
	4	12	8	8
	1	11	10	10
	6	19	13	13

You decide to use a non-parametric test that makes use of the magnitude of the difference. Fill

in the ranks in the Excel version of the data. To determine the ranks you'll need to sort by the

absolute value of the difference. The Excel function that makes all the differences positive is

"=ABS()". Calculate the sum of the negative ranks and positive ranks. What is the expected

mean rank?

Also I need help with assigning the ranks