Want average formula. "Cactus" <li.zhang.home [at] 163 [dot] com> 19.08.2006 16:26:28 I want to make this symmetry curve more smooth. these pair is 0 and 27, 1 and 26, 2 and 25, 3 and 24.........etc. the highest of curve is on center, and the lowest of curve is on two side. i try take pair points on two side, averages to a new point. it will be a smooth symmetry curve. how i do it by formula? thanks. 0 0 1 0.001724138 2 0.005172414 3 0.006896552 4 0.017241379 5 0.027586207 6 0.027586207 7 0.046551724 8 0.043103448 9 0.067241379 10 0.056896552 11 0.075862069 12 0.051724138 13 0.081034483 14 0.081034483 15 0.084482759 16 0.060344828 17 0.055172414 18 0.053448276 19 0.04137931 20 0.034482759 21 0.013793103 22 0.036206897 23 0.012068966 24 0.012068966 25 0 26 0.005172414 27 0.001724138

Re: Want average formula. "Bob Phillips" <bob.NGs[ at ]somewhere.com> 19.08.2006 19:37:56 sELECT e1:E14, and in the formula bar enter =(INDEX(B1:B28,LARGE(ROW(A1:A28),ROW(INDIRECT("1:"&COUNT(A1:A28)/2))))+INDEX (B1:B28,SMALL(ROW(A1:A28),ROW(INDIRECT("1:"&COUNT(A1:A28)/2)))))/2 which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Cactus" <li.zhang.home [at] 163 [dot] com> wrote in message news:e2XeUx6wGHA.4576[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > I want to make this symmetry curve more smooth. > these pair is 0 and 27, 1 and 26, 2 and 25, 3 and 24.........etc. > the highest of curve is on center, and the lowest of curve is on two side. > > i try take pair points on two side, averages to a new point. it will be a > smooth symmetry curve. > > how i do it by formula? > > thanks. > > > 0 0 > 1 0.001724138 > 2 0.005172414 > 3 0.006896552 > 4 0.017241379 > 5 0.027586207 > 6 0.027586207 > 7 0.046551724 > 8 0.043103448 > 9 0.067241379 > 10 0.056896552 > 11 0.075862069 > 12 0.051724138 > 13 0.081034483 > 14 0.081034483 > 15 0.084482759 > 16 0.060344828 > 17 0.055172414 > 18 0.053448276 > 19 0.04137931 > 20 0.034482759 > 21 0.013793103 > 22 0.036206897 > 23 0.012068966 > 24 0.012068966 > 25 0 > 26 0.005172414 > 27 0.001724138 >

Re: Want average formula. "Cactus" <li.zhang.home [at] 163 [dot] com> 20.08.2006 01:08:12 Bob your formula could not work. anyway, thanks your help.. i use VBA macro. Option Explicit Public Function SymmetrySmooth(aIndex As Long, aRange As Range) As Variant SymmetrySmooth = (aRange(aIndex) + aRange(aRange.Count - aIndex + 1)) / 2 End Function "Bob Phillips" <bob.NGs[ at ]somewhere.com> [Quoted Text] > > =(INDEX(B1:B28,LARGE(ROW(A1:A28),ROW(INDIRECT("1:"&COUNT(A1:A28)/2))))+INDEX > (B1:B28,SMALL(ROW(A1:A28),ROW(INDIRECT("1:"&COUNT(A1:A28)/2)))))/2 > > which is an array formula, it should be committed with Ctrl-Shift-Enter, not > just Enter. > > -- > HTH > > Bob Phillips > > (replace somewhere in email address with gmail if mailing direct) > > "Cactus" <li.zhang.home [at] 163 [dot] com> wrote in message > news:e2XeUx6wGHA.4576[ at ]TK2MSFTNGP03.phx.gbl... > > I want to make this symmetry curve more smooth. > > these pair is 0 and 27, 1 and 26, 2 and 25, 3 and 24.........etc. > > the highest of curve is on center, and the lowest of curve is on two > side. > > > > i try take pair points on two side, averages to a new point. it will be a > > smooth symmetry curve. > > > > how i do it by formula? > > > > thanks. > > > > > > 0 0 > > 1 0.001724138 > > 2 0.005172414 > > 3 0.006896552 > > 4 0.017241379 > > 5 0.027586207 > > 6 0.027586207 > > 7 0.046551724 > > 8 0.043103448 > > 9 0.067241379 > > 10 0.056896552 > > 11 0.075862069 > > 12 0.051724138 > > 13 0.081034483 > > 14 0.081034483 > > 15 0.084482759 > > 16 0.060344828 > > 17 0.055172414 > > 18 0.053448276 > > 19 0.04137931 > > 20 0.034482759 > > 21 0.013793103 > > 22 0.036206897 > > 23 0.012068966 > > 24 0.012068966 > > 25 0 > > 26 0.005172414 > > 27 0.001724138 > > > >

