Hi all, trying to do it already for a while and need your help.
I have the following function
(1.96)*0.98^(C52-1) which results in 1.84473632 (C52 is for now the number 4).
how ever I would like to get the sum of the multiplications such as followed:
1.96 *1.9208**1.882384*1.84473632= 13.07316491
Can any1 please please help?
Welcome to the forum
I don't see any addition in there ...I would like to get the sum of the multiplications such as followed:
1.96 *1.9208**1.882384*1.84473632
Entia non sunt multiplicanda sine necessitate
Originally Posted by shg
Welcome to the forum
I don't see any addition in there ...
well I guess I explained it a bit wrong, here we go again
Assuming the following function : (1.96)*0.98^(C52-1)
possible results (if C52 is 4) is:
first 1.96 (power ^0)
then 1.9208 (power (^1)
then 1.882384 (^2)
then 1.84473632 (^3)
I would like to get them multiplied so cell A1 (for example) will be ,13.07316491
1.96 *1.9208*1.882384*1.84473632= 13.07316491
This one is tricky. Google into rising factorial polynomials, you might get some answers like that and if you find a simplified algebraic expression, plug it into excel... Best I can do...well I guess I explained it a bit wrong, here we go again
Assuming the following function : (1.96)*0.98^(C52-1)
possible results (if C52 is 4) is:
first 1.96 (power ^0)
then 1.9208 (power (^1)
then 1.882384 (^2)
then 1.84473632 (^3)
I would like to get them multiplied so cell A1 (for example) will be ,13.07316491
1.96 *1.9208*1.882384*1.84473632= 13.07316491
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
The formula in B1 MUST be confirmed with Ctrl+Shift+Enter; that's what makes the curly braces appear.
Please Login or Register to view this content.
=1.96^B12*0.98^(((B12-1)^2+B12-1)/2)
Since you have
1.96x0.98^0* 1.96*0.98^1 .....
it can be simplified to
1.96^n x (0.98 ^ sum(1...n))
since sum 1...n = (n^2+n)/2
we can simplify to
1.96^n * ((n^2+n)/2)
or 1.96^2 /2 *(n^2+n)
Last edited by squiggler47; 10-19-2010 at 02:14 PM. Reason: Edited formula
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Or even :-
=EXP(1)^(0.683045826901185*C52-0.0101013536587597*C52^2)
When I place, "=PRODUCT(1.96*0.98^(ROW(INDIRECT("1:" & A1)) - 1))" in B1, it stays on 1.96... :SThe formula in B1 MUST be confirmed with Ctrl+Shift+Enter; that's what makes the curly braces appear.Please Login or Register to view this content.
Worked like a charm... thanks
I agree with Squiggler that the formula can be simplified, but not with his result, I think ...
Please Login or Register to view this content.
@SHG
Running your simplification yields :-
(=1.96^B12*((B12^2-B12)/2)) 88.54734336
whereas :-
{=PRODUCT(1.96*0.98^(ROW(INDIRECT("1:" & B12)) - 1))}
=1.96^B12*0.98^(((B12-1)^2+B12-1)/2)
=EXP(1)^(0.683045826901185*B12-0.0101013536587597*B12^2)
all give the correct result of 13.xxxxxxxxx
i would never actually use the last one personally as it doesnt lend its self to change if the values change!
I think somewhere this would lend its self to a financial function FV perhaps, perhaps if there was more background on what the formula was supposed to do!
The formula shown gives the result shown, Squiggler. I just copied it from the workbook.
hehe, you guys are great I have one more question so i'll keep it in this topic instead of making a new one.
I have the following formula:
= ((30+p/1000+g)(1+m/20)t-2n(n+4))(1+h/100))
Each Variable, is located in a different cell...
Is there a way in excel, to make a graph which illustrate this formula?
Different question, needs a different thread, you wont get any replies and probably will get an infraction from the moderators!
Sorry didn't mean to go against the rules....
I have opened a new topic...
http://www.excelforum.com/excel-gene...ml#post2403931
How do I change this topic to "solved"?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks