We create an APA-style frequency table with scores in descending order, simple frequency, relative frequency, cumulative frequency, percentile, and sample size. We use JASP for the statistics, Excel for the formatting, and wrap it all up for presentation in Word. These same techniques work with open-source word processing and spreadsheet programs.
Download the Friendly, Free, Flexible, Functional JASP software from the official JASP statistics website: https://jasp-stats.org
This video teaches the following commands and techniques in JASP:
Calculate frequencies in JASP
Create a frequency table in Excel
APA formatting for tables
Present a table in Word
This video uses the dataset MyClass.sav and JASP version 11.1
Link to a Google Drive folder with all of the files that I use in the videos including spreadsheets, the Bear Handout, and the MyClass.sav dataset. As I add new files, they will appear here, as well.
https://drive.google.com/drive/folders/1n9aCsq5j4dQ6m_sv62ohDI69aol3rW6Q?usp=sharing
To download, hover your cursor over the file icon and a blue download icon will appear. You do not need to request access to a file.