What is the easiest way to enter a multiple choice question, and a secondary question that apportions a percentage to each answer?
So for example we ask which Tree Species are found in the sample ?( answer(s) from drop -down) and then to allocate a % of the sample to each species that occurs?
Thanks
If the goal is to calculate the percentage based on previous responses during the data collection process, unfortunately, that is not feasible.
However, one approach would be to perform this calculation during post-processing using tools like Excel or similar software.
However, if you are looking to show different questions based on the response of a previous one, look at the dependent dropdown approach based on jumps (if-else) →
The task requires recording the distribution percent for each item in a possible list of 30 items.
The recommended solution outlined previously using jumps works but it is a very tedious method. For example if there only 2 items present that would involve 28 jumps.
Is there another less difficult method?
A more streamlined and less labor-intensive approach is to handle this calculation during post-processing, using tools like Excel or similar spreadsheet software. Here’s why:
- Data Export: Epicollect5 allows for easy data export in CSV format, which can be opened in Excel or other similar tools. Once you have your data exported, you can quickly calculate the distribution percentages for each item using formulas or pivot tables in Excel.
- Automation in Excel: You can automate the calculation of percentages using simple formulas. For instance, you can sum up the counts for each item and then calculate the percentage distribution for each item by dividing the item count by the total count.
- Irrelevance During Data Collection: Knowing the distribution while collecting the data might not be critical unless there’s an immediate need for that information in the field. The more important aspect is to ensure accurate data entry, and once the data is collected, the distribution can easily be computed. This prevents cluttering the data collection form with unnecessary jumps or manual calculations, which could slow down the data collection process and lead to potential errors.
- Flexibility: In Excel, the post-processing method provides far greater flexibility. You can adjust or update the calculations as needed, add new items, or filter the data without needing to go back and modify the original form structure in Epicollect5.
By focusing on post-processing, you avoid the complexity of setting up intricate form logic during data collection, allowing you to collect data efficiently and then perform the necessary calculations with ease later on. This approach also simplifies the form design and reduces the potential for user error.