InfoPath Dev

Basically I created a survey. 12 repeating tables with a number of questions in each one. Option button for 1-7 each table has an Ceiling Avg in the footer. How can I calculate the Overall choice? Put all the numbers in the footer in order and pick out the middle.

Median and mode are certainly more involved than mean, but I've found a codeless way to do them. Please have a look at the attached form.

This will work but my next question is. I have 12 repeating tables with an Average in the footer. How can I take each avg from the footer and input into this repeating table to apply these functions? Trying to avoid qRules as it doesn't currently work in the browser on o365.

Could you explain what you want to do a little more clearly?  Do you want averages for each of the tables?  Or one set of averages combining all of the repeating tables?  Or a repeating table with averages in it?

Each repeating table has an average in the footer. How can I take all the averages and input them into another repeating table to perform the calculations of the example.