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.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s