# Calculating average power of a set of data

• kurt
In summary, there are two ways to calculate the average power of a group of people. The first way is to calculate the power of each individual, and the second way is to take the average of the masses. The first way is correct, but the second way is not really valid.
kurt
There are n people with masses mn . Each run up a given slope of height h in times tn. Gravitational accelartion, g, is constant.
Now there are 2 ways to calculate the average power of this group of people with 2 different results. The question is which way of calculating the average power (hence which result) is correct.
1st way: I calculate the power of each individual: Pn =mn g h/tn and take the average of these Pn. This is the average power of the group calculated using the first way: Pavg.1 = (P1 + P2 + P3 +…….+ Pn ) /n
2nd way: I take the average of n masses, mavg and the average of n times, tavg, then use the power formula and obtain the average power of the group using the second way: Pavg.2 =mavg g h/tavg .
When I do the two ways on the Excel I get slightly different results. Here is an example:
g (m/s2) h(m) m (kg) t (s) P=mgh/t (W)
9,81 2,24 51 7 7844,861
9,81 2,24 48 7 7383,398
9,81 2,24 46 4 4043,290
9,81 2,24 47 8 8262,374
9,81 2,24 51 5 5603,472
9,81 2,24 49 4 4306,982
9,81 2,24 50 6 6592,320
9,81 2,24 52 4 4570,675
9,81 2,24 54 7 8306,323
9,81 2,24 48 5 5273,856
9,81 2,24 47 8 8262,374
9,81 2,24 51 4 4482,778
6244,392 ←average of the individual powers
9,81 2,24 49,5 5,75 6254,464
average m average t power ↑ of averages

So which way (result) would be correct? By the way, plotting t against m and using the slope of the best fit line to calculate power is not appropriate here, as the slope comes out to be negative (-0.087) and the correlation is very weak (R2 = 0.017). I greatly appreciate your comments.

Your second method is not really valid. Just take a simple example of two runners who do it once, each. (nonsense values to make it obvious)
If one runner had mass 100kg and ran up 10m in 10s - power is mgh/t = 100*10*g/10 =100g
The next runner weighed 11kg and ran up 10m in 1s - power = 11*10*g/1 = 110g
Mean of those two values is 105g
taking both together, the power would be (by your calculation) 111*10 *g/11 =101g
The data is dominated by the larger value.

What you are dealing with is Harmonic Means (you are dealing with 1/t) and you need to be careful when they come into it.

There is a similar problem when working out average speeds around a circuit. If you move round a square course (side length d) with the speeds on each side being 1m/s, 2m/s, 3m/s and 4m/s and want to work out the average speed, the 'obvious' choice is to say (1+2+3+4)/4 = 2.5 but the real answer involves finding how long it takes actually to cover each side
t=d+d/2+d/3+d/4 =2.25d
then the speed is
4d/t = 1.78

In this case (and we know from experience) the distances traveled at slow speed will dominate the average speed. There is a limit to just how much you can 'make up', on the fast bits for the slow bits.
That's the Harmonic Mean for you! Watch out for it.

Does it make sense now?

Thank you for your follow up sophiecentaur. Rethinking about it, I got another reasoning out of your reminding me taking the average of velocities (or simply the average velocity). In calculating the average velocity of several known paths of d1 to dn with known times t1 to tn, but with unkown velocities on these paths, we divide the total displacement by the total time. v = Σd/Σt. This is the most general case of finding the average velocity for the whole path. Yes, with the unknown but equal distances taken with known velocities and known times, we get the harmonic mean of these known velocities. Similarly, as you know, if the times are equal on different length of paths then it will yield to the arithmetic mean of these given velocities.
It is exactly the same procedure with the densities of mixtures. Since both have the same type of formula: v = Σd/Σt for velocity and d = Σm/ΣV for density.
Now I see the same structure of formula for power: P = gh m/t. since gh is only a constant factor, it can be taken to unity, or to the left side. Then we would have P’ = m/t, which has the same form with m and t known parameters, and P (orP’) as unknown parameter, of which we seek the average. Since this looks like the most general case of velocities above, this leads me to apply the same procedure. i.e. Pavg = gh Σm /Σt .
I had not thought of this before your response. Thank you much for your time and thoughts.

## 1. What is the formula for calculating average power?

The formula for calculating average power is to divide the total power of all data points by the number of data points. The equation is: Average Power = Total Power / Number of Data Points.

## 2. How do I determine the total power of a set of data?

To determine the total power of a set of data, you need to add up all the power values of each data point. This can be done manually or by using a calculator.

## 3. Can I use any unit of measurement for power when calculating average power?

Yes, you can use any unit of measurement for power as long as all the data points are measured in the same unit. For example, if the data points are measured in watts, the total power and average power should also be in watts.

## 4. Is average power the same as peak power?

No, average power and peak power are different concepts. Average power is the average value of power over a period of time, while peak power is the maximum power value at any given moment.

## 5. Why is calculating average power important?

Calculating average power is important because it provides a more accurate representation of the overall power of a set of data. It can also be used to compare different sets of data and track changes in power over time.

Replies
3
Views
504
Replies
4
Views
1K
Replies
9
Views
1K
Replies
8
Views
9K
Replies
5
Views
7K
Replies
3
Views
2K
Replies
25
Views
8K
Replies
8
Views
2K
Replies
5
Views
1K
Replies
5
Views
3K