I know there are example spreadsheets online, but I look at the formulas and don't quite understand what is going on.

I know the formula for Simpson's Rule but I don't know how to implement it in Excel. Can someone explain how to do this?

I believe I would only need 3 columns (x, y, area). However, perhaps I need to include two more columns (n, h). I'm just not sure at the moment.

**What I've tried.**

Equation: y = 100x * sqrt(125-x^3) from 0 to 5

I create a spread-sheet with the following columns

x | y | area

I then have 6 rows for all values and a 7th row for the summation.

- First row for x = 0, second row increments by 1 all the way up to 5.
- First row for y is the x value plugged into the equation
- First row for area = the first row in y
- Second row for area = 4 * second row in y
- Third row for area = 2 * third row in y
- Fourth row for area = 4 * fourth row in y
- Fifth row for area = 4 * fifth row in y
- Sixth row for area = sixth row in y

- Seventh row adds all the areas above and multiplies it by (1/3) and also by the change in x which is (b-a)/6 or numerically 5/6