Forum Discussion
Can you do Binomial Expansion on Excel
Essentially I want to expand this formula, a binomial expansion. I've researched for hours but nothing is relevant. Pls help (0.26117952+0.73882048x)(0.724381625+0.275618375x)(0.725834798+0.27416...
Enter the value of x in a cell, say in A2.
In another cell, say B2, enter the formula
=(0.26117952+0.73882048*A2)*(0.724381625+0.275618375*A2)*(0.725834798+0.274165202*A2)*(0.337253339+0.662746661*A2)*(0.243553009+0.756446991*A2)*(0.649350649+0.350649351*A2)*(0.569620253+0.430379747*A2)*(0.7767672+0.2232328*A2)
I want the answer to be in the form:
0.00074x^10 * 0.007x^9 * 0.04x^8 * .......
0.00074x^10 * 0.007x^9 * 0.04x^8 * .......
Try Mathlab or Mathematica...