# Formula in Excel

I would like to know how to express this formula using Excel

And Applied it  on this table :

``````N             X                  Formulatvalue
1            50
2            7
3            10
4            20
5            30
6            4
``````
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Finance AnalystCommented:
Does that formula have a name? There might be a function already built to deal with it.

Thanks
Rob H
Author Commented:
Nop it doesn't have a name
Finance AnalystCommented:
Might be worth explaining what the intention/result of the formula is then so that other experts with more mathematical knowledge would recognise it.

Thanks
Rob H
Commented:
Hi,

You also don't define wi

Regards
Author Commented:
the intention of the formulation is predicting the value X at Step N depending on the previous values of X ,by applying a sort of exponential weighted Average

foR EXEMPLE at the step N=2 and the weight w=0.03 the Formulavalue = 7 e^((0.03)*1)+50e((0.03)*0)/(e^((0.03)*1) +1)
Commented:
pls see my try on your data

Regards
EE20150807.xlsx
Finance AnalystCommented:
By puttibg the formula as above, yiu can replace the variables with cell references so should answer your question.

Experts Exchange Solution brought to you by