Question: Construct an Excel sheet that will allow a user (other than yourself) to integrate a preset function with some flexibility. The sheet should allow the
Construct an Excel sheet that will allow a user (other than yourself) to integrate a preset function with some flexibility. The sheet should allow the user to define a function in cell B1, set an a value in cell B2, a b value in cell B3, and an n value in cell B4. You will not need to create restrictions on nonsensical user inputs, but your sheet should handle any integrable function for positive integer values of n and any choice of real number values a < b. Your sheet should handle n up to 1,000. This sheet will need to estimate the value of the integral using the following four methods: Right Riemann Sum, Left Riemann Sum, Midpoint Riemann Sum, and Trapezoidal Riemann Sum. Your submission will contain two parts. The first is the working Excel sheet. The second is a written discussion (in word processing software) where
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
