function median(array $arr)
{
if (0 === count($arr)) {
return null;
}
// sort the data
$count = count($arr);
asort($arr);
// get the mid-point keys (1 or 2 of them)
$mid = floor(($count - 1) / 2);
$keys = array_slice(array_keys($arr), $mid, (1 === $count % 2 ? 1 : 2));
$sum = 0;
foreach ($keys as $key) {
$sum += $arr[$key];
}
return $sum / count($keys);
}
// print_r(median([1,2,3,4,5,6]);Report::whereRaw("'MONTH(created_at) = 1")->orderBy('created_at')->get()