Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Standard Deviation | Excel Discussion (Misc queries) | |||
Average & Deviation | Excel Worksheet Functions | |||
Standard deviation | Excel Discussion (Misc queries) | |||
Weighted Average Standard Deviation | Excel Worksheet Functions | |||
Histrogramms: Calculating average and standard deviation | Excel Worksheet Functions |