1 About This Guide

This quick guide provides step-by-step Rguroo instructions and examples for common statistical analyses and graphs. Throughout, there are clickable video icons Instructional video icon linked to the Rguroo Video Tutorials Library for the presented topic. Additionally, you can get more technical details for most topics by clicking on the User’s Guide icon Users guide icon.

Most examples use data available in the Rguroo dataset repositories, and therefore you can reproduce the examples by importing the datasets from the Rguroo dataset repositories. See the Rguroo’s Dataset Repository section to learn how to import a dataset from the repository to your Rguroo account.

2 Rguroo Dataset Editor

You can use Rguroo’s dataset editor to perform the following tasks:

  • Create new datasets and edit existing datasets
    • Copy-paste data within the editor
    • Copy-paste data to and from an external source
    • Search and replace text
    • Add, remove, and rename variables
    • Add and remove rows
    • Reorder variables
    • Filter data
  • Define variable properties
    • Define variable types (numerical, nominal, ordinal, label/ID)
    • Edit levels of categorical variables (reorder, relabel)
  • Additional utilities
    • Obtain a quick data summary
    • Sort data
    • Pin columns and resize columns
    • Export data as CSV or Excel

2.1 Components of the Dataset Editor

The following are the main components of the dataset editor:

  • magnifier icon Search and Replace icon, used for searching and replacing text.

  • Row column icon Variable and Row Management icon, used for performing tasks such as renaming variables, adding variables, managing variable types, relabeling and reordering levels of Factor (categorical) variables, and adding rows and variables.

  • Summary data icon Summary Data icon, used for getting a quick data summary for the dataset that is being viewed.

  • trash icon Deleted Rows icon, used for retaining deleted rows and restoring them.

  • three horizontal bar Variable Context Menu icon appears when your cursor is placed over a variable name on the header. It provides options for for pinning and auto-sizing columns and renaming the corresponding variable.

  • Right-click on a cell provides options for copying and cutting selected cells, and pasting then (using Cntrl+V). It moreover, allows for adding and deleting rows, and exporting data to a CSV or Excel file.

  • Quick search textbox Quick Search textbox, used for forward and backward text search.

  • Quick Filter textbox Quick Filter textbox, used for filtering rows that contain a specific text within the entire dataset.

  • Save as textbox Save As textbox, used for saving datasets.

  • Columns list Column Sidebar Menu, located on the right-hand side of the editor window, includes a list of all the variables in the dataset. It is used for reordering, removing, or restoring removed variables (columns).

  • Filter variables Filter Sidebar Menu, located on the right-hand side of the editor window, includes a list of all the variables in the dataset. It is used for filtering specific values within each variable.

2.2 Creating and Editing Datasets

2.2.1 Creating a new dataset Instructional video icon

You can create and save a new dataset using the following instructions:

Creating a Dataset
  1. Open the Data toolbox located on the left-hand side of the Rguroo application window.

  2. Click on the Data Import dropdown, Data import Dropdown, and select the Create New Dataset option. The Create New Dataset dialog opens. Specify the number of rows and columns for your new dataset.

 Create New Dataset Dialog


  1. The default variable names will be Var1, Var2, etc. Refer to the Section Changing Variable Names to see how to change the variable names.

  2. Enter your data. See the Notes below on how to navigate between cells when entering data.

  3. Enter a name for your dataset in the Save As textbox on the top, and click the Save as button button to save your dataset.


Notes

  • By default, the number of rows is set to 500 and the number of columns is set to 30. You have the option to modify these values. If you are uncertain about the specific number of rows and columns you will need,select a larger grid by specifying a large number of rows and columns. This ensures that you have enough space to accommodate your data. After saving the dataset, when you reopen it, the grid will automatically adjust to match the actual number of rows and columns used by your data.

  • You can add additional rows and columns, if needed (see section 2.3).

  • When you login, Rguroo’s dataset editor opens in a tab without any data. You can close the dataset editor tab at anytime.

  • To enter values into cells and navigate through them using the keyboard, follow these instructions:

    • Click on a cell to select it.
    • Type in the desired value.
    • To move horizontally between cells: -Press the Tab key to move forward.
      • Press the Shift-Tab keys to move backward.
    • To move up and down between cells:
      • Type in a value.
      • Press the Enter key.
      • Use the up, down, right and left arrow key to move to the adjacent cells in the respective direction.

2.2.2 Editing an existing dataset

To edit an existing dataset use the following instructions:

