Remove the Max/Min From Array, Take Average, Output Average

Question

<?php 
$url = 'https://www.googleapis.com/shopping/search/v1/public/products?key=thekey&country=US&q=nintendo+wii';

$data = curl_init($url);
curl_setopt($data, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($data, CURLOPT_HEADER, 0);

$product_result = curl_exec($data);
curl_close($data);


$arr = json_decode($product_result, true);
$prices = array();

echo "Original Values";

foreach ($arr['items'] as $item)
{
    if (isset($item['product']['inventories'][0]['price']))
    {
        $prices[] = $item['product']['inventories'][0]['price'];
    }
}


echo '<pre>';
print_r($prices);
echo '<br /><br />';

// Get the values
$min = $prices[$minIndex];
$max = $prices[$maxIndex];

// Find the values
$minIndex = array_search($min, $prices);
$maxIndex = array_search($max, $prices);

#print out results with no min/max pair
echo $prices[$min] . 'max is ' . $prices[$max];
echo '</pre>';
// Unset the values
unset($prices[$minIndex], $prices[$maxIndex]);
?>

I have the following code, and currently its outputting: Original Values

Array
(
    [0] => 199.95
    [1] => 149.99
    [2] => 129.99
    [3] => 149.99
    [4] => 149.99
    [5] => 124.99
    [6] => 225.99
    [7] => 149.96
    [8] => 149.99
    [9] => 149.99
    [10] => 184.99
    [11] => 199.99
    [12] => 184.98
    [13] => 149.99
    [14] => 326.99
    [15] => 269.96
    [16] => 348.95
    [17] => 108.9
    [18] => 149.99
    [19] => 149.99
    [20] => 229.99
    [21] => 357.38
    [22] => 169.96
    [23] => 229.98
    [24] => 187.99
)


max is

It should be removing the array key [21] and [17] since they arethe max and min. then taking the average WITHOUT these two values and displaying it.

How do I get this to do this?

You asked this basic question already, and it has a number of answers: stackoverflow.com/questions/8468871/… — Jon Egeland
– Jon Egeland, Commented Dec 15, 2011 at 2:35

hakre · Accepted Answer · 2011-12-15 12:59:36Z

9

sort the array (sort)
remove the first element (array_shift)
remove the last element (array_pop)
create the sum of the remaining array (array_sum)
divide the sum with the number of elements in the remaining array (count).

Code example:

sort($prices, SORT_NUMERIC);
array_shift($prices);
array_pop($prices);
$sum = array_sum($prices);
$average = $sum / count($prices);

edited Dec 15, 2011 at 12:59

answered Dec 15, 2011 at 2:33

hakre

200k55 gold badges454 silver badges868 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Yo Bro Over a year ago

Thanks for the steps. How do I go about sorting based on value though. The us.php.net/sort link you gave me shows examples of sorting alphabetically, but not numerically.

hakre Over a year ago

You can use the SORT_NUMERIC flag for that. I added a code example that shows it.

Yo Bro Over a year ago

Hakre, appreciated! Thank you.

Michael Robinson · Accepted Answer · 2011-12-15 19:41:21Z

4

You could use sort, array_shift, and array_pop

sort($prices); // Sort the array from lowest to highest value
array_pop($prices); // Remove the max value. Use $max = array_pop($prices); if you want to use the value
array_shift($prices); // Remove the min value. Use $min = array_shift($prices); if you want to use the value

echo array_sum($prices)/count($prices); // Echo the average without $max or $min

edited Dec 15, 2011 at 19:41

answered Dec 15, 2011 at 2:33

Michael Robinson

29.6k12 gold badges109 silver badges131 bronze badges

1 Comment

hakre Over a year ago

Where is array_average defined?

Mitchell Layzell · Accepted Answer · 2017-10-31 06:56:13Z

-1

You could also use array_sum, max, min and count

echo (array_sum($prices) - max($prices) - min($array)) / count($prices);

answered Oct 31, 2017 at 6:56

Mitchell Layzell

3,0683 gold badges23 silver badges34 bronze badges

1 Comment

mickmackusa Over a year ago

This answer is inaccurate/incorrect because the original count is used for the averaging (the min and max elements are not "removed").

Collectives™ on Stack Overflow

Remove the Max/Min From Array, Take Average, Output Average

3 Answers 3

3 Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related