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