Hello,

Sorry if my subject is not clear. I have a problem with my data when trying to do industry adjustment in my master's thesis. I have data as follows:

SIC Tobins q CapEx1 Capex3 Empl1

3845 1,103 -1,289 -0,745 -0,977

3845 1,187 -0,661 0,374 -0,912

3842 1,309 -0,683 -0,313 -0,905

3842 1,112 -0,654 0,219 -0,968

3833 1,061 -1,048 -1,055 -1,000

3833 0,989 -0,268 -1,304 -1,000

3833 0,960 -1,426 -1,514 -0,906

SIC is the grouping variable. I need to subtract the median of all the variables from the observations when the medians are based on groups. So for example for group 3845 I would calculate the median of Tobins q for those two observations (1,103 and 1,187) and then subtract the median from those same two observations. This has to be done for every group and every variable. How could this be done in SPSS?

Thank you for your help in advance.