How to Calculate Column Average in Laravel Collection?

Teams applying “How to Calculate Column Average in Laravel Collection?” in a production project can use the product resource to record implementation, review and debugging time, then compare that effort with tests and shipped functionality instead of treating activity as performance by itself.

Before copying the example into a live application, confirm version-specific behaviour with the official Laravel website and test it against the project’s actual database and runtime.

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