How to Calculate Column Average in Laravel Collection?

Hello Friends,

In this example, I will show you how to calculate column average in laravel collection. if you want to see a sample of the laravel collection calculate the column average then you are in the right place. let’s discuss calculating column average in the laravel collection. it's a simple example of laravel collection calculating the average column example. Follow the below step to get the average of column values in laravel.

You can use this example with the versions of laravel 6, laravel 7, laravel 8, and laravel 9.

You have just to follow the below step and you will get the layout as below:

Step 1: Install Laravel

This is optional; however, if you have not created the laravel app, then you may go ahead and execute the below command:

composer create-project laravel/laravel example-app

Step 2: Create Format Route

web.php

<?php

use Illuminate\Support\Facades\Route;
use App\Http\Controllers\FindAvgController;

/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/

Route::get('/index',[FindAvgController::class, 'index']);

Step 3: create FindAvgController

we will create FindAvgController. so you can see the below code with output:

php artisan make:controller FindAvgController

App\Http\Controllers\FindAvgController

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class FindAvgController extends Controller
{
    /**
     * The attributes that are mass assignable.
     *
     * @var array
    */
    public function index()
    {
        $data = [
            ["price" => 35],
            ["price" => 16],
            ["price" => 47]
        ];

       dd(collect($data)->average('price'));
            
    }
}

Step 4: Start Development Server

Start the development server. Use the PHP artisan serve command and start your server:

php artisan serve

Now you are ready to run our example so run the below command to quick run.

http://localhost:8000/index

Output:

32.666666666667 // app/Http/Controllers/FindAvgController.php:22

I hope it can help you...