Paired or unpaired t-test and Wilcoxon signed rank test? I am having a conceptual problem, of not being able to grasp whether my data is paired or unpaired. I have to test for the mean and median differences between two sets of data: SBP and GICS (see picture). The sample population is 1,500 firms for all years from 2004 to 2018. The firms are not necessarily the same, i.e. the 1,500 firms in 2005 are slightly different ones in 2006. From this population, both the SBP and GICS creates groupings of 10 from the 1,500 firms - but do it differently.
After the SBP and GICS have created the groupings, they take an average of the group - which becomes the variable/observation for each system (technically, this is an absolute percentage error). The goal is to look at which grouping system generates the lowest absolute percentage error. I have tried to illustrate it with the following:

My initial thought was that the SBP and GICS were unpaired; i.e. there was no "before vs. after" medical treatment effect, since both "systems" does the exact same thing: to create groupings of 10. What matters is, how they select the 10 firms for each group. Can someone help?
I was left wondering this, when I tried to run the tests in R. The sample median and mean values of the SBP and GICS are the following:

If we take the "simple" difference of the median, it is clearly 1.5% and 2.2% for the simple mean. My understanding is, that when I calculate the statistical pairwise difference (unreported from the figure), this value should be LOWER than the "simple" difference. Running the wilcox.test in R, with the following code:
wilcox.test(GICS, SBP, alternative = "two.sided", mu=0, conf.int=T, conf.level = 0.99, paired = TRUE

gives me a pairwise difference of 1.9%, where I am left wondering, why I can be in a situation where the pseudo median (population estimator) of a Wilcoxon signed rank test, can be larger than the simple differences between sample medians? I am performing a paired signed rank test, since my data is dependent. 
I have uploaded my dataset here: Dataset as a .csv file. 
Can someone help my understanding? 
My main questions summarized: 


*

*(1) Is my sample paired or unpaired? 

*(2) By running the Wilcoxon    signed rank test and Student t-test,
can the generated pseudo median (or mean) EVER be larger, than the simple
difference between sample medians and    means?


EDIT: Running the Wilcoxon test as paired, i.e. pair=TRUE, gives me a pseudo median of 1.513%. 
 A: *

*My understanding of what you are doing is as follows:


*

*You have a dataset for each year.

*You have two systems, SBP and GICS, that each use the same input dataset (each year), but follow different processes so each come up with a different grouping. (I am assuming here that they each just create one grouping per year. It's not clear to me from your question if it's actually multiple groupings).

*Assuming we're just talking about a single grouping per year, you then calculate a value based on that grouping, for each system.

*You want to compare the values calculated by each system.



Based on this, I would say that you do have paired data, and that the pairs are by year (2006, 2007 etc.).
If you are actually comparing the outcomes of multiple groupings, over multiple years, then that would make things more complicated.
Also, an assumption of both the Student's t-test and Wilcoxon test is that your data points are independent. If this assumption is violated, then you cannot rely on the results. If you have the same firms in your dataset in different years, then I would argue that your data points are not in fact fully independent, and you should address this first before carrying out your test.


*The Wilcoxon test is actually a test of ranks, not medians. I see that you have a separate question on the pseudomedian, which I haven't come across before. From what I understand from the statement 'The pseudomedian of a distribution F is the median of the distribution of (u+v)/2, where u and v are independent, each with distribution F. If F is symmetric, then the pseudomedian and median coincide.' from ?wilcox.test as provided by Łukasz Deryło, then it stands to reason that if F is not symmetric, the pseudomedian and median will not be the same. I can't see any reason why the pseudomedian should be more likely to be 'wrong' in one direction (smaller) than the other (larger), but someone who understands it more might have an insight into this.

