Analysis tool

Calculating the Pearson correlation (r) using Excel

by

Cell Preparation Here’s an image of the cells prepared for calculating r using Excel. I hypothesized that we want to calculate the r using two variables (X and Y) as shown below: X: 1, 2, 3, 4, 5, 6, 7, 8, 9, and 10. Y: 10, 9, 8, 7, 6, 5, 4, 3, 2, and … Read more

Calculating the Z-score Using Excel

by

Cell Preparation Here’s an image of the cells prepared for calculating Z scores. I hypothesized that we want to calculate the Z scores of a variable X that has the following scores: 1, 2, 3, 4, 5, 6, 7, 8, 9, and 10. First, vertically list the numbers of the variable (X) based on which … Read more

3 Excel Methods for Creating a Frequency Table

by

Method 1: Using “Countif” in Excel Note, this is a tedious method and therefore you would want to move on to the next methods that are more efficient. However, using Countif is a straightforward method and therefore useful for discussing the frequency table. Countif counts the number of cells that meet a certain criterion (e.g., … Read more