@ycampos , @Deepak ‘s post will be helpful for you. Here is one other approach you can take:
-
Create a new question and select "Multiple Choice" as the question type.
-
In the question text, ask the participants to indicate their height (in feet and inches) and weight (in pounds). For example, you can use the following question text: "Please enter your height (in feet and inches) and weight (in pounds):"
-
In the answer options, create two text entry boxes, one for height and one for weight. To do this, select "Add New Choice" and then select "Text Entry" as the choice type. Repeat this step to add a second text entry box for weight.
-
Next, create an embedded data field to calculate the BMI. To do this, click on "Add Embedded Data" under the "Advanced Options" section.
-
In the embedded data field, enter a name for the field (e.g., "BMI") and then use the following formula to calculate the BMI:
(${q1://QR/Height in feet}12 + ${q1://QR/Height in inches}) / ((${q1://QR/Weight})(${q1://QR/Weight})) * 703
Make sure to replace "Height in feet," "Height in inches," and "Weight" with the corresponding values from the text entry boxes you created in step 3.
- Finally, use display logic to show the BMI question only if both the height and weight values have been entered. To do this, click on "Add Display Logic" and set the logic to show the question only if both the height and weight values are not empty.
Once you've completed these steps, participants will be able to enter their height and weight, and the BMI will be automatically calculated and stored in the embedded data field you created. You can then use this data for further analysis in Qualtrics or export it to another program like Excel.
Good luck!
Can someone just tell me EXACTLY how to have Qualtrics automatically calculate BMI for survey-takers during a health screening? I’m a Qualtrics beginner and I can’t seem to find a straight answer how to do this. Video links would be awesome if available.