Question description:
This user has given permission to use the problem statement for this
blog.
I'm trying to figure out how to calculate average reaction time for correct responses. I currently have one collum with either a 'C' or 'E' for correct or error and another collum with reaction time.
Solved by Z. Q. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/06/2018 - 07:58
Hi…Welcome to Got It Pro
Excelchat Expert
29/06/2018 - 07:59
Could you please share your data?
User
29/06/2018 - 08:00
Unfortunately, I can't share it because it has confidential information about research participants on it.
Excelchat Expert
29/06/2018 - 08:00
You can present a sample in this preview sheet and I can illustrate the formula, if that works.
User
29/06/2018 - 08:02
Like that?
Excelchat Expert
29/06/2018 - 08:02
ok...so you would like to average of C and E, is that right?
User
29/06/2018 - 08:03
Yes
Excelchat Expert
29/06/2018 - 08:03
Sure..let me work out the formula for you.
Excelchat Expert
29/06/2018 - 08:05
There you go....
Excelchat Expert
29/06/2018 - 08:05
Formula is in E2 and E3
Excelchat Expert
29/06/2018 - 08:05
Its an Averageif formula.
User
29/06/2018 - 08:06
Awesome! Thank you!
Excelchat Expert
29/06/2018 - 08:06
Syntax is = Averageif(CriteriaRange,Criteria,Average range)
Excelchat Expert
29/06/2018 - 08:06
Is there anything else I can help you with this query?
User
29/06/2018 - 08:06
Nope
Excelchat Expert
29/06/2018 - 08:06
Please do give me few feedback comments for my service at the exit of this session.
Excelchat Expert
29/06/2018 - 08:06
Thanks for your time. Please do come back for any new question. You can now end this session. Have a great weekend!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
