excel spreadsheet

From aerial view we will assume the wall takes on a sine function definition: y=Asin(Bx) We wish to build a wall with a straight distance end-to-end of 200ft(0ftx200ft). We will take amplitude A=3ft, and we wish that the sine wave has period of 20ft so that 10 total sine wave periods will build the complete wall. This means that value B=202=10. The are length of a function gives the total length of string needed to trace the graph on some interval. For example, the function y=1x2 on interval 1x1, which traces a semi-circle of radius 1 , would have are length L= since that would be half the circumference of a full circle of radius 1. In general, the arc length L of y=f(x) on axb is computed by the integral (see Thm. 2.4 in the Textbook): L=ab1+(f(x))2dx a.) For f(x)=3sin(10x), where f(x) and x are both measured in feet, compute the approximation S6 (the Simpson's rule approximation with n=6 panels) of the are length of one period (20ft ) of wall from aerial view. Report this value with units and rounded to 3 decimals for accuracy in the report for problem 3 . Note that the integrand must be constructed based on f(x), you are not integrating f(x) ! Simpson's rule can be found in the Textbook in Thm 3.6, equation 3.14. b.) Though Simpson's rule typically performs better than both Midpoint and Trapezoid rule for a given n, it is quite cumbersome to program into Excel. Let us get a better estimate of the length measurement from (3a.) with Midpoint rule with a higher n. Compute approximation M100 to approximate the are length of one period (20 linear ft ) of wall from aerial view in Excel. Report this value with units and rounded to 3 decimal places for accuracy in the report for problem 3b. c.) Based on your estimated are length of one period in (3b.), what is the total are length of the wall spanning all 200 feet? Report this value with units and to 3 decimal places for accuracy in your report for problem 3c. d.) If each brick is 12 inches in length, 4 inches tall and 8 inches wide, estimate how many bricks are needed to build the wall if it is 6ft high and 8 inches thick. Report this quantity, with justification and to the nearest integer, in your report for problem 3d