SOLVED

# How to analyze excel data

Occasional Contributor

# 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.

7 Replies

# Re: How to analyze excel data

``=COUNTIFS(\$C\$2:\$C\$281,\$F2,\$D\$2:\$D\$281,G\$1)``

Maybe with the countifs formula.

best response confirmed by Ankit27 (Occasional Contributor)
Solution

# Re: How to analyze excel data

@Ankit27 As a variant, consider using a pivot table.

See attached.

# Re: How to analyze excel data

Or the same formula 'simplified' through the use of defined names and dynamic arrays (as opposed to direct references using mixed absolute/relative notation and copy/fills.

# Re: How to analyze excel data

``=SUMPRODUCT((\$C\$2:\$C\$281=\$F2)*(\$D\$2:\$D\$281=G\$1))``

Alternatives could be SUMPRODUCT or Power Query.

This is great .

# Re: How to analyze excel data

Thanks a lot Quaruple.

# Re: How to analyze excel data

Thanks a lot Peter