questfox server now operating on german premises

The GDPR rules are already implemented into questfox for years. But still more and more german clients ask about the server infrastructure as they need to include this into their contracts.

From today on questfox.com is running on a Microsoft Azure server system located inside of Germany.
It does not change anything for the user, but for some people it just feels better. 😉

Independent from this step we continue to be devoted to the highest standards of data security. After 15 years of operating the questfox system we know that the user itself is the risk category no. 1. So keep your passwords secure and never share your logins with anyone.


NEW Maths function in questfox

Mathematics is clearly defined for centuries now. questfox is offering you a set of mathematical operations since the beginning of our development from the standard toolbox of database manipulation.

See our special questfox functions under https://questfox.news/2021/03/08/how-to-calculate-with-missing-values-in-questfox/

Besides those questfox specific procedures we are using a bunch of functions to interact with mathematics. The Jace.NET framework is now used to support your calculation inside of questfox. More info under https://github.com/pieterderycke/Jace/wiki/Standard-Functions

Here is the list of functions so far to be used inside of questfox calculations.

FunctionArgumentsDescriptionMore Information
sinsin(A1)Sinehttp://en.wikipedia.org/wiki/Sine
coscos(A1)Cosinehttp://en.wikipedia.org/wiki/Trigonometric_functions
asinasin(A1)Arcsinehttp://en.wikipedia.org/wiki/Inverse_trigonometric_functions
acosacos(A1)Arccosinehttp://en.wikipedia.org/wiki/Inverse_trigonometric_functions
tantan(A1)Tangenthttp://en.wikipedia.org/wiki/Trigonometric_functions
cotcot(A1)Cotangenthttp://en.wikipedia.org/wiki/Trigonometric_functions
atanatan(A1)Arctangenthttp://en.wikipedia.org/wiki/Inverse_trigonometric_functions
acotacot(A1)Arccotangenthttp://en.wikipedia.org/wiki/Inverse_trigonometric_functions
logeloge(A1)Natural Logarithmhttp://en.wikipedia.org/wiki/Logarithm
log10log10(A1)Common Logarithmhttp://en.wikipedia.org/wiki/Logarithm
lognlogn(A1, A2)Logarithmhttp://en.wikipedia.org/wiki/Logarithm
sqrtsqrt(A1)Square Roothttp://en.wikipedia.org/wiki/Square_root
ifif(A1, A2, A3)If FunctionIF A1 IS true THEN A2 ELSE A3
maxmax(A1, …, An)Maximum 
minmin(A1, …, An)Minimum 
avgavg(A1, …, An)Average 
medianmedian(A1, …, An)Median 
roundround(A1)Round 
randomrandom()RandomGenerate a random double value between 0.0 and 1.0

What do you have to do?

ln-Funktion, Gesetze und Regeln

Syntax check from ln to loge

Please check your questfox project for the correctness of the syntax. For example: The formerly implemented function ln is now called loge. You now need to switch to this new version in order to perform those calculations in the future with questfox.


How to calculate with missing values in questfox

We are also adding functions to this world of math by creating our own formula for the market research world being able to create a sum or an average respecting the fact, that someone did not see or answer a question. Our operations for the so called “missing values” help you to analyze correctly long before you can do similiar things with sophisticated tools like SPSS. See our idea of how to treat missing values https://questfox.news/2021/03/08/missing-values-in-market-research-with-questfox/

When you then want to calculate with a variable that contains “missing values” you will face trouble in the analysis. questfox has two special functions to take that into account.

The syntax is described here

qf_avg()Returns the average value of the input values (seperated by comma) and excludes missing, not seen and not answered values.
qf_avg(@81c4af14-4857-49b8-9dd7-449b33e73e60@ , @7151c6d2-48af-4619-8318-39b62aa99b07@)
qf_sum()Returns the sum of the input values (seperated by comma) and excludes missing, not seen and not answered values.
qf_sum(@81c4af14-4857-49b8-9dd7-449b33e73e60@ , @7151c6d2-48af-4619-8318-39b62aa99b07@)
Calculations with missing values.
Live Calculation in questfox

We suggest to ad an invisible number inside the questionpage and calculate right into that hidden variable. You can later use this value as a trigger for questlogix or to show this value live to the respondent.


Missing values in market research with questfox

The phenomenon is not recent. People do not answer to questions. If someone does not answer to a question we are talking about so called missing values.

Also see the Wikipedia article: https://en.wikipedia.org/wiki/Missing_data

questfox knows 3 different kinds of missing values.

Missing value -99

someone clicked explicitly on “no answer”

Missing value -77

the question was not even shown to the repsondent (due to skipping/hiding procedures)

Missing value -88

classic missing value meaning the question was shown, but the answer was not mandatory so the respondent could click through

A good idea is to make someone click on each question, but this means that you will have to add the option “no answer / do not want to tell” to every answer where you require a mandatory click. Even if you do some of the questions or items will not be shown and therefore create a Missing value (-77).

Why is it negative with two digits in questfox?
The answer is pretty simple. If you use a scale from 1 to 5 and your default missing value is 9 (as some of us learned in their statistics class), you may not realize that you have an issue with missing values in your report. In the questfox default you would easily see that something is wrong in your definition of missing values.

These three default values are assigned to every question type and can be changed under “Define Missing Values” in the edit answer section.

3 types of missing values in online research

When using SPSS these values can be defined as discrete missing values.

Discrete missing values in SPSS

Now it is up to you if you can force your population into answering all the questions.


questfox maintenance 1st of March 2021

The world is turning faster than ever. In order to cope with this we have to work on our servers as of today the 1st of march 2021.

The servers are still available but some data intensive services like export or analysis may make you wait longer than normally.

Sorry, for any inconvenience but you will feel a more powerful version of questfox after the maintenance procedures.