As a part of my thesis, I collect data from students and I combine their data in a single Excel sheet.
The experiment consists of 200 trials. Every trial gives me three numbers:
- The answer is correct (1) or incorrect (0)
- Participants' rating of their confidence in a 5-point scale
- Reaction time
However, Excel has some weaknesses.
- I cannot write three numbers in one cell
- Excel doesn't warn me when I mistakenly change or delete data
- The formulas become too complex as I just want "average correct answers when confidence is 4 or 5 and Reaction Time is less than 2 seconds"
- There are too many rows columns
Below you can see an example how I try to handle my data: (notice the dots, in my original file there are hundreds of rows and columns)
So, I was wondering if there are some other good software (for mac os, if possible) for storing data. Or, do most experimental psychologists store their data in Excel, too?
Edit. I am aware of the existance of other stack exchange sites. You can vote to close if you think this problem is off-topic, but please don't post unfriendly comments.
I thought this problem relates to academia more than other "computer science, programming" stack exchange sites because most psychologists in academia encounters this problem, but they handle it very "manually" because they don't have a programming background. I thought there are some user-friendly software for social scientists.
Thanks for your valuable answers.