Posted by: R9
- Leader [02624472] Fri, Mar 04, 2005, 20:53
Say I have two columns, one for say, 10 pitcher's ERA's, and the other for their Innings Pitched. What I'm looking to do is come up with an average ERA, but based on their IP's of course. What formula would I use to do that?
1
Trip Sustainer
ID: 13961611 Fri, Mar 04, 2005, 21:17
Pitcher
IP
ERA
RUNS
Pitcher 1
30
3
10
Pitcher 2
40
4
17.77777778
Pitcher 3
50
5
27.77777778
Pitcher 4
50
5
27.77777778
Pitcher 5
40
4
17.77777778
Pitcher 6
30
3
10
Pitcher 7
30
3
10
Pitcher 8
40
4
17.77777778
Pitcher 9
50
5
27.77777778
Pitcher 10
60
6
40
Total ERA
420
206.6666667
4.428571429
Pitcher
IP
ERA
RUNS
Pitcher 1
30
3
=(B15/9)*C15
Pitcher 2
40
4
=(B16/9)*C16
Pitcher 3
50
5
=(B17/9)*C17
Pitcher 4
50
5
=(B18/9)*C18
Pitcher 5
40
4
=(B19/9)*C19
Pitcher 6
30
3
=(B20/9)*C20
Pitcher 7
30
3
=(B21/9)*C21
Pitcher 8
40
4
=(B22/9)*C22
Pitcher 9
50
5
=(B23/9)*C23
Pitcher 10
60
6
=(B24/9)*C24
Total ERA
420
=SUM(D15:D24)
=(D25/B25)*9
3
Guru
ID: 330592710 Fri, Mar 04, 2005, 22:21
You can also just take the weighted average of the ERAs, using IP as the weights.
In the example above, the formula for the average ERA is =SUMPRODUCT(B3:B12,C3:C12)/sum(B3:B12)