calculate_advanced_average