Certification materials - Data preparation and statistical analyses (Basic)

The Basic level certification focuses on preparing data for statistical processing and applying basic statistical methods in the Statistica software environment.

To prepare for the certification test for this level, we recommend focusing on the following topics, which may be included to varying degrees in the certification test.

Loading MS Excel data

• Loading variants, configuring the data file

Recoding a variable

• Handling missing values, transforming continuous to categorical

Creating a new column

• Including the basic syntax of mathematical operations on columns

Creating a subset

• according to the defined requirements

Rearranging data in a subset

Creating descriptive statistics over a table

• Configuring and adjusting outputs

Creating a box plot (Box Plot)

• with the display of two variables
• Editing the graph and its graphical adjustment

Detecting missing values

• Procedures for detecting and identifying values

Creating a frequency table

• With table settings

Testing statistical hypotheses

• With the drawing of conclusions and interpretation of results

Interpreting conclusions

• from the above analyses

Saving the task including all its parts