How-to guides
Learn how to use AddMaple with our how-to guides and frequently asked questions. If you can't find the answer you need please contact us.
User Guide
Correlation Tests (Pearson and Spearman)
These are run automatically when pivoting by 2 numeric columns. Pearson’s correlation is applied if the data is normally distributed, while Spearman’s correlation is used if the data is not normally distributed. These tests measure the strength and direction of the relationship between the two numerical variables.
Read MoreUser Guide
How to run a Kruskal-Wallis test
When you pivot by a categorical column and a numeric column, and the categorical column contains 2 or more categories with less than 4 results, AddMaple will use the Kruskal-Wallis test rather than ANOVA.
Read MoreHow To
Statistical Calculations
Find out how to use AddMaple's stats engine and how it works
Read MoreFAQ
How does AddMaple work without uploading data?
AddMaple analyses your data in your browser without uploading it to the cloud. We use modern web APIs to read and process your files all within your browser.
Read MoreUser Guide
How To Aggregate
AddMaple supports the following aggregation functions:
Read MoreUser Guide
How to create custom bins
AddMaple automatically calculates appropriate "bins" or groups for numeric and date data. These are re-calculated automatically based on your dataset and the filters you have applied.
Read MoreUser Guide
How to create custom segments
AddMaple allows you to create new columns with custom "segments". These segments can be as simple or as complex as you need. You can create fine-grained personas from multiple filters or just create a simple single filter segment.
Read MoreUser Guide
How to run a T-Test
AddMaple performs a 2-sided T-Test automatically when you pivot by a numeric column and a categorical column with only 2 categories. If you want to run a T-Test on a column with more than 2 categories, you first need to filter down to only look at 2 categories.
Read MoreUser Guide
How to run an ANOVA test
AddMaple will automatically run an ANOVA test when you pivot by a categorical column and a numeric column.
Read MoreUser Guide
Chi-Square Test
AddMaple runs chi-square tests for you automatically to determine whether there is a significant relationship between two categorical columns and the strength of that relationship.
Read MoreUser Guide
How to analyze text data thematically or categorically
AddMaple allows you to edit and refine your themes or categories iteratively. You can use Gen AI to suggest codes for you or you can add codes yourself.
Read MoreUser Guide
Opinion Scale Columns
When you expand a opinion scale column it will be displayed as a standard AddMaple bar chart.
Read MoreUser Guide
Grouped Opinion Scale Charts
Where AddMaple detects multiple opinion scale columns next to each other we group them together.
Read MoreUser Guide
Exploring Related Columns
If AddMaple detects columns that are significantly related to your selected column they will show up in the Stats tab:
Read MoreFAQ
How does AddMaple use OpenAI?
Learn how we use OpenAI, but how your data is not stored or used for training new models.
Read MoreUser Guide
AI Summaries of Text Columns
When viewing a text column, you will see a button: Get AI Summary
Read MoreUser Guide
AI Powered Chart Explanations
While viewing any chart in AddMaple, whether a single or multiple pivot, you can get an AI powered explanation.
Read MoreHow To
How to pivot your data
AddMaple makes it simple and intuitive to pivot your data. We help you cross-tabulate, pivot and aggregate your data without any complicated settings.
Read MoreHow To
Open .sav files without spss
Discover how to open .sav files without SPSS. We show you how to convert .sav files to excel or .csv, as well as how you can instantly explore and analyze .sav files in the cloud without SPSS.
Read MoreUser Guide
Adding and removing columns in the table view
This is done via the multi select box in the sentence builder.
Read MoreUser Guide
Sorting table columns
All columns in the table view are sortable. Simple click on the sort icon next to the column title. Clicking again will toggle between ascending and descending order.
Read MoreUser Guide
Exploring a single row
To explore a single row, simply click on the row number (in the left column)
Read MoreUser Guide
Adding a filter from the table view
You can add a filter by clicking on the value that you would like to filter by in the table. For example when viewing an "Age" column, clicking on the "65+" value from one of the rows will filter the entire table to only show rows where the "Age" is "65+".
Read MoreUser Guide
Adding a filter from the row view
You can add a filter by clicking on the value for a particular column
Read MoreUser Guide
Understanding the row by row view
This view allows you to see a single "row" from you data in a vertical view. This is a lot easier than a traditional spreadsheet (table) view and allows you to dive into a specific row to see the results for all columns for that row.
Read MoreUser Guide
Navigating between rows
In row by row view you can navigate between rows through the Next and Previous buttons.
Read MoreUser Guide
Adding a chart to your report
To add a chart to your report, simply navigate to the chart you want to add, click the kebab menu and click "Add To Report".
Read MoreUser Guide
Publishing a report
Reports are unpublished by default. To publish, simply click the "Publish" button - the url of your published report will then be made visible.
Read MoreUser Guide
How to make your data explorable
You can let viewers of your report also explore your data using AddMaples tools.
Read MoreUser Guide
Editing column titles and types
You can change the title of a column by clicking on it from the Chart Dashboard. An input box will appear where you can make your changes. Click the green tick button or press "enter" to save.
Read MoreUser Guide
Adding a Filter
To add a filter you can either click the kebab menu (or press the / key) and select "Add Filter"
Read MoreUser Guide
Adding a pivot
To add a pivot you can either click the kebab menu (or press the / key) and select "Add Pivot"
Read MoreHow To
Instant Automatic Data Analysis
From detecting data types, to automatic binning, we explain the features that make AddMaple fast and easy to use
Read MoreHow To
How to analyze a survey
Generate interactive graphs from your raw survey data and embed them in a report
Read MoreFAQ
Which column types are detected?
AddMaple detects many different column types automatically including numbers, currency, dates, categories, etc.
Read MoreHow To
Filter your data
AddMaple supports powerful instant filters that are applied across your entire dataset. Filters can be applied directly from charts.
Read MoreHow To
Share a chart
How to share an embeddable chart from AddMaple
Read MoreHow To
Make your data explorable
How to let anyone explore your data using AddMaple. You can choose which columns to share and allow your colleagues or the whole world to explore your raw data.
Read MoreHow To
Analyze SAV or SPSS files
AddMaple is one of the few cloud based software tools that can read SPSS (or SAV) data files. They have an unusual format and can't be opened by standard spreadsheets.
Read MoreFAQ
Why do you use horizontal bar charts
AddMaple is designed to work with any data source - this includes data where column names or items of data may be long, or where there are many possible values for a column.
Read MoreGetting Started
Analyse Your Data From A File
AddMaple automatically analyses your data from a file and generates charts for you.
Read MoreFAQ
What is the largest file I can analyse?
AddMaple can read large data files - including files that will crash a spreadsheet. On a modern computer AddMaple can easily read in data files of up to 200MB...
Read More
Updated on 16/09/2024