ExcelBanter - How to get average with deviation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to get average with deviation (https://www.excelbanter.com/excel-programming/295068-how-get-average-deviation.html)

brown6k

How to get average with deviation

I have a series (l) of curves with data format,

Xa1 Ya1 Xb1 Yb1 ...... Xl1 Yl1
Xa2 Ya2 Xb2 Yb2 ...... Xl1 Yl2
.................
.................
.................
Xan Yan Xbn Ybn ...... Xln Yln

How can I get an average line with deviation ?

Xavg1 Yavg1 Dev1
Xavg2 Yavg2 Dev2
..........
..........
Xavgn Yavgn Devn

Note: Xa(i) =/= Xb(i), Ya(j) =/= Yb(j), i,j=1,n

JWolf

How to get average with deviation

Look at LINEST_worksheet_function in help and also see:
http://www.stfx.ca/people/bliengme/E...Polynomial.htm

brown6k wrote:
I have a series (l) of curves with data format,

Xa1 Ya1 Xb1 Yb1 ...... Xl1 Yl1
Xa2 Ya2 Xb2 Yb2 ...... Xl1 Yl2
................
................
................
Xan Yan Xbn Ybn ...... Xln Yln

How can I get an average line with deviation ?

Xavg1 Yavg1 Dev1
Xavg2 Yavg2 Dev2
.........
.........
Xavgn Yavgn Devn

Note: Xa(i) =/= Xb(i), Ya(j) =/= Yb(j), i,j=1,n

All times are GMT +1. The time now is 07:58 PM.