How does OfficeReports Analytics work?

All the survey data analysis functionality you need as a researcher is available from the OfficeReports ribbon in Excel. On this page we will go through the complete process from import and recoding the variables to creating the tables and charts. Please have a look at the videos below.

video

Importing Data

Before we can start creating tables, we have to import the survey data. OfficeReports can import data from SPSS, Triple-S, Excel, CSV, SurveyMonkey and SurveyGizmo. We advise not to use Excel or CSV, because data in these formats does not contain as much information as the other formats. Excel/CSV does not contain any order of Answer Choices (Categories), nor can Answer Choices be a value with a label. Here we will shaow how to import SPSS data.

NB: You do not need to have SPSS installed to import a SPSS sav-file!

NB: OfficeReports also imports SPSS 'Group' definitions!

video

Recoding the Variables

Almost every time you will need to 'recode' some of you variables. Maybe you need to convert a Numerical variable to a Categorical variable, or the othert way around. Maybe you want to change a Likert scale from 7 options to 5 options. Maybe you want to 'group' some variables because they all together represent a multiple question. Maybe you automatically want to transform numerical or categorical NPS values to promoters, passives and detractors. Maybe you want top combine some variables. Maybe you want to create dreived variables using a formula. Etc.

video

Standard Analytics Report

Creating an 'Analytics Report' would be a good way to start analyzing your data. The 'Analytics report' feature in OfficeReports makes it very easy and fast to create a report containing crosstabs of all relevant variables crossed by e.g. some demographic variables, including both T-Test and Z-Test comparing all columns to each other. Within 1-2 minutes, this report is both defined and generated! This report can very well be one of the standard reports you deliver to your customer as well.

Statistics.png

Significance, weighting and correlation

Significance calculation and visualization is quite important for reporting most surveys. OfficeReports has functionality for Z-Test and T-Test (Student and Welch) with options for using effective base or unweighted base and compensation for overlap. You can define which columns you want to compare, and in case you compare pairwise, OfficeReports can visualize significance changing the cell background color, instead of adding significance characters. This is very important when we want to visualize significance using arrows in PowerPoint. Besides being able to calculate significance for 2 defined levels at the same time, OfficeReports can also add characters for 'low base' and 'insufficient base'.

Besides significance calculation, OfficeReports can weight the data behind the tables and charts. You can either specify you want to use an (imported) numerical variable for the weighting, or you can create a 'weight variable'. When using OfficeReports to create the weight variable, you can specify weight values for multiple dimensions, and OfficeReports will use the RIM weighting algorithm to calculate the weight for each respondent.

The last statistics feature we want to mention is correlation. When defining a 'grid' table, it is possible to show the Pearson correlation, including significance.

video

Copy a worksheet

Often we need to duplicate a group of tables and charts just because we need them again calculated with a different filter. To save time, OfficeReports has made it possible to copy a worksheet, and then define a new filter for all tables and charts on the copied sheet. Please have a look at this video.

video

Sorting

You can sort tables and charts on any row and column. Both at the same time, off course.

In Excel, it is even possible to sort a table 'like another table', which in our experience is very important in many reports. Please have a look at the video.

Learn more about OfficeReports