Forum Discussion

Ankit27's avatar
Ankit27
Copper Contributor
May 15, 2022
Solved

How to analyze excel data

 

 

The above attached data in excel sheet is a snap from my experiment. There are four columns with header . There are total 280 trials in total (40 times each of 50,100,150,200,250,300,350 millisecond  stimulus duration). I want to see for 50 ms duration (which is total 40 in number), how many number of '1' response button was pressed and how many number of '2' response button was pressed? Similarly for all other duration (100,150,200,250,300,and 350 ms), I  want to analyze the same thing.

 

Please help me out with this problem. I am not expert in Excel. Thanks in Advance. If you want me to upload or share excel sheet with you, I will share with you.

Resources