Calculate mean by group.

[daviduehlinger]

Hi all.

This is my problem… I have two columns with numeric values (Wind Speed [Integer], and Power [Double]).

I need to calculate the mean of Power, grouping by Wind Speed.

Example:

Wind Speed ----- Power
5 ------> 10
8 ------> 15
5 ------> 9
7 ------> 11
3 ------> 6
5 ------> 13
8 ------> 12

The result must be:

Wind Speed Power (Mean)
5 10.66
8 13.5
7 11
3 6

Thanz in advance.

[izaychik63]

Use Group by node grouping by Wind Speed and calculating mean on Power column.

[daviduehlinger]

Thankz @izaychik63 !!!.. Solved