I'm using Google Sheets and trying to conduct a t-test on pre- and post-survey data. The follow-up survey will almost certainly have fewer respondents than the pre-survey. All respondents have a self-generated identification code that I am using to match pre- and post-survey data.
I'm looking for a way to conduct a paired t-test on a range of pre-survey data that has a matching identification code in the post-survey data set. I'm thinking the FILTER() function or maybe even a vlookup() function might be necessary? I'm pretty stuck.
Another option might be to copy the data into another sheet using the filter() function to get only data that has a pre- and post- match, but it seems like if I can do this, I should be able to eliminate the need to copy to another sheet.
Link to spreadsheet (view only): https://docs.google.com/spreadsheets/d/1Da15-97zjTFQz6NLm5KlMJwduw4LxgvdR7v7MXsDgsI/edit?usp=sharing (Spreadsheet has analysis tab, columns I & K are where the t-tests are being done, pulling data from sheets with "raw" in the name rather than "scored" for these purposes. Only populated with a few data points to test functions, data will be collected by I won't be with the organization to analyze it so I'm trying to set up a process for them to use once I've left and into the future)