calculations on multiple rows from mysql database

I have an API that allows a user to select a set of rows from a table in my database. Once the rows are filtered to the users liking I need to perform several calculations on each column to output a table based on the specific selected rows from the table.

if the users select rows A, B, C, D. each row has columns X, Y, and Z i need to calculate the Average, Standard Deviation and a few more calculations based upon this subset of data. So i can Output

the averages of X the St Dev of X

the average of Y the St Dev of Y

the avg of Z the St Dev of Z

Laravel Application.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2zA8pEc
via IFTTT