i'm your statistics sidekick
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
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
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
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
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
Examples of Frequency Table, Bar Graph, Grouped Frequency Table Here’s an example of a frequency table that shows the frequency of a variable. The variable was my happiness scores measured out of a 1-10 scale from the past 10 days. PossibleHappinessScores Days 1 1 2 0 3 0 4 0 5 2 6 0 7 … Read more