Macro Data-preprocessor --> descriptive analyses and data transformations.
The aim of the DATA PREPROCESSOR sub-program is to explore and prepare the raw data to make it amenable to further analyses using the Psychometric Tool Box. In brief, the DATA PREPROCESSOR can be summarized as some kind of convenient data manipulation of a dataset that is stored in an Excel sheet labeled “Data”. After the data manipulation, the processed dataset is stored in a sheet labeled “PreprocessedData”. Some basic item analyses are also provided. The functions can be classified as: (a) functions for processing data; (b) functions for exploring data; and (c) functions for saving data in a file so that it can be further analyzed using the Psychometric Tool Box. We shall now briefly review these three types of function.
Nine functions can be used to process a dataset. These functions expect to find a dataset already available in the sheet labeled “Data”, and the outcome of the processing is stored in a new sheet labeled “PreprocessedData”. The functions are:
Two functions can be used to export the outcomes of preprocessing the data. These functions expect to find a preprocessed dataset already available in the sheet labeled “PreprocessedData”. The functions are: (a) saving data as text, exporting the data as a text file with specific separators for the columns, and (b) save aleatory split-half, exporting each sample in a separate file.
Download file Data_preprocessor.xlsm: Data_pre-processor.zip