Calculating the Pearson correlation (r) using Excel

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

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

APA Style: How to Report Participant (Subject) Characteristics?

Here’s an example. The second group included 40 cisgender women between the ages of 20 and 30 years (M = 24.2, SD = 2.1, Mdn = 25.1), all of whom had emigrated from El Salvador; had at least 12 years of education; had been permanent residents of the United States for at least 10 years; … Read more