Re: Want average formula. "Bob Phillips" <bob.NGs[ at ]somewhere.com> 20.08.2006 11:09:43 Could not? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Cactus" <li.zhang.home [at] 163 [dot] com> wrote in message news:%23DP9qU$wGHA.4200[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Bob > > your formula could not work. > > anyway, thanks your help.. > > i use VBA macro. > > Option Explicit > > Public Function SymmetrySmooth(aIndex As Long, aRange As Range) As Variant > SymmetrySmooth = (aRange(aIndex) + aRange(aRange.Count - aIndex + 1)) / > 2 > End Function > > > "Bob Phillips" <bob.NGs[ at ]somewhere.com> > > > > > =(INDEX(B1:B28,LARGE(ROW(A1:A28),ROW(INDIRECT("1:"&COUNT(A1:A28)/2))))+INDEX > > (B1:B28,SMALL(ROW(A1:A28),ROW(INDIRECT("1:"&COUNT(A1:A28)/2)))))/2 > > > > which is an array formula, it should be committed with Ctrl-Shift-Enter, > not > > just Enter. > > > > -- > > HTH > > > > Bob Phillips > > > > (replace somewhere in email address with gmail if mailing direct) > > > > "Cactus" <li.zhang.home [at] 163 [dot] com> wrote in message > > news:e2XeUx6wGHA.4576[ at ]TK2MSFTNGP03.phx.gbl... > > > I want to make this symmetry curve more smooth. > > > these pair is 0 and 27, 1 and 26, 2 and 25, 3 and 24.........etc. > > > the highest of curve is on center, and the lowest of curve is on two > > side. > > > > > > i try take pair points on two side, averages to a new point. it will be > a > > > smooth symmetry curve. > > > > > > how i do it by formula? > > > > > > thanks. > > > > > > > > > 0 0 > > > 1 0.001724138 > > > 2 0.005172414 > > > 3 0.006896552 > > > 4 0.017241379 > > > 5 0.027586207 > > > 6 0.027586207 > > > 7 0.046551724 > > > 8 0.043103448 > > > 9 0.067241379 > > > 10 0.056896552 > > > 11 0.075862069 > > > 12 0.051724138 > > > 13 0.081034483 > > > 14 0.081034483 > > > 15 0.084482759 > > > 16 0.060344828 > > > 17 0.055172414 > > > 18 0.053448276 > > > 19 0.04137931 > > > 20 0.034482759 > > > 21 0.013793103 > > > 22 0.036206897 > > > 23 0.012068966 > > > 24 0.012068966 > > > 25 0 > > > 26 0.005172414 > > > 27 0.001724138 > > > > > > > >

Re: Want average formula. "Cactus" <li.zhang.home [at] 163 [dot] com> 20.08.2006 12:44:09 Maybe.....i can not understand that formula. "Bob Phillips" [Quoted Text] > Could not? >

Re: Want average formula. "Bob Phillips" <bob.NGs[ at ]somewhere.com> 21.08.2006 14:00:38 Did you try? If so, what did you get? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Cactus" <li.zhang.home [at] 163 [dot] com> wrote in message news:OGp4aZFxGHA.4476[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > Maybe.....i can not understand that formula. > > > > "Bob Phillips" > > Could not? > > >