The JSON data contains the answers from three users:
[{"id":"1","user":"001","answer":"1,1,3,2,2,1,3,2"},
{"id":"2","user":"002","answer":"2,3,3,2,1,1,3,2"},
{"id":"3","user":"003","answer":"3,5,3,5,3,1,3,2"}]
To process this data using JavaScript and jQuery:
jQuery.ajax({
url: "file.json",
type: "POST",
dataType: "json",
async: false,
success: function (data) {
var averages = [];
for (i = 0; i < data.length; i++) {
var sum = data[i].answer.split(',').reduce((acc, curr) => acc + parseInt(curr), 0);
var average = sum / data[i].answer.split(',').length;
averages.push(average);
}
console.log(averages);
});
This will calculate the average for each set of answers, resulting in these 8 average values:
2,3,3,3,2,1,3,2