Editing an Existing Dataset
  1. Open the Data toolbox located on the left-hand side of the Rguroo application window to see the names of the existing datasets.

  2. Use one of the following three options to edit a selected dataset:

    • Double-click on the dataset name
    • Right-click on the name and select the option Edit from the context menu
    • Select the name and press the Enter key.
  3. Use the dataset editor features to modify your dataset. See Notes in the Section Creating a new dataset on how to enter data and navigate between cells.

  4. Click the Save as button button to save your changes.

2.3 Variable and Row Management Dialog

The Variable and Row Management dialog can be accessed by clicking on the its icon Row column icon. This dialog is used for changing variable names, changing variable types, reordering and relabeling levels of factors (categorical variables), and adding rows and columns (variables) to your dataset.


Note: Categorical variables, and specifically Nominal and Ordinal variables, are referred to as Factors in Rguroo.

2.3.1 Changing Variable Names

In the dataset editor, the name of each variable is displayed on the column header. Default variable names are Var1, Var2, etc. You have two options, shown below, for changing variable names. The first option is useful when you need to change the names of multiple variables at the same time, while the second option is useful when you want to change the name of a single variable quickly.

Changing Variable Names: Option 1
  1. Click on the Variable and Row Management icon Row column icon. This will open the Variable and Row Management dialog.

  2. From the list of variables displayed, select the variable that you want to rename.

  3. Locate the Name textbox within the dialog, and type your desired new variable name in the textbox.

  4. Press the Enter key on your keyboard. The new variable name will now appear in the header, replacing the old name.

Note: Variable names cannot contain spaces. Make sure to avoid using spaces when entering the new variable name.


Variable and Row Management Dialog: Changing Variable Names

 Variable and Row Management Dialog


Changing Variable Names: Option 2
  1. Move your cursor over the variable name on the header. You will see the Variable Context Menu icon three horizontal bar.

  2. Click on the icon to open the variable context menu (shown on the left panel in the figure below).

  3. From the menu select the option Rename. This will bring up the Rename Variable dialog box (shown on the right panel in the figure below).

  4. In the dialog box, type in the new name for your variable, and press enter. The new name will now appear on the header. Note that variable names cannot have spaces.


Variable Context Menu

Variable context menu


2.3.2 Adding new variables

Use the following instructions to add new variables to your dataset:

Adding Variables
  1. Click on the Variable and Row management icon Row column icon to open its dialog.

  2. Select the Add Variables option. The dialog shown in the figure below shows.

  3. Type in the number of variables that you want to add in the No. of Variables textbox.

  4. Select one of the Beginning or End options to place the variables.

  5. Type a prefix for the name of the variables in the Name textbox. If you are adding a single variable, simply type in the name of the variable. (See notes below regarding variable names when adding multiple variables).

  6. Click on the Add variables button.


Add Variables Dialog


 Add Variables Dialog


Notes

When adding variables to your dataset, there are two possible scenarios to consider for naming the variables:

  • Adding a Single Variable:

    • If you are adding only one variable, simply type its name directly.
    • For example, if you want to add a variable named “age”, just type “age” as the name.
  • Adding Multiple Variables:

    • If you are adding multiple variables simultaneously, you need to specify a prefix that will be used for all the variable names.
    • For instance, if you type in “foo” as the prefix, the first variable will be named “foo”, the second variable will be named “foo1”, the third variable will be named “foo2”, and so on.
    • To change variable names to your desired values, refer to the Section 2.3.1 for instructions on modifying the names according to your specific needs.

To change the location of variables in your dataset, you have two options:

  • Click and hold:

    • On the header, locate the variable name you want to move.
    • Click and hold the variable name.
    • Drag the variable name to your desired location in the header.
    • Release the mouse button to place the variable in the new location.
  • Columns Side Bar:

    • Open the Columns Side Bar.
    • Click and hold the column handle the column handle Column handle associated with the variable you want to move.
    • Drag the variable to your desired location within the side bar.
    • Release the mouse button to position the variable in the new location.

2.3.3 Adding new rows

There are two options for adding rows to a dataset. The first option, described below, is useful for adding multiple rows simultaneously, while the second option is useful when you want to add one row at a time.

Adding Rows: Option 1
  1. Click on the Row column icon icon to open the Variable and Row Management dialog.

  2. Select the Add Rows option. The dialog box shown in the figure below will appear.

  3. Type in the number of rows that you want to add in the # of Rows textbox.

  4. Select from one of the options Beginning, End, or Below Selected Row to indicate where you want the rows to be added.

  5. Click on the Add rows button.


Add Rows Dialog