When I try to verify the correctness of a sequence. I need to compute the following fomula
=-1*((0.4^4-3*(0.4^3)+0.4^2)*10+(0.4^3-2*(0.4^2))*15+(0.4^2-0.4)*20+0.4*25+30)+100*(0.4^4-2*(0.4^3)+1)+50*(-0.4^4+2*(0.4^3))
Excel gives 66.144. I takes me more an hour to debug. Finally I find it is not my fault
But google gives 63.58400
Actually google gives the correct result.
How can I trust excel anymore?
I still remember two year before Excel can generate negative number from [0,1] random variable. Luckly I get the patch to fix it. This time, I don't how I should do.
No comments:
Post a Comment