i'm your statistics sidekick
First of all, here are examples. Paper Presentations Maddox, S., Hurling, J., Stewart, E., & Edwards, A. (2016, March 30–April 2). If mama ain’t happy, nobody’s happy: The effect of parental depression on mood dysregulation in children [Paper presentation]. Southeastern Psychological Association 62nd Annual Meeting, New Orleans, LA, United States. Parenthetical citation in text: (Maddox … Read more
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
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
Note, use the present tense. Here are the main tasks that you would want to complete in the general discussion section of your research paper along with useful expressions for each task. 1. Summarize your study • [Motivation/Purpose] The purpose of this study was to gain a better understanding of … • [Method Summary] To … Read more
This posting explains how to conduct Chi-square test of goodness of fit using Excel and SPSS. If you want a detailed explanation about the test itself, then, click this link Chi-square test of goodness of fit. Chi-Square formula and brief overview Here’s the formula for the Chi-Square (χ2): Here’s a simpler version: \[\chi^2 = \sum\frac{(O … Read more
A nice link between the Descriptive Statistics (Frequency Table) and the Inferential Statistics (Chi-Square Test of Goodness of Fit) One of the concepts discussed early in the Introductory Statistics course is the Frequency Table, which describes the sample’s frequency (descriptive statistics). An inferential-statistics method that can be applied to such a frequency table is Chi-Square … Read more
Let’s say you created a frequency table using one of the methods from 3 Excel Methods for Creating a Frequency Table. The below image shows a frequency table using the pivot-table method (Method 3). How could we create an APA-style table based on the Excel table (pivot table)? Step 1: Copy and paste the pivot … Read more
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
The following graph shows the relationship between the two. The point of this figure is that the taller the parents, the taller the offspring (and vice versa). We should note, though, that the offspring of even very tall parents would not equal the height of its parents, but rather would be slightly shorter in stature … Read more
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