PSYC 2002 Lecture Notes - Lecture 1: Microsoft Excel, Standard Deviation, Bergen Street Line
13 Feb 2018
School
Department
Course
Professor
Document Summary
This page presents all the questions that you must answer for this data analysis assignment using. Question 1a to 1c must be answered on the response accuracy page. Questions 2a to 2j must be answered on the response times page. Questions to be answered on the error rate page. This page shows the mean proportion of errors per block for each participant that was tested. For instance, the datum found in cell b5 shows that participant 1"s error rate was 6. 74% during the first block of the experiment. Calculate the mean error rate and the standard deviation of the error rate for the entire experiment. Use the appropriate excel functions and insert your answers in the cells q67 and q68. Calculate each participants" mean error rate for the experiment. Use the appropriate excel function and insert your answers in the cells r5 to r65. Once you have entered the appropriate formula in cell r5, select that cell and copy it.
