3 Excel Methods for Creating a Frequency Table

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

Correlation: What’s the relationship between your height and your parents’ height?

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

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

APA Style: 2.11 Text (Body). How to Format the First Page of the Text (on page 3)?

First of all, here’s an example of the start of a text. When you start the main text of your research paper, make sure to insert a page break after page 2 by doing ctrl+enterat at the bottom of your abstract page (on page 2). Then, the main text that should start from page 3 … Read more

APA Style: 2.9 Abstract & Keywords (p. 38). How to Format the Abstract and Keywords?

Abstract First of all, the abstract is placed on its own page after the title page (i.e., page 2). Here is an example. [Format of the label “Abstract”] [Format of the Contents] Keywords [Format of the label, “Keywords:”] [Format of the contents]

How to Insert the Dagger † Symbol (looks like the cross) in MS Word for APA Style

Windows: Alt + 0134 Mac: Command + Control + Spacebar to open the Character Viewer. Then, search for “Dagger” (you may need to scroll up or click the icon at the upper right corner to be able to search.) When to Use Daggers in APA Style? In the following three cases: How to Format the … Read more

APA Style Manual (p. 195): 7. How to Format & Present Tables

Topics 1. When to use a table? 2. What are the components to be included in a table? 3. Where to place a table in an APA-style paper? 4. How to refer to tables in the text? 1. When to use a table? To present the results of multiple statistical tests or many descriptive statistics, … Read more

Excel How To: (Grouped) Frequency Table Using Pivot Table Function Instead of Analysis ToolPak’s Histogram Function

You can create a (grouped) frequency table using the Histogram function of Analysis ToolPak. However, one downside of this method is that you need to manually decide the bins. For example, you need to manually list all the possible values for a regular frequency table or manually enter the upper limits of the bins (grouped … Read more