Quickly visualize and analyze data using the point and click statistical modules.

Get a quick video overview of the data analysis module in the workspace here.

# Using the Data Table Analytics module

If you select a database table or a CSV file, in the right-hand sidebar you should see the *'Analyse data'* option.

Clicking on it will open the **Data Table Analytics**, which includes an analytics sidebar with over **20 modules that cover the core of medical statistics**: from scatter plots to logistic regression. These modules enable quick visualization and analysis of data.

Once the table opens, you can run a module in one of the two ways: either by first selecting the module or by first selecting the data. For more details, see the sections below.

### Selecting the module

From the list on the right-hand side, **select the module** you are interested in and the module will open on the right half of the screen. Use the dropdown boxes to **select the table columns** you would like to analyse. When the mandatory boxes are filled, your chart will be generated and displayed.

You can change the data by selecting different columns in the dropdown boxes and pressing the **Run** button beside the module name. From the same window, you can also select a different module by clicking on the name.

### Selecting the data

From the data table editor, you can **select the columns of data** you want to analyse by clicking on the column names. Your first selection will be taken as an X variable, the second as a Y, and so on. As you select more columns, the **modules filter down** to show only the ones that are compatible with the selected data types. **Click on a module to run it**, and the visualisation will be displayed.

Again, you can change the data by selecting different columns from the dropdown boxes and then clicking the **Run** button.

### Saving the plot

**Hover** over the image and a button will be displayed giving the option to save the plot as a *.png* file. The plot will be saved in the workspace **Blobs**.

### Showing the code

Below the generated plot there is a button called </> **Show code**. Hovering your mouse over this button shows you the R code that was used to generate the plot and gives you the option to *'Copy to clipboard'*.

Clicking on **Copy to clipboard** will copy the R code used to generate your image to your clipboard so that you can use it elsewhere.

The other button, **Send to R Console**, will send the code to the workspace R console if you already have one running or it will open a new session and run the code there.

### Getting help

If you need help with any of the modules, click on the **Info** icon. This will open a page in the knowledge base explaining the usage of that module and the required parameters.

### Limitations

Please note that analytics modules will run in *normal mode* when the **Dataset** that is being analyzed has less than 10,000 rows and 100 columns for a *CSV file*, and if it's less than 250,000 cells for a *database table*. If it is bigger than that, it will run in *sample mode*.

# Statistical Modelling

Discover statistical modelling modules:

**Linear Regression**Learn how to model linear relationships by fitting a linear regression model.

**Binomial Logistic Regression**Learn how to model binary relationships by fitting a logistic regression model

**Analysis of Variance (ANOVA)**Model an Analysis of Variance between numeric response variables and predictor variables

# Statistical Testing

Discover statistical testing modules:

**Student's T-test**Learn to perform a Student's T-test to test a null hypothesis involving the means of two groups

**Mann-Whitney U test**Learn how to use this nonparametric method of testing to compare potential differences

**Pearson's chi-squared test**Understand how to work with independent variables with no relationship