Intellectus does not support uploading data spread out over multiple tabs in Excel. In order to have all your data upload, you will need to combine it all onto the first tab. There are two ways to do this depending on whether you have matched case data or independent samples.

Matched-Case Data

Matched-case data is when you have data for the same subjects in each group. Each observation will have a “Subject ID” that you could use to match rows across multiple samples. Combining matched-case data involves pasting the columns side-by-side and matching them by ID. Let’s say we have matched-case data for each month on a new tab. We can copy the columns of each tab and match up the “Subject IDs” and paste them in the data on the first tab. The end result will look something like this:

Independent Samples Data

If you have independent samples, where each observation is a different subject, you will need to create a grouping variable instead. Let’s go with the same example above, so we have some measurement by month, where each tab is a different month on independent samples. Putting the data onto one tab will look like this:

To create a Project, firstĀ navigate to the Projects Tab. You can create a new Project by clicking the button at the top of the Projects panel.

Naming the Project

The next step is to choose a name for your project. Type the desired name into the text box and click Continue.

Uploading a File

Now you must choose a data source. If uploading a file, click the icon corresponding to the correct format, otherwise click the icon to enter data manually. Currently supported file formats include the following:

  • Comma-delimited (.csv)
  • Microsoft Excel (.xlsx)
  • SPSS (.sav)
  • SAS (.sas7bdat)
  • STATA (.dta)

Make sure your dataset is organized into columns with the variable names at the top. In an Excel or CSV file, your variable names will appear on row 1. If you are entering data manually, the variable names are entered above row 1.

Enter Data

If you don’t have a file, you can upload data by entering the data from scratch in our data editor. The top row of the data editor should contain the variable names and the rows labelled 1,2,3, … should contain the data for the variables. After you are finished entering your data in the spreadsheet, click the Upload button. In order to find out more information about the Data Editor’s sidebar go to the edit data help page.

The application will accept data in CSV, Excell, SPSS, SAS, and STATA formats, you can also enter your own data.

When uploading your data file to the application all variables with text data will default to nominal level of measurement and all variables with numeric data will default to scale level of measurement. Level of measurement can be adjusted after upload if desired.