Compute a Correlation Coefficient These data were entered into Microsoft Excel and the Pearson r test was used to determine the correlation coefficients. 1. Open your worksheet and prepare your data for analysis. 2. Click Data, click Data analysis to display the statistical options. 3. Select Correlation, click OK. 4. Complete the pop-up box, putting all variables in for the range and being sure to include labels. Select an output range. Click OK. 5. Format your output so that it is readable. You will see the output in the following form: Age Caffeine PupSize DSR Age 1 Caffeine 0.698762 1 PupSize 0.290856 0.574839 1 DSR 0.044288 0.386787 0.828967 1 DSF -0.15589 0.154034 0.53669 0.75811 DSF 1 This give you the correlation between each pair of variables, but it does not tell us if the relationship is significant. For that, we need to use a table of critical values for the Pearson Correlation to find whether the correlation is significant with p ...
Purchase document to see full attachment