Would any one have tried to run paired t-test on more than one pair of data then append the results into one table?
I need to run the test on over 600 pairs of dependent samples then append the test results in one table to see which pair gives a statistically significant results.
Hi jennifer can you provide a csv with the data and explain a little more on what you mean by ‘append the test results in one table to see which pair gives a statistically significant results.’ you want to run several t-tests and then create a table with the results ?
See if this helps, I’ve changed your XLS in order to have more than 1 sample per site, so ignore the data, I’ve used a group loop to iterate through each site, then I’ve performed the t test, in order to kkep a track on the site, i’ve appended the site name using a variable.