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

APA Style: 2.8 Running Head (p. 37)

Running Head (an abbreviated title) [Format] Appears in the page header of every page. All-capital letters. Maximum of 50 characters, counting letters, punctuation, and spaces between words. Flush left. Avoid using abbreviations. However, & (instead of “and”) can be used. No period at the end. For example, WEATHER AND MOOD [Contents] Running head is an … Read more

APA Style Manual (p. 167): 6.17 Capitalization (Title case & Sentence case)

There are Two Types of Capitalization in APA Style: Title Case Capitalization vs. Sentence Case Capitalization. 1. Title Case Capitalization Title case capitalization: Major words are capitalized, and most minor words are lowercase. For example: Projecting Planned Trajectory of an Automated Vehicle via Augmented Reality: Effects on Takeover Performance When a Takeover Request Was Not … Read more

APA Style: 2.19 Basic Formatting Guidelines (font, spacing, margin, alignment, indentation) (p. 44)

These are the basic formatting guidelines that your paper must meet even before you type something in your main text. Font: The following are the fonts that you can use (Be consistent throughout the paper) 11-point Calibri (the default of MS Word) 11-point Arial 10-point Lucida Sans Unicode 2-point Times New Roman 11-point Georgia normal … Read more

Excel How To: Data Analysis ToolPak Installation

Excel’s Data Analysis Tool, called Data Analysis ToolPak, has most of the functions that an introductory-statistics class would require: Frequency Table, Histogram, t-test, ANOVA, and so on. How To Install Excel Analysis ToolPak 0. Preview of the Outcome Here’s the image showing what’s going to happen when you successfully install the Data Analysis ToolPak for … Read more

Excel How To: Grouped Frequency Table & Bar Graph Using Analysis ToolPak’s Histogram Function Instead of PivotTable

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

Basic Concepts of Measurement (5 min.)

Variable Construct Values & Scores Measurement & Operational Definition Comprehensive Example Summarizing Above Concepts Measurement Scale: Nominal (Categorical), Ordinal (Rank-Order), (Equal-) Interval, and Ratio Variable Variable: Any characteristic of people or things you (researchers) are interested in. For example, height or intelligence of people. [Star Q] “Why is it called a variable? Because it …” … Read more

Frequency Analysis & Frequency Table (6 min.)

A Short Intro Many social science students, including psychology, hate statistics. I was one of the statistics haters, too. I couldn’t understand the contents from my undergraduate stat classes and how stats might be used in my life in the future. However, when social science students do a job interview, one of their expected skills … Read more