I have 2 excel sheets, one of them to 100 treatment group with 10 parameters. The another sheet with control group with same parameters( 10 parameters). My question is how I can add the two add these 2 sheets to SPSS and do comparing?
You need to introduce a group variable which could take 2 different values like 1,2 corresponding to 2 groups. When you compare groups you will be using this variable.
You could also add an id number variable and use the values 1 to 100 for your first group and 101 to 200 for your second group. Then just paste the rows of data into SPSS.