Want average formula.

[Cactus]

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

 

[Bob Phillips]

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]

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]

Could not?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Cactus]

Maybe.....i can not understand that formula.



"Bob Phillips"

 

[Bob Phillips]

Did you try? If so, what did you get?